on 01-15-2015 9:02 AM
Hi,
I am trying to create a data point at the universe level that computes the achievement percentage of sales vs target. At the most granular level, the value is correct, but rolling up, it simply sums up the percentage instead of calculating the value. I am able to get the correct percentage if I define at the report level, but I am wondering if I can do this at the universe level so that it can be a re-usable data point for users.
Sample data:
Achievement = Sales/Target
Year Quarter Target Sales Achievement
2010 Q1 100 50 0.5
2010 Q2 200 175 0.875
If Achievement is defined at Universe-level, I get the below values:
Year Target Sales Achievement
2010 300 225 1.375
When the correct value should be as below:
Year Target Sales Achievement
2010 300 225 0.75
Hi Ednalynn,
You must have defined 'Achievement' object as a measure in the universe.
The measure is this scenario is non-additive; however, it seems like the default projection of this measure is set to Sum and therefore, the values are getting aggregating automatically when the grain is increasing.
Can you try using the projection as 'None' and check if it helps?
Regards,
Yuvraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ednalynn,
In that case, the best option seems to be to do this at Webi level.
Can you try this and check if it works at universe:
Achievement = Sum(sales) / Sum(Target).
Keep the projection as None as it is a ratio and is non-additive.
As far as I am aware, rolling up can only be done automatically in case of additive measures like Sales, Revenues, Costs, Prices and not in case of non-additive measures like this.
Regards,
Yuvraj
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.