1. Pivot Table with "Faked Dimensions"
Thanks to those of you who helped me understand how to
fake a dimension for analytics; what a time saver and
design improvement.
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
2. VB Desktop Application Accessing SQL Server on Web Server
3. max of ("...","...","..")
4. oracle on Linux
5. "Hidden" Dimension
6. subscription to publication 'XXXX' is invalid
7. "Optional" Page Axis Dimension in MDX
8. open an Access form from VB
9. "default" rows and columns dimensions
10. Create "replacement" labels for a dimension
11. Dealing with "OR" dimensions
12. Unexplained "Dimension Member Not Unique" error
13. Dimensions maintain "memory"