Hi everyone,
I have this MDX query:
WITH
Set [CompanySet] as
'{[Company].[All Company].[Microsoft],[Company].[All Company].[Apple]}'
MEMBER
[Company].Selection as 'Sum([CompanySet])'
Set [DateSet] as
'{[Date].[All Date].[2005].[1].[1].[1]:[Date].[All
Date].[2005].[4].[12].[1]}'
SELECT
Non Empty [Measures].allmembers ON COLUMNS,
NonEmptyCrossJoin(
[program].[operatortype].Members,[Product].[productName].Members,[CompanySet], [DateSet], 2) on rows
FROM [ADV_SMALL]
WHERE ([Date].DateRange,[Company].Selection)

that return :
Program product Measures.....
__________________________________________________
Internet office 343255
Internet Mac 6786567
Paper windows 5435432
radio office 769876
Internet windows 7898

etc.
i wont to sort the result by program ASC and than Product ASC
How do i do that?
thanks

Hi!

Do you want to get [program].members and [product].members ordered by Member
Caption?

Vladimir Chtepa



"Ruby Nadler" <RubyNadler (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:8B5863AF-1CBD-42AF-BFC9-B05665935876 (AT) microsoft (DOT) com...

Hi Vladimir,
I want to sort by
[program].[operatortype].Members BASC AND [Product].[productName].Members
BASC.
one more question about this query: in the rows i want to show the
[Product].[productName].Members level and instead the mdx returns all levels
of product dimension: Branch--> AubBranch-->ProductName. why?
thanks,
Ruby
"Vladimir Chtepa" wrote: