Oracle Business Intelligence

Products Banner

OBIEE - Grand Totals and Percentage is not Calculating Properly

Closed
54
Views
2
Comments
Steelbird
Steelbird ✭✭✭

Hi Team,

Can anyone help me on this issue ?

Orange Cell Grand Totals are incorrect.
All Measures - On Analysis -> Edit Formula -> Aggregation Rule Set to default -> If I made Measure 2 & Measure 3 to Sum Grand Totals are working but Measure 4 percentage at Grand total level data is populating incorrectly.

On Measure 2 - How can we re write the formula Using filter clause instead of Case Logic. I created below individual using filter clause and aggregation in grand total is working as expected. But I need the two conditions should be having in single column formula using Presentation variable.

Please find the attached excel for reference.

Thanks,
Steel

Answers

  • Hi @Steelbird

    Are you still looking for help on your question? as this is posted almost 10 days back. Let me know so that we can review further this thread?

    Regards,

    Arjun

  • On Measure 4 Grand Total level, you have your choices of aggregation type, such as Average, based on the values above it in the same column. There is no way to perform a calculation based on other columns in the Grand Total level.

    For your second question, I'm not completely following. Your spreadsheet shows 2 case statements - one where you evaluate variable p_smsr to equal MTD with an ELSE logic. The next case statement evaluates the same variable equals to MTH also with ELSE logic, but these combined yield 4 different formulas. You may be able to combine these 2 case statements with appropriate logic. I need more details to fully understand your objective.

This discussion has been closed.