Very Computer

I have two analytic dimensions in each of my cubes
(Analysis1 and Analysis2).  Both dimensions have one
member "Current".  In each cube I create calculated
members so the two dimensions wind up looking like:

Analytics1:
Current
MTD (month to date sub total)
YTD (year to date sub total)

Analytics2:
Current
Prior Year (Prior year function)

This design works like a champ in the cube browser.  When
I create a pivot table, I get weird results.

Basically, in a pivot table with the two fields in the
column position, both dimensions appear, but only
the "Current" fields are shown - the three calculated
measures will not display in the table.  When you click on
the selector for each dimension, the calculated members
appear with checks next to them, but again, the aren't
viewable in the pivot table.

If you move the dimensions to the Background position, you
are able to select the calculated measures and the data
does in fact correctly display.  Again, in the row or
column positions, these calculated measures don't display.

I am using a machine with Excel 2000 - is this the
problem?  I have another reporting tool (Intelligent Apps
for Excel) and that program is able to display the
calculated measures properly.  So it seems to be an excel
quirk or deficiency.

Anyone have any advice?

Thanks

Chris Locke

Quote:> Basically, in a pivot table with the two fields in the
> column position, both dimensions appear, but only
> the "Current" fields are shown - the three calculated
> measures will not display in the table.  When you click on
> the selector for each dimension, the calculated members
> appear with checks next to them, but again, the aren't
> viewable in the pivot table.

HTH
Szymon Slupik, CDN S.A.
Krakw, Poland