Percentage shouldnt aggregate for a typical characteristic
The situation is explained . Its to do with Asset Accounting reports.
The data in the cube is so:
Asset Main Asset Subno Fiscal Yr Transaction Type M1 M2 Rate of Dep
AM1 AS1 2008 *** a b 10%
In the report for 2008,
Asset Main Asset Sub no M1 Rate of DEP
AM1 AS1 a 20%
The actual report for 2008 ,
Asset Main Asset Sub no Rate of Dep
AM1 AS1 10%
Every Asset Main has a unique Depreciation Rate (%). This is calculated in the Cube via routines . Problem is when I sum across a fiscal year , the measure Depreciation rate gets summed across the transaction types. What do I do to avoid aggregation of percentage value . Please help especially if you are familiar with these kind of scenarios.