Monday, March 12, 2012

MDX select with no aggregation

Dear All,

I tryed to do the following

OpenQuery([ssas DS], select {[Measures].[Weekday], [Measures].[Weekday], [Measures].[sales count]} on columns,
{[Dim Time].[Weekday].members} on rows
from CubeName)

It returns me the followings:

Weekday Weekday Sales Count
All 5 5 20402295
1 1 1 3445560
2 2 2 3950970
3 3 3 4532115
4 4 4 4498965
5 5 5 3974685

But I don't want the row "All 5 5 20402295" to be included in the row how can I remove it from the rowset?

Thanks

Tony Chun Tung Siu

Try replacing {[Dim Time].[Weekday].members} with {[Dim Time].[Weekday].[Weekday].members}

No comments:

Post a Comment