nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

FDI Bar Visual not populating as expected

Rach23

I have a workbook which is utilising Workforce Core and an imported dataset of Workplace Health & Safety data. From this I wrote a calculation for Average Cases per Division (See below My Calculation) which when added to a table (See below) all data populates as expected.

I then created a Bar Visual using Average Cases per Division and the visual populated as expected, however recently when I have opened the Workbook it is now not populating with any data.

Update (18/06/2024) - The Bar visual is now working when Headcount measure is used. However, when I apply a filter as per attached image it ceases working.

Any ideas on how I could resolve this?

Screenshot 2024-06-12 115534.jpg

Screenshot 2024-06-12 115715.png

Find more posts tagged with

FDI

Fusion HCM Analytics

Accepted answers

All comments

Sumanth V -Oracle

@Rach23 - Please let us know if the table view shows data and is the issue only with Bar graph view. Thanks.

Rach23

@Sumanth V -Oracle The table view is showing data, and the issue is with Bar graph only. Thank you!

Sumanth V -Oracle

@Rach23 - Please try creating a new workbook with bar graph view and validate the behavior. This should help us determine if the issue is with workbook or the calculation being used. Thanks.

Rach23

@Sumanth V -Oracle Same issue with Bar graph on a new workbook as well. Table view is working fine same as old one. Thanks

Sumanth V -Oracle

@Rach23 - Please try removing the filters added on Division and Fiscal Yr and reverify once.

Rach23

@Sumanth V -Oracle yup did that but no luck with Bar graph.

Ashish-Oracle

Hi @Rach23 Did you compare/analyze the logical and physical queries generated for the table and bar view and notice any differences?

Rach23

Hi @ashish.f.singh-Oracle I did yes. It was working fine until Friday last week though.

Ashish-Oracle

@Rach23 Ok got that,
1. Did you notice any differences in the logical or physical queries, especially in the where clauses?

2. Did you have an upgrade of your FDI instance scheduled over the weekend?

Rach23

@ashish.f.singh-Oracle There was an update on Monday 10th June and Release name is 24.R2. We were not aware of changes. Also, I did not notice any difference in logical or physical queries. Thanks