Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Help MDX sort from measure
1 view
Skip to first unread message
Carnefrisca
Oct 19, 2009, 6:39:00 AM10/19/09
to
this is my case...
i have a measure called
Rank with this value:
3
2
4
1
i have a measure called
Rank with this value:
3
2
4
1
ad a dimension OPTION with the members
OPTION - Percentage
opt1 - 39%
opt2 - 36%
opt3 - 16%
opt4 - 6%
... - ...
opt20 - null
i want to change the order of dim relate to my Rank measure values
for example.
RANK - OPTION - Percentage
3 - Opt3 - 16%
2 - Opt2 - 36%
4 - Opt4 - 6%
1 - Opt1 - 39%
please help me...
i try this [Option].[Option].[Option].item([Measures].[New
Rank]).unique_name as member
and i receive this,
[OPTION].[OPTION].&[3]
[OPTION].[OPTION].&[2]
[OPTION].[OPTION].&[4]
[OPTION].[OPTION].&[1]
there is way,from this, to receive my percentage ordered?
please help me
dpuri
Oct 28, 2009, 6:30:25 PM10/28/09
to
Could you explain how Percentage is derived from dimension OPTION - is
it an attribute?
it an attribute?
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***
0 new messages