<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-15052112</id><updated>2011-12-29T07:38:47.182-07:00</updated><category term='BizTalk'/><category term='TDD'/><category term='BizMock'/><category term='Bizmonade'/><title type='text'>BizTodd</title><subtitle type='html'>All things BizTalk, SOA, and Agile</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://biztodd.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://biztodd.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>BizTodd</name><uri>http://www.blogger.com/profile/01738019446904936708</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://4.bp.blogspot.com/_24vspQcK9yQ/SzppeHS_thI/AAAAAAAAAAM/b_uZsBViUM4/S220/MyTag.JPG'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>9</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-15052112.post-7236296070298364167</id><published>2009-12-28T11:55:00.002-07:00</published><updated>2009-12-28T11:55:45.289-07:00</updated><title type='text'>What is the xRM Development Toolkit</title><content type='html'>This project provides classes to simplify Microsoft CRM 4.0 development. It provides functionality, developed in C#, to allow you to use custom .NET objects and properties and map them to CRM entities and attributes.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Some features include:&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;* Helpful extension methods for the CRM Service.&lt;br /&gt;&lt;br /&gt;* Allows you to use custom objects with the CRM Service, without having to convert them to dynamic entities or downloading the latest WSDL.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;The simple mapping between custom objects and CRM types that this toolkit provides means that managing, data-binding and extending CRM types can be accomplished with ease. This is ideal for any developer whether you're working with a small web application or a large scaled n-tier solution.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/15052112-7236296070298364167?l=biztodd.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://biztodd.blogspot.com/feeds/7236296070298364167/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=15052112&amp;postID=7236296070298364167' title='24 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/7236296070298364167'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/7236296070298364167'/><link rel='alternate' type='text/html' href='http://biztodd.blogspot.com/2009/12/what-is-xrm-development-toolkit.html' title='What is the xRM Development Toolkit'/><author><name>BizTodd</name><uri>http://www.blogger.com/profile/01738019446904936708</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://4.bp.blogspot.com/_24vspQcK9yQ/SzppeHS_thI/AAAAAAAAAAM/b_uZsBViUM4/S220/MyTag.JPG'/></author><thr:total>24</thr:total></entry><entry><id>tag:blogger.com,1999:blog-15052112.post-3611197745524169470</id><published>2009-12-28T11:54:00.000-07:00</published><updated>2009-12-28T11:54:04.523-07:00</updated><title type='text'>Keep Trying</title><content type='html'>In my normal manner, I am jumping around again.&amp;nbsp; I have working samples of Bizmonade and BizMock, so that means I need to play with something non-BizTalk related.&amp;nbsp; This week we will be playing with XRM Development Toolkit.&lt;br /&gt;&lt;br /&gt;The idea behind this project is to show how leveraging a framework for MSCRM can reduce time to market for integration projects.&lt;br /&gt;&lt;br /&gt;Setting up my CRM dev environment today.&lt;br /&gt;&lt;br /&gt;&lt;a href="http://xrm.codeplex.com/"&gt;http://xrm.codeplex.com/&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/15052112-3611197745524169470?l=biztodd.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://biztodd.blogspot.com/feeds/3611197745524169470/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=15052112&amp;postID=3611197745524169470' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/3611197745524169470'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/3611197745524169470'/><link rel='alternate' type='text/html' href='http://biztodd.blogspot.com/2009/12/keep-trying.html' title='Keep Trying'/><author><name>BizTodd</name><uri>http://www.blogger.com/profile/01738019446904936708</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://4.bp.blogspot.com/_24vspQcK9yQ/SzppeHS_thI/AAAAAAAAAAM/b_uZsBViUM4/S220/MyTag.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-15052112.post-5383759714035564180</id><published>2009-12-18T08:03:00.000-07:00</published><updated>2009-12-18T08:03:19.918-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='BizTalk'/><category scheme='http://www.blogger.com/atom/ns#' term='Bizmonade'/><category scheme='http://www.blogger.com/atom/ns#' term='TDD'/><title type='text'>What is Bizmonade</title><content type='html'>If you do end up following my attempts at being a blogger, the one thing you will quickly realize is that I am slightly scitzophrenic.&amp;nbsp; I like to jump from topic to topic at times.&amp;nbsp; Anyways, I have been having issues with my BizMock tests, so rather than get too frustrated I turned my attention to &lt;a href="http://bizmonade.matricis.com/"&gt;Bizmonade&lt;/a&gt;.&amp;nbsp; So, what is Bizmonade...&lt;br /&gt;&lt;br /&gt;Bizmonade allows running orchestrations directly from unit tests written in C#, using NUnit, MSTest or any another .Net testing tool (But only supports NUnit out of the box as of this post). The orchestrations therefore run in complete isolation from the whole BizTalk environment, reducing the time needed to do quick tests of new orchestrations or of modifications to existing ones. The orchestrations can be tested without waiting for deployment scripts to run, and without worrying about technical communication details (server adresses, authentication details, file system paths, message encoding, encryption, mappings...) &lt;br /&gt;&lt;br /&gt;It looks very promising, although it is not without its issues.&amp;nbsp; If you do download it, or try to use it, keep in mind it is an alpha or beta concept at best.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/15052112-5383759714035564180?l=biztodd.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://biztodd.blogspot.com/feeds/5383759714035564180/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=15052112&amp;postID=5383759714035564180' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/5383759714035564180'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/5383759714035564180'/><link rel='alternate' type='text/html' href='http://biztodd.blogspot.com/2009/12/what-is-bizmonade.html' title='What is Bizmonade'/><author><name>BizTodd</name><uri>http://www.blogger.com/profile/01738019446904936708</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://4.bp.blogspot.com/_24vspQcK9yQ/SzppeHS_thI/AAAAAAAAAAM/b_uZsBViUM4/S220/MyTag.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-15052112.post-3320106555071220299</id><published>2009-12-15T13:20:00.001-07:00</published><updated>2009-12-16T10:58:33.834-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='BizTalk'/><title type='text'>Issues with Simple Type Definition</title><content type='html'>Yesterday afternoon I was working on my BizMock demo when I&amp;nbsp;tried to validate a schema using the BizMock test (I know it is redundant now that BTS supports schema tests).&amp;nbsp; I got a very strange error&amp;nbsp;&amp;nbsp;(System.Xml.Schema.XmlSchemaException) The content type of the base type must not be a simple type definition."&lt;br /&gt;&lt;br /&gt;Huh?&amp;nbsp; My schema already passed using BizTalk's out of the box testing.&amp;nbsp; Did I mess up my artifacts? Doesn't look like it.&lt;br /&gt;&lt;br /&gt;Time to check Bing.&amp;nbsp; I found these two links (I found 3 but suspense is good for the plot).&lt;br /&gt;&lt;br /&gt;&lt;a href="http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/1f7a3d32-2f31-4426-afe2-2a50b0792b46"&gt;http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/1f7a3d32-2f31-4426-afe2-2a50b0792b46&lt;/a&gt;&lt;br /&gt;&lt;a href="http://support.microsoft.com/kb/957206"&gt;http://support.microsoft.com/kb/957206&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Wow, both of these have to do with a hotfix for .Net 1.1 - Do I really need these, and how do I get them anyways.&lt;br /&gt;I think not, because I found this 3rd post by a colleague of mine Danile Sepp &lt;a href="http://blogs.neudesic.com/blogs/daniel_sepp/default.aspx"&gt;http://blogs.neudesic.com/blogs/daniel_sepp/default.aspx&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;In it he talks about a work around for dealing with Simple Types - I had to manually build an OTA schema which was no fun, but at least my testing now works.&amp;nbsp; It is strange that if this is a bug of sorts, that the BizTalk testing framework didn't find it, but a 3rd party testing framework did.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/15052112-3320106555071220299?l=biztodd.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://biztodd.blogspot.com/feeds/3320106555071220299/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=15052112&amp;postID=3320106555071220299' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/3320106555071220299'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/3320106555071220299'/><link rel='alternate' type='text/html' href='http://biztodd.blogspot.com/2009/12/issues-with-simple-type-definition.html' title='Issues with Simple Type Definition'/><author><name>BizTodd</name><uri>http://www.blogger.com/profile/01738019446904936708</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://4.bp.blogspot.com/_24vspQcK9yQ/SzppeHS_thI/AAAAAAAAAAM/b_uZsBViUM4/S220/MyTag.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-15052112.post-833399018863687908</id><published>2009-12-15T08:00:00.001-07:00</published><updated>2009-12-16T10:58:10.589-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='BizTalk'/><category scheme='http://www.blogger.com/atom/ns#' term='BizMock'/><title type='text'>BizMock Recieve Adapter</title><content type='html'>I seem to have a strange behaviour with my BizMock recieve adapter.&amp;nbsp; After 10 minutes or so, I start to get errors like this&lt;br /&gt;&lt;br /&gt;The receive location "xxx.BizMock" with URL "BizMock://xxx.BizMock" is shutting down. Details:"The Messaging Engine failed while notifying an adapter of its configuration. ".&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;I am going to have to dig into this one.&amp;nbsp; I know it must be something I am doing (Like all my failed tests) to cause this, because the Out-of-the-Box sample work and run just fine.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/15052112-833399018863687908?l=biztodd.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://biztodd.blogspot.com/feeds/833399018863687908/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=15052112&amp;postID=833399018863687908' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/833399018863687908'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/833399018863687908'/><link rel='alternate' type='text/html' href='http://biztodd.blogspot.com/2009/12/bizmock-recieve-adapter.html' title='BizMock Recieve Adapter'/><author><name>BizTodd</name><uri>http://www.blogger.com/profile/01738019446904936708</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://4.bp.blogspot.com/_24vspQcK9yQ/SzppeHS_thI/AAAAAAAAAAM/b_uZsBViUM4/S220/MyTag.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-15052112.post-1749948332610083414</id><published>2009-12-14T18:23:00.005-07:00</published><updated>2009-12-16T10:57:33.104-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='BizTalk'/><category scheme='http://www.blogger.com/atom/ns#' term='BizMock'/><category scheme='http://www.blogger.com/atom/ns#' term='TDD'/><title type='text'>What is BizMock</title><content type='html'>BizMock is a framework for testing BizTalk solutions, using a Domain Driven Design (DDD) approach and fluent interface API. It has mocking capabilities, so no need to rely on dependent infraestructure like web services or DBs. The tests are writen and executed from within VS using regular Visual Studio Tests and C# code, allowing a TDD and agile development style of BizTalk solutions. &lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;it's main advantages are:&lt;br /&gt;&lt;br /&gt;Rapid testing of Biztalk scenarios ( no more excuses to not test biztalk code) &lt;br /&gt;&lt;br /&gt;No need to leave the Visual Studio IDE &lt;br /&gt;&lt;br /&gt;We use regular Visual Studio C# Unit Tests code ( no puzzling xml) . &lt;br /&gt;&lt;br /&gt;Favors agile iterative development cycles with continous Integration. &lt;br /&gt;&lt;br /&gt;No need to rely on real implementations of dependent infraestructure like web services, Databases, etc. ( isolated on the developer machine or build server ) &lt;br /&gt;&lt;br /&gt;Increasead level of abstraction thanks to its Domain Driven Design approach and fluent interface. &lt;br /&gt;&lt;br /&gt;Rapid and guided development thanks to intelisense and its fluent interface API. &lt;br /&gt;&lt;br /&gt;Reusability of domain artifacts across tests, like ports, messages, verifiers etc. &lt;br /&gt;&lt;br /&gt;Extensibility model to allow the creation of new artifacts, actions, and expectations types over time and reused across solutions &lt;br /&gt;&lt;br /&gt;Leverages DDT ( Data Driven Test) &lt;br /&gt;&lt;br /&gt;In future releases can be enhanced with Visual Studio addins and tools: to automatically update deployments, autogenerate artifacts, autogenerate map and message verifiers tests. &lt;br /&gt;&lt;br /&gt;In future releases can be enhanced with guidance automation to guide the process and implement best practices &lt;br /&gt;&lt;br /&gt;In fututre realeases can be integrated wirth functional testing tools like FIT, to quickly create integration scenarios test cases &lt;br /&gt;&lt;br /&gt;To know more visit &lt;a href="http://www.codeplex.com/bizmock"&gt;http://www.codeplex.com/bizmock&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/15052112-1749948332610083414?l=biztodd.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://biztodd.blogspot.com/feeds/1749948332610083414/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=15052112&amp;postID=1749948332610083414' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/1749948332610083414'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/1749948332610083414'/><link rel='alternate' type='text/html' href='http://biztodd.blogspot.com/2009/12/what-is-bizmock.html' title='What is BizMock'/><author><name>BizTodd</name><uri>http://www.blogger.com/profile/01738019446904936708</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://4.bp.blogspot.com/_24vspQcK9yQ/SzppeHS_thI/AAAAAAAAAAM/b_uZsBViUM4/S220/MyTag.JPG'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-15052112.post-8266192636465909478</id><published>2009-12-14T18:22:00.000-07:00</published><updated>2009-12-14T18:22:39.028-07:00</updated><title type='text'>Making a comeback</title><content type='html'>I have not done a blog post in forever.&amp;nbsp; It probably won't change anytime sone, but we are going to try.&amp;nbsp; I plan to use this blog to cronicle my experiences using TDD concepts and BizTalk to solve hospitality scenarios.&lt;br /&gt;&lt;br /&gt;I have two that I am working on right now.&amp;nbsp; The first will use BizTalk 2009 to expose an Open Travel Authority (OTA) ReadRQ message and consume Expedia Quick Connect (EQC) services.&amp;nbsp; The first testing framework I will dive into is BizMock.&amp;nbsp; I figure that the developers who are looking at this post, probably already have BTS processes in production, and need to retro fit them with some testing.&amp;nbsp; BizMock is a good place to start.&lt;br /&gt;&lt;br /&gt;Let the adventures begin.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/15052112-8266192636465909478?l=biztodd.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://biztodd.blogspot.com/feeds/8266192636465909478/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=15052112&amp;postID=8266192636465909478' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/8266192636465909478'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/8266192636465909478'/><link rel='alternate' type='text/html' href='http://biztodd.blogspot.com/2009/12/making-comeback.html' title='Making a comeback'/><author><name>BizTodd</name><uri>http://www.blogger.com/profile/01738019446904936708</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://4.bp.blogspot.com/_24vspQcK9yQ/SzppeHS_thI/AAAAAAAAAAM/b_uZsBViUM4/S220/MyTag.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-15052112.post-112308522010653702</id><published>2005-08-03T08:58:00.000-07:00</published><updated>2005-08-03T09:08:14.450-07:00</updated><title type='text'>Bam Business Milestones</title><content type='html'>So you are starting to realize the potential of BAM, but you notice that the times in your Business Milestones are a bit off. This is because BizTalk logs Business Milestones in UTC. So, I thought I would help you all fix this to show the time in your local time zone.&lt;br /&gt;&lt;br /&gt;If you get into the DB call BAMPrimaryImport, and look for a SP call bam_ActivityName_PrimaryImport we are going to add a few statements after the BEGIN statement.&lt;br /&gt;&lt;br /&gt;--A variable to hold the difference between UTC and your local time&lt;br /&gt;DECLARE @TimeDifference int&lt;br /&gt;&lt;br /&gt;--Calculate the difference&lt;br /&gt;SELECT @TimeDifference = ROUND(DATEDIFF(mi, GetUTCDate(), GetDate()), -1)&lt;br /&gt;&lt;br /&gt;--Fix the time difference&lt;br /&gt;SELECT @BusinessMilestone = DATEADD(mi, @TimeDifference, @BusinessMilestone)&lt;br /&gt;SELECT @2ndBusinessMilestone = DATEADD(mi, @TimeDifference, @2ndBusinessMilestone)&lt;br /&gt;&lt;br /&gt;Ther you go! Now you will need to do this for each Activity you defined.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/15052112-112308522010653702?l=biztodd.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://biztodd.blogspot.com/feeds/112308522010653702/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=15052112&amp;postID=112308522010653702' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/112308522010653702'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/112308522010653702'/><link rel='alternate' type='text/html' href='http://biztodd.blogspot.com/2005/08/bam-business-milestones.html' title='Bam Business Milestones'/><author><name>BizTodd</name><uri>http://www.blogger.com/profile/01738019446904936708</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://4.bp.blogspot.com/_24vspQcK9yQ/SzppeHS_thI/AAAAAAAAAAM/b_uZsBViUM4/S220/MyTag.JPG'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-15052112.post-112301928076202379</id><published>2005-08-02T14:45:00.000-07:00</published><updated>2005-08-02T14:55:38.096-07:00</updated><title type='text'>Bam Durations</title><content type='html'>Ever notice the duration field in a BAM query? You end up with a value like 1.102304-3e. Well BAM by default shows you the duration in days. It is iactually quite easy to adjust this to whatever you want.&lt;br /&gt;&lt;br /&gt;All you need to do is make a change to two of the views that are created for you;&lt;br /&gt;1. The ActiveAliasView&lt;br /&gt;2. The CompletedAliasView&lt;br /&gt;&lt;br /&gt;Both of which can be found in BAMPrimaryImport. You are loking for a statement that will look like this;&lt;br /&gt;&lt;br /&gt;[Duration] = CAST([TimeStamp] AS FLOAT) - CAST([TimeStamp] AS FLOAT&lt;br /&gt;&lt;br /&gt;What you need to add is this;&lt;br /&gt;[Duration] = CAST([TimeStamp] AS FLOAT)*24(For Days)*60(For Minutes)*60(For Seconds) - CAST([TimeStamp] AS FLOAT*24*60*60&lt;br /&gt;&lt;br /&gt;You will notice that if you query the BAMPrimaryImport DB that all the durations will appear as seconds, but if you have a processed cube, it will still reflect the old data, and when you add the new data, it will become unreliable. So if you need to do this, you must be prepared to start the cubes from scratch.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/15052112-112301928076202379?l=biztodd.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://biztodd.blogspot.com/feeds/112301928076202379/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=15052112&amp;postID=112301928076202379' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/112301928076202379'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/15052112/posts/default/112301928076202379'/><link rel='alternate' type='text/html' href='http://biztodd.blogspot.com/2005/08/bam-durations.html' title='Bam Durations'/><author><name>BizTodd</name><uri>http://www.blogger.com/profile/01738019446904936708</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='http://4.bp.blogspot.com/_24vspQcK9yQ/SzppeHS_thI/AAAAAAAAAAM/b_uZsBViUM4/S220/MyTag.JPG'/></author><thr:total>1</thr:total></entry></feed>
