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?