Hi, I have a cube with the following dimensions and measures:
[DimQuestion]
[DimUser]
[DimAnswer]
[Measures].[Answer]
The [Answer] measure is a integer value between 0 and 10.
My goal is to create a custom calculated member that return's the answer that
most appears in the current context. I don't know the correct math function's
name in english, but in portuguese is called as "MODA".
I've used the following sintaxe to calculate the STDEVP and I need to
reproduce some similar behavior that the STDEVP internaly's uses to navigate
through all children values and calculate the standard deviation:
STDEVP( [DimAnswer].Children, [Measures].[Answer])
Could someone please help me?
Thanks!
Oberdan
Oberdan Borges Nunes
View Complete Post