January 26, 2011 at 10:09 am
Hi,
I am a newbie to SSAS cubes.I have created a cube which consists of 2 tables in the database.
There are many columns in it for the reporting team.
I need only specific columns in the pivot table report.
I can see that there are 4 items in the right area namely report filter, column labels, row labels and values. I dont know how to use the tables, its columns and the 4 areas to create a pivot table report.
It says choose fields from the pivot table filed list, I did try many times, but the order of the data in hte excel file is abnormal like the column values are way too much some time or the filter values are not working.
How can I do that?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
January 26, 2011 at 10:13 am
The user wants to see receipts for goods purchased over a period of time.
For example, he wants to see the purchase receipts for vendor 'XYZ' for the duration '2010'.
The data fields he is interested are PO number,item no, desc, quantity, price etc.
How can i make that report, i mean, whcih data i have to put in whcih area like rows or columns or report filter....to get hte desired output.
I am confused.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply