Thanks to those of you who helped me understand how to
fake a dimension for analytics; what a time saver and
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:
MTD (month to date sub total)
YTD (year to date sub total)
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?