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