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