Categories
- All Categories
- Oracle Analytics Learning Hub
- 18 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 228 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 85 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Grand Totals are yielding incorrect totals in Analysis
3292897
Rank 1 - Community Starter
We built an analysis with multiple dimensional attributes and few measures.Then added a new calculated measures as A+B. We get the incorrect grand totals using the Default Aggregation?
Also, the default Aggregation in RPD is set to SUM.
However, when we set the aggregation to SUM for this new calculated field, it does return the correct Grand Totals.
Also, tried <ReportAggregateEnabled>true</ReportAggregateEnable> tag in instanceconfig but resulted incorrect Grand Totals?
Any pointers?
We are on OBIEE 12.2.1.2.0 (Build BIPS-20160923092103 64-bit)
0