Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Using Grand Total function on OBIEE 11g
Hello,
we are facing issues using "Grand Total" in combination with fields calculated by evaluate formula in a pivot table.
Normally, "Grand Total" displays the total related to the same rule applied to the different fields(for instance division from different measures or simple fields), but using evaluate to calculate the value of a field it seems to not work properly, as it uses the same rule aggregation expressed by the single fields in the pivot table(in our example SUM ) that we are forced to define to let the Grand Total be displayed otherwise we get an error.
In the example below, the field DIVISION is equal to NUMERATOR/DENOMINATOR, where DENOMINATOR is calculated using an evaluate formula(call an oracle db function):
What we expected as Grand Total result would be 1873/36=52 and not 140 as displayed that is the sum of the row entries.
How we can solve our issue and let Grand Total works properly?
Best Regards.
Answers
-
Hello,
I dont think that the problem is in your evaluate function, however, the methods to get your result depends on your RPD model.
1. Try to do this:
Check this sample, this criteria section:
Set up the aggregation rule - "Sever Complex Aggregate", and check the results
26,477,185.00 / 16,720,560.00 = 158.35%
2. If it doesnt work, please, give more clues, an screemshot about your criteria section, and your BMM logical star schema.
Kind Regards,
0