Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Report with Periodrolling does not display grand total after upgrade

Received Response
31
Views
3
Comments
VineelaG6
VineelaG6 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:55PM in Oracle Analytics Forum

We recently upgraded from OBIEE 11.1.1.7 to 12.2.1.2.0. User report worked fine in previous versions but in 12.2.1.2.0 Grand total do not get calculated . All the reports with period rolling measures have this issue. I tried to recreate it by creating a new report but still face the same issue(no matter what measure I use with periodrolling it does not give me Grand total)

pastedImage_0.png

Is this a known issue? Any patch available?

Greatly appreciate your help.

Thanks,

Vineela

Answers

  • VineelaG6
    VineelaG6 Rank 3 - Community Apprentice

    Hi

    Still facing this issue and users have found they cannot even make reports with periodrolling function to display data. Any known issue with periodrolling or is it the way periodrolling works have changed in 12c?

    Thanks,

    Vineela

  • ArijitC
    ArijitC Rank 6 - Analytics & AI Lead

    Edit the column formula. Check what Aggregation rule you have in 12c.Can you try by setting Aggregation Rule to SUM?

    pastedImage_0.png

  • VineelaG6
    VineelaG6 Rank 3 - Community Apprentice

    Hi Arijit,

    Thanks for the response, my measure is an average and I tried to change it to average. It's working in most of the scenarios(I had this issue in several reports after migration) but some times does an average of an average.

    Your suggestion was helpful;

    Thank You