Calculation and Sum in Framework Manager

[RRAD]

Hello,
I have five measures, out of which 3 are straight forward measures and 2 are calculated measures. When I run the Analysis Studio, the Sum values are not coming correct for the 2 calculated measures.  I have been reading the documents, I did not find any info that help fixing this issue. Any help will be greatly appreciated. The detail is as follow.

Measure1  - map to database column1
Measure2  - map to database column2
Measure3  - map to database column3

Measure4  - is calculated column:  (column1/column3)*100
Measure5 - is a calculated column: (column2/column3)*100

The Sum of  Measure4 and Measure5 are not coming correctly.  Also, who is doing the Sum the Framework manager or Analysis Studio??

Thanks,
Raj

[ford]

Try setting the default aggregation property for measure 4 and 5 to calculation in framework manager.

Ford

[RRAD]

That's how i set them up. Measure4 and measure5's  "Regular Aggregate" is set to "Calculated" in Framework manager,  not working. 

[Ben Rose]

Has anybody gotten this to work?

I am having the same problem.  I have tried all combinations of regular aggregate in FM and in Report Studio, but still am only able to get the expressions to aggregate correctly if they are created as new calculations in the actual report.

This is a drag since I use the same % and average calculations everywhere, but have to recreate them in each report.

Thanks,
Ben

[RudiHendrix]

I'm having the same issue.... :(

In FM I have a calculated measure (Price). This is calculated as invoice_amount / invoice_volume.

Now the data is as follows.
Invoice   Invoice_item    Invoice_Amount       Invoice_Volume         Invoice_Price
10000     A                   1000                     4000                        0,25
10000     B                   1000
10000     C                   50

If I pull up a report displaying this data everything is being calculated correctly. However if I pull up a report displaying only the Invoice data it displays the following:
Invoice   Invoice_Amount       Invoice_Volume         Invoice_Price
10000     2050                     4000                        0,25
Obviously the price should be 0,5125.

How and where can I set the aggregation properties to have this value be calculated correctly?