Hi

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.

Thanks,

Jason

MCITP BI Developer 2008 - MCTS SQL Server 2005

**View Complete Post**

## How to get calculated measure to rollup correctly?

Hi,

I have created a calculated measure that computes a weighted ratio for the current balance of all loans that fall into various risk ratings:

WITH

MEMBER [MEASURES].[Weighted Ratio] AS

(Measures.[Current Balance] * [Risk Rating].[Loan Rating Code].CurrentMember.member_value) /

(

[Measures].[Current Balance],

Ancestor([Risk Rating].[Loan Rating Code].CurrentMember, 1)

), FORMAT_STRING = "Standard"

SELECT

{[Measures].[Current Balance], [Measures].[Weighted Ratio]} on COLUMNS,

[Risk Rating].[Loan Rating Code].MEMBERS ON ROWS

FROM

[Test Cube]

The problem is that the results come back only at the child level, instead of being summed up:

Current Balance Weighted R