How do i generate report from BizTalk server 2006 R2. Is BAM useful?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How do i generate report from BizTalk server 2006 R2. Is BAM useful?

Viewing 1 reply thread
  • Author
    Posts
    • #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.

    • #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.

      • #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.

        • #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.

          • #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.

            • #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.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.