Calculated Column Rollups in Framework Manager

[Nathan_F]

I have database columns as measures for Revenue and Gross Margin.  I need to calculate the Gross Margin percentage (Gross Margin/Revenue.)  Merely adding a calculated FW manager column performs the calculation before rollup, and I get grossly overstated numbers.

In Transformer, you can select After Rollup to indicate that a calculation should be performed after the items have been rolled up.  How do I accomplish this when dimensionally modeling data in Framework Manager?

[goose]

The report is just totalling the percentage. Try setting setting"Aggregate Function" and "Rollup Aggregate Function" to "Calculated" in the report

[Nathan_F]

Changing the Aggregate Function and Rollup Aggregate function in a report does not have an effect on the result.  The calculated column is still performing the calculation first, then the rollup.

Also, I am trying to set this up to function correctly in Analysis Studio.  I want to be able to use the dimensionally modeled data for analysis there.

Thanks!
Nathan

[goose]

I replicated the calc in FM but alas it doesnt seem to work to well. I could only get it right when doing the calc in the report. Will try again tomorrow and post if successfull.

[goose]

After doing some research I dont think this will work in FM well at all - do the calc in report rather - sorry man.