Dynamic Pivoting as a Matrix Replacement Page 329
First of all this book is awesome and RESPECT TO ALL THE AUTHORS WHO HAVE SHARED THEIR KNOWLEDGE.
When creating the dataset using the Store Procedure that has the Dynamic Pivot query, my dataset is not populating the values. Can you elaborate this step for me.
EXACT PORTION THAT I HAVE PROBLEM.
2. Create a new dataset in the report titled ResellerSalesPivot with AdventureWorksDW as the
data source. Choose the Stored Procedure radio button and enter the usp_Sales_by_
Territory_Dynamic_Pivot stored procedure above in the entry line. Navigate to the
Parameters menu in the left-hand navigation bar and when prompted type the values 587 for
@productID, Europe for @territory, and 2003-07-01 for @startMonth. This step is necessary
in order for field metadata to be populated.
This book is 'the bomb'!!