Report with Periodrolling does not display grand total after upgrade

Question

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)

Is this a known issue? Any patch available?

Greatly appreciate your help.

Thanks,

Vineela

VineelaG6 · Answer

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

ArijitC · Answer

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

VineelaG6 · Answer

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