Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How do i generate report from BizTalk server 2006 R2. Is BAM useful?
- This topic has 5 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
July 11, 2008 at 6:43 AM #20125
Hi,
I have finished application and installed it in production. now my company wants me to design reports which helps to track messages, transfer history.
Is BAM useful for tracking the message history or generate some reports which helps to me to show our management? If yes then from where i can get sample application , tutorial or training video about BAM activities. If Biztalk 2006 R2 has some other good facilities that help to generate reports then plz let me know.
Regards,
– Dhaval M.
-
July 11, 2008 at 7:28 AM #20126
BAM might be a good choice for you. One of the main benefits of BAM is that you can configure it to track an app that is already in production with minimal impact to that app. In other words, you can set up BAM tracking with minimal code changes, sometimes none at all. Another benefit of BAM is that it is very high performance (so says Microsoft. It would be interesting to see a whitepaper on this). That said, there are some drawbacks: A) 1 MB size limit. If you want to store message bodies, BAM might not be the best place if the messages can get large. B) No foreign keys. C) Limited data types. I think you have about 4 data types to choose from. D) Limited UI. BAM does include a portal for viewing activities and aggregations, but it is not that flexible or easy to use. Unless your company is extremely flexible and forgiving about how they like to view their data, you will probably end up building the reports in a tool like SSRS.
The best information I have found on BAM is in the book: “Professional BizTalk Server 2006”. It has a whole chapter on BAM with samples.
-
July 11, 2008 at 11:12 AM #20129
Hi ,
I just goen through BAM reporting and its look very easy but i configured my BAM report using Office Excel 2007. After i configured that report using Tracking Profile Editor after that i apply that tracking profile on server i got following message
The tracking profile for Activity Definition TestTransformation was successfully applied.
Now i open BAM web site from Start->Programs->Biztalk server 2006 -> BAM Portal Web site.
But On web site i can see in left panel.
My Views No view to display I am not getting where i made a mistake.
Please help me to configured BAM report on portal.
Regards,
Dhaval M.
-
July 12, 2008 at 6:55 AM #20130
Did you create any views in Excel? I think you have to create a view in Excel and add dimensions and measures to get views to show up in the portal.
-
July 12, 2008 at 7:26 AM #20131
yeah, I have create one view using office excel 2007 but the way i show in excel 2003 in book and on other sites it seems look different. Is office 2007 excel is supported for creating view? and i have export XML from that excel file. and execute that xml from comand prompt using BM.EXE.
After i configured that report using Tracking Profile Editor after that i apply that tracking profile on server i got following message
The tracking profile for Activity Definition TestTransformation was successfully applied.
Now i open BAM web site from Start->Programs->Biztalk server 2006 -> BAM Portal Web site.
But On web site i can see in left panel.
My Views No view to display Please guide me if i miss any steps.
Regads,
Dhaval M.
-
July 13, 2008 at 6:44 AM #20132
Yes, Excel 2007 is supported for working with BAM. Here are some things you can check: Did you create any dimensions and measures in the views? After you have created the views in Excel, does the spreadsheet contain any pivot tables? You should have pivot tables on the spreadsheet as well a list of available fields. You have to drag and drop the fields from the field list onto the pivot tables to define how the views wil appear in the portal. Also, unless your views are defined as real time aggregations, you will have to run some SSIS packages to build the cubes that drive the portal. The packages are stored in MSDB and all have BAM somewhere in the name.
-
-
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.