Multiple BAM Pivot Tables (Aggregations) per One View

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Multiple BAM Pivot Tables (Aggregations) per One View

Viewing 1 reply thread
  • Author
    Posts
    • #18612

      In my mind, I’m missing the relationship between views and Pivot Tables.

      According to “Professional BizTalk Server 2006” by Jefford et.al, page 276, “your Excel workbook will contain a tab for each view.  Within these workbooks, you will have a PivotTable for each dimension that has been created.” 

      Is this true?   I’m doing a simple demonstration for a BAM Video Training product.  I have a simple PO (Purchase Order) scenario, with 4 dimensions (3 data dimensions BillToState, ShipToState, CustNum, and one TimeDimension DatePORcvd), but I only get one Pivot Table.  The Pivot Table works fine, I deployed it, ran orchestrations, and have data.  But I’m trying to figure out how to get multiple pivot tables, and how to show multiple aggregations in the BAM Event Viewer.

      Any ideas or explanation would be greatly appreciated.
      Neal Walters
      http://Biztalk-Training.com

       

       

    • #18644

      Neal,

      Thanks for your post, a good spot on a minor error in this chapter. You get a tab per Activity View but only one default PivotTable within that view not one per dimension as the chapter says. I’ll get this added to the book errata on the Wiley site.

      A given view can have many Pivot Tables but by default your only given one. If you select the default PivotTable created for you and copy/paste you can create further PivotTables within the Activity View tab that you can customise as you see fit to reflect each dimension. There may be a more elegant way but my Office skills don’t stretch that far!

      Remember to right-click each newly created PivotTable and choose PivotTable options to change it’s name otherwise when you deploy your observation model the BAM Portal will just show PivotTable1, PivotTable2, etc.

      Hope this helps

      Darren

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