MDX Order issue with BDESC - olap
This is a discussion on MDX Order issue with BDESC - olap ; 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 ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| 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 |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
All times are GMT -4. The time now is 11:06 PM.




Linear Mode