Excel 2007 pivot table using analysis services cube as data source

[Peggy Holzkopf]

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




--
Peggy Holzkopf