Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Agent Dashboard Page-Grand totals Wrong

Received Response
1
Views
4
Comments
DNK
DNK Rank 3 - Community Apprentice
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

Hello I have created an agent for Dashboard page  to send an email. Everything is fine  but the grand totals are not right in the file that got emailed through agent.Is there any way we can see the Agent SQL log that generated?

pastedImage_0.png

Also this issue is intermittent. It is getting wrong total for the first time. Re-running the agent after 10 min. The issue does not persist.

Thanks

DNK

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you checked if this is a caching issue? You also didn't mention which version of OBIEE you're using.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    As well as Joel's suggestion of by-passing the cache I would also try using 'server complex aggregate' to calculate your totals if this does not do the 'trick' for you.

  • DNK
    DNK Rank 3 - Community Apprentice

    Hello Joel,

    The OBIEE version is 11.1.1.7.160119. Caching could not be an issue because the numbers are right but not the Grand Totals.

    Thanks

    DNK

  • Joel
    Joel Rank 8 - Analytics Strategist

    It could be one of many things but most likely, it seems to be something with your model I'm guessing.

    The screenshot you supplied doesn't show the incorrect grand total. Additionally, could you supply a snapshot of the query log for this report?