Hello,
I have to implement a average measure with a activity measure (regular weight) in Dynamic cube: Avg of Column1 with activity measure Column2
In Transformer I created a non visible measure for column2, set set the measure to Column1 with this non visible measure as regular weight.
Col1 Col2
23 1
14 0
15 1
Avg measure should result in 19 (in Transformer).
How do I implement this in Cube Designer? I have defined 2 measures one for Column1 and one for Column2. Then I created a calculated measure with measure1*measure2. Unfortunately, The two measures are summarized before the calculated measure is calculated. Therefore I get sum(Col1)*sum(Col2) = 67.
I think I have to implement this somehow with dimensional functions, but where do I find a guidance?
Thanks