OrgChart V2.0 Plugin shows no data — Oracle Analytics

Oracle Analytics Cloud and Server

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

OrgChart V2.0 Plugin shows no data

Accepted answer
105
Views
9
Comments

We have around 35K population in our instance yet analysis created from OrgChart V2.0 plugin shows no data.

The backend SQL for both analysis in the screenshot is same. (Head count sum is shown in first is the only difference in SQL) We are using delivered HCM- Workforce core subject area and columns used are

  "HCM - Workforce Core"."Basic Information"."Person Number"  and

"HCM - Workforce Core"."Manager Information"."Manager Person Number" 

Criteria in SQL

(("HCM - Workforce Core"."Facts - Workforce Headcount"."Employee Headcount">=1) AND ("HCM - Workforce Core"."Time"."Enterprise Date"=CURRENT_DATE-1))

We raised and SR but plugins are not covered as part of support so raising the question here for help on same.

Request help.

Regards,

Pranjal Saigal.

NoDataOrgChartV2.png
Tagged:

Best Answers

Answers