MDX question about a measure from a dimension

Question

Post reply

MDX question about a measure from a dimension

darth_vodka

Default port

Points: 1489
More actions
May 18, 2011 at 2:30 am

#239760

hi
if i create a measure from a dimension and have that dimension on the rows, it works, but 1) the All isn't summed and 2) if i take it off the rows, it gives zero values
with member [measures].[test]
as
strtovalue([Deals BOID].[Deal Rate].CurrentMember.properties("Key"))
select
[measures].[test] on columns,
Nonempty
({
[Deals BOID].[Deal Rate].members
//[CCY Pair].[CCY Pair].members
}) on rows
from
[BRS2]
if you toggle the commented line from Rate to CCY, it goes wrong
so my question is...
I think I have this wrong in my head, how come the [All] member populate with the sum of the values
And...more generally, how do i create a measure from a dimension, but make it aggregate?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Kees Beimans SSC Eights! Points: 978 More actions · Answer 1

Hi

try this:

[font="Tahoma"]

WITH MEMBER [measures].[test]

AS SUM ( Existing ([Deals BOID].[Deal Rate].[Deal Rate].members )

, strtovalue([Deals BOID].[Deal Rate].CurrentMember.properties("Key"))

//, Cint ( [Deals BOID].[Deal Rate].CurrentMember.membervalue ) -- membervalue can be a float, numeric type..

)

SELECT [measures].[test] ON COLUMNS,

Nonempty ({ [Deals BOID].[Deal Rate].members

//[CCY Pair].[CCY Pair].members

})

ON ROWS

from[BRS2][/font]

Regards Kees

darth_vodka Default port Points: 1489 More actions · Answer 2

nope

does the same i'm afraid

i've done it a different way now and it works as long as (strangely) i have something on the rows

will give to the users for testing and will start a new thread if this isn't enough

thanks

harsha123 Newbie Points: 3 More actions · Answer 3

Hi,

how did you solve this problem. I am facing similar problem. I want to display dimension value as a measure, but i don't want use that dimension on my axis. I am getting all 0's or "unknown".