% measure is not aggregating properly

[dinos]

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

[Warborn]

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