Excel 2007 pivot table using analysis services cube as data source

P

Peggy Holzkopf

Hi,

I have created a pivot table using excel 2007 with an analysis service
cube being used as the data source. The cube has numerous dimensio
tables and four fact tables. When I try to drill down into a value i
the pivot table, the results that are returned contain the Keys to th
dimension tables that reference the actual data but not the actual dat
itself.

Has anyone else experienced this type of problem before? Do you kno
what I need to change in order to return the detailed data and not th
keys?

Any help would be greatly appreciated.

Thank you,
P
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top