Hi all
I am generating a cube with two measures (say m1 and m2) and publishing it on upfront. now i create a view and use the accumulate calculation to create two more categories ( say Acc_m1 and Acc_m2). I now want to take the difference and the % of these two accumulated categories. When i select and these two categores and click the calaculate buttion on the upfront and try a subtract calculation and do 'OK' it gives me Invalid expression. Is there a limitation that calculation cannot be performed on two calculated categories. I am able to do it in powerplay client.
I am using version 7.1 MR2.
Any kind of suggestion will be gretly appreciated.
Also if not is there a way to build a accumulated measure in transformer or a column in the source iqd (with same way so that it doesnt rollup in the transformer)
TIA
Yash
I am generating a cube with two measures (say m1 and m2) and publishing it on upfront. now i create a view and use the accumulate calculation to create two more categories ( say Acc_m1 and Acc_m2). I now want to take the difference and the % of these two accumulated categories. When i select and these two categores and click the calaculate buttion on the upfront and try a subtract calculation and do 'OK' it gives me Invalid expression. Is there a limitation that calculation cannot be performed on two calculated categories. I am able to do it in powerplay client.
I am using version 7.1 MR2.
Any kind of suggestion will be gretly appreciated.
Also if not is there a way to build a accumulated measure in transformer or a column in the source iqd (with same way so that it doesnt rollup in the transformer)
TIA
Yash