Hi group!

Is there a way of querying for a total of the axes?

I want to show:

2002 2003 Total Time
Total Product 30 30 60
Product 1 10 10 20
Product 2 20 20 40

I cannot use {[Dimension].DefaultMember} because i will get the grand
totals, not row/column totals.

You can use the MDX VisualTotals() function.
Here is an example from Foodmart Sales cube:

[Time].[1997].[Q3]}, "Total - *") on Columns,
VisualTotals({[Product].[All Products].[Food],[Breakfast
Foods], [Canned Foods], [Frozen Foods]}, "Total - *") on Rows
From Sales
Where ([Measures].[Store Sales])
- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!