Hi,

How could I summarize my measures for dimension Owner, which have 5 members,
without a all member level (no total for that dimension)?

My MDX-query:
SELECT {[Measures].[Tot Sales],
[Measures].[Previous YTD Sales],
[Measures].[YTD Growth],
[Measures].[YTD Förpackningar]} on columns,
{[Product].[Prodcategori].members} on rows
FROM Sales_cube
WHERE ([Period].[2005-04])

Thanks!

One way would be to define a calculated member on the Owner dimension
that aggregates the 5 members, like:

'Aggregate([Owner].[OwnerName].Members)'

SELECT {[Measures].[Tot Sales],
[Measures].[Previous YTD Sales],
[Measures].[YTD Growth],
[Measures].[YTD Förpackningar]} on columns,
{[Product].[Prodcategori].members} on rows
FROM Sales_cube
WHERE ([Period].[2005-04],[Owner].[AllOwners])

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks! It worked out fine!
/Magnus

"Deepak Puri" wrote: