MDX Question   

I have a question regarding creating subtotals in MDX.

Say we have a cube ("rent") with the following dimensions:
Year
Month
Version
Region
Office
Rent Classification
Rent Measure

And I have the following query:

SELECT
NON EMPTY
{
{[rent classification].[all rent classifications].children}
 *
{[region].[New South Wales].Children,[region].[New South Wales]}
*
[office].[all offices].children
} ON ROWS,
{[rent measure].[total rent]} ON COLUMNS
FROM [rent]
WHERE
(
[year].[2008],
[month].[august],
[version].[budget]
)

My apologies if the syntax is a little off, I'm actually using MDX for
TM1 not Analysis Services, but as far as I know the syntax should be
pretty much the same.

What I'd like to do is somehow have the query return the crossjoin of
[region].[New South Wales].Children and [office].[all
offices].children and then [region].[New South Wales], [office].[all
offices] as a subtotal for each of the rent classifications.

So far I've tried to do this using filters on the levels and such,
which is a bit slow, and also tried a couple of other ways, like
manually putting in all the rent classifications and for each of them
having the detail and then subtotals. I'm basically just curious if
there is a better way to do it.

Any help would be greatly appreciated. If there's anything anyone
would like me to clarify further, please let me know.

Thanks very much.

date: Mon, 11 Aug 2008 18:59:15 -0700 (PDT)   author:   unknown