Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Agent Dashboard Page-Grand totals Wrong

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?
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
-
Have you checked if this is a caching issue? You also didn't mention which version of OBIEE you're using.
0 -
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.
0 -
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
0 -
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?
0