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