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?
We are on OBIEE 184.108.40.206.0 (Build BIPS-20160923092103 64-bit)