Hello,
Platform: Cognos Express 10.2.1
I've got a TM1 cube with 3 dimensions: Time, Client, Measure. I'm doing a report in report studio based on this cube, and have some issues with measure aggregation.
In my cube, there are 2 measure types: aggregation by total'ing ("profit, USD"), and aggregation by percent calculation ("profit, %"). In TM1 architect, when I view this cube and select 2 random clients from Client dimension and click "rollup", both types of measures are rolled up correctly: "profit, USD" is summed up and "profit, %" is recalculated. However in report studio, when I select my 2 clients and right-click > calculate, all i can do is sum (client1 + client2) or rollup (client1, client2). When I sum, measure "profit, %" is summed up - this is wrong. When I choose rollup, it shows "--" in my crosstab.
Is there any way to make both types of measures to aggregate correctly in report studio?
Paid Advertisement:
