Trouble Generating 'Totals' & 'Grand Total' with MDX stmt.

Hi,

The following query gives 'Items Sold' by Region & by State nicely. I want
to include 'Totals' & 'Grand Total'. Can the experts help with the MDX query
please?

SELECT
[Measures].[Items Sold] ON COLUMNS,
CROSSJOIN([Geog].[REGION_CD].Children,
[Geog].[STATE_ROLLUP_CD].children) ON ROWS
FROM
[SALES CUBE]

Items Sold
Mid-Atlantic Delaware 100
Mid-Atlantic Columbia 200
Mid-Atlantic Maryland 300
TOTAL 600
North Central Colorado 250
North Central Illinois 350
North Central Indiana 300
TOTAL 900
GRAND TOTAL 1,500

I tried the following MDX stmt and got sort of 'Totals' & 'Grand Totals'
(Labels are bad, could not customize). But the query generated too many
'Grand Total' rows at the end instead of 1 final GT because of CROSS JOIN.

SELECT
[Measures].[Items Sold] ON COLUMNS,
CROSSJOIN(
{[Geog].[REGION_CD].Children, [Geog].[REGION_CD]},
{[Geog].[STATE_ROLLUP_CD].children, [Geog].[STATE_ROLLUP_CD]}) ON ROWS
FROM
[SALES CUBE]

How to just get 1 Grand Total at the end & customize the Total & GT labels?

Thanks,

Venkat.

hi

I am new to data warehousing . Pls guide me how to make cubes or
reporting services .

mi gmailId is er.rahuls85

I am not sure why you replied to my post. If you need help, you should post
it as a question/ new request.

Thanks

Venkat.

"raul" wrote:

> hi
>
> I am new to data warehousing . Pls guide me how to make cubes or
> reporting services .
>
> mi gmailId is er.rahuls85
>