Hi :)

I have to multiply some measure by value from dimension attribute.

I'm trying to make regular measure from this attribute and then i would can multiply

my code is:

CREATE MEMBER CURRENTCUBE.[Measures].[Formulaa]
 AS (
[DIM RESOURCE].[Formula].Member_Value
 
),
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Machine Production'  ;  

CREATE MEMBER CURRENTCUBE.[Measures].[Formulaaa]
 AS (
[Measures].[Formulaa] * [Measures].[Line Quantity In]
 
),
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Machine Production'  ;  

and it's working until i have in my browser (or query)  [DIM RESOURCE].[Formula] attribute

when i remove it - i'm getting in [Measures].[Formulaa] the All value

so my question is: what i should do to avoid browsing this attribute?

Hi,

so the problem is that you dont have the right values on the all node? -right?

you could make a leaf level calculation and then sum up to your all-node.

Kr Jrgen

Hi,

so the problem is that you dont have the right values on the all node? -right?

you could make a leaf level calculation and then sum up to your all-node.

Kr Jrgen

Thanks for answer.

Yes.

I only want go through All and get value from lower level without sum.

Hi ppatyk,

According to your description, you want to avoid getting the sum value when selecting ALL members with calculated measure. Right?

In this scenario, since your calculated measure is showing the dimension member's value, it must be based on the dimension you select on rows. Otherwise, it will return the aggregation value. Each dimension member value is different, if you go through ALL, it can't determine which child member value should be displayed. So in this scenario, you must select [DIM RESOURCE].[Formula] attribute so that your calculated measure can return the corresponding value.

Best Regards,