I have the following calculated measure: MeasureX = MeasureA * MeasureB.
I only want the calculation to apply at the leaf level, then the answer should rollup automatically to higher levels.
So instead of Sum(MeasureA) + sum(MeasureB). I need sum(MeasureX)
The solutions I've found for this issue, refer to the relational engine to solve the problem: etl/dsv/calc column.
But I need it to be solved in the cube.
MCITP BI Developer 2008 - MCTS SQL Server 2005
View Complete Post