Hi,
I am building a simple analysis using Analysis Studio. I have a simple analysis that contains Customers by Year for Margin %. The totals for Customer and Years are basically summing the % values, which is incorrect. It should be aggregating the % at the summary level.
I have looked at the analysis model and everything seems in order.
What is causing this problem?
Cheers
ok there 2 things to check in your DMR model
1. Make sure your calculated margin % measure is using other measures from your dimensional namespace and not the facts from your relational query subjects
2. Set Regular Aggregate property on your percentage measure to Calculated.
wb