dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

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 ...


Home > Database Forum > Data Warehousing > olap > MDX Order issue with BDESC

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 09-30-2008, 12:51 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default MDX Order issue with BDESC

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
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 11:06 PM.