|
Guest
|
I am using the following MDX query on Adventure Works DW sample
database.
The issue is that SSAS is returning the result that is not fully
sorted in descending order even if I am enforcing break hierarchy with
BDESC.
Please let me know if I am missing something or the MDX has some
issues?
SELECT NON EMPTY {Order(TopCount({Crossjoin({[Measures].[Discount
Amount]},{[Date].[Calendar].[Calendar Year].&[2004].Children})},20,
[Measures].[Discount Amount]),[Measures].[Discount Amount],BDESC)} ON
COLUMNS,
NON EMPTY {Order(TopCount({[Geography].[Geography].[Country].&[United
States].Children},20,[Measures].[Discount Amount]),[Measures].
[Discount Amount],BDESC)} ON ROWS
FROM "Adventure Works DW"
The Query result is as shown below:
Discount Amount
H1 CY 2004
California $5,460.13
Washington $3,168.88
Utah $2,541.77
Tennessee $45.20
Oregon $0.00
Texas $1,811.34
Arizona $2,051.87
Nevada $808.34
Florida $314.27
Colorado $3,407.77
New Mexico $82.38
Michigan $617.76
New Hampshire $752.55
Ohio $322.59
New York $455.17
Missouri $1,091.53
Wyoming $2,409.90
North Carolina $90.40
Georgia $587.43
South Dakota $0.00
Any help on this is highly appreciated.
Regards,
Rupesh |
|
|
