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
Try setting the default aggregation property for measure 4 and 5 to calculation in framework manager.
Ford
That's how i set them up. Measure4 and measure5's "Regular Aggregate" is set to "Calculated" in Framework manager, not working.
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
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?