0 Replies Latest reply on Nov 27, 2018 11:24 PM by 3292897

    Grand Totals are yielding incorrect totals in Analysis

    3292897

      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)