Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2007 pivot table using analysis services cube as data source
Hi,
I have created a pivot table using excel 2007 with an analysis services cube being used as the data source. The cube has numerous dimension tables and four fact tables. When I try to drill down into a value in the pivot table, the results that are returned contain the Keys to the dimension tables that reference the actual data but not the actual data itself. Has anyone else experienced this type of problem before? Do you know what I need to change in order to return the detailed data and not the keys? Any help would be greatly appreciated. Thank you, PH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table-Change Data Source? Excel 2007 | Charts and Charting in Excel | |||
Excel 2007 Pivot Table Changes the Source Data Range | Excel Discussion (Misc queries) | |||
BIDS - Excel Pivot Table - Data Cube - What - if analysis | Excel Programming | |||
#Value in Analysis Services Pivot Table | Excel Discussion (Misc queries) | |||
Sorting by Measures from Analysis Services cube source | Excel Programming |