Having issue seeing the right numbers in FP&A classic BI dashboards & reports in FDI

Question

Hi Team,

Working on getting the right utilization figures to FP&A classic BI dashboards & reports on classic home of FDI

Attaching the difference in figure on your left is when we want to display the right utilization numbers inside the FP&A dashboard we created and on your right is a sample report we replicated for the same utilization part, and expectantly we are seeing the right number in our replicated report on your right and the numbers are off by a margin in our main dashboard on the left. formulas for both the sections are one and the same. Why are we facing this kind of mismatch in our original dashboard when compared to the replicated report. Is this a bug or cache issue or a technical problem, please let us know if anyone faced similar kind of problem in the past...

RajeshPolavarapu-Oracle · Accepted Answer

HI @akhilsaikaza ,

You need to go through the session logs to find out the underlying physical query and its differences between the reports.

So, that you will get an idea on what to change in your reports to get the same data.

You can go through below advisory to understand on how to gather and analyze query logs -

Advisor Webcast: BI-Gathering and Analyzing Oracle Analytics Query Logs on March 16, 2023 [video] (Doc ID 2922667.1)