I have a client who has a series of Pivot tables based on an (online) OLAP
cube.

Some of the data does not look right, and they want to query the source
data, but they do not know where it is.

Is there a way to backtrack from the Pivot table, to find where the Cube is
or where the original source of the cube is? (Where is the source of the
Pivot Table)

The data is dynamic and can be refreshed.
In the PT wizard, the back button is greyed out, so while one can go to
layout, one cannot see the source through the wizard.

Please: any ideas on how to track down the source would be welcome.

Ron Coderre has a pivot table add-in that lets you find the source, in
Excel 2002 or Excel 2003:

http://www.contextures.com/xlPivotPlay01.html


Katie wrote:
I have a client who has a series of Pivot tables based on an (online) OLAP
cube.

Some of the data does not look right, and they want to query the source
data, but they do not know where it is.

Is there a way to backtrack from the Pivot table, to find where the Cube is
or where the original source of the cube is? (Where is the source of the
Pivot Table)

The data is dynamic and can be refreshed.
In the PT wizard, the back button is greyed out, so while one can go to
layout, one cannot see the source through the wizard.

Please: any ideas on how to track down the source would be welcome.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html