You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

When applying case statement with group by and aggregate function it is showing error.

edited May 24, 2021 10:26AM in Reporting and Analytics for HCM 4 comments

Summary

When applying case statement with group by and aggregate function it is showing error(No fact table exists).I am using 2 subject areas and included fact columns from both the subject areas.

Code Snippet

(CASE WHEN COUNT ("Workforce Management - Person Real Time"."Person Citizenship"."Nationality" BY "Workforce Management - Person Real Time"."Worker"."Person Number") >1  THEN 'Multiple Values' ELSE "Workforce Management - Person Real Time"."Person Citizenship"."Nationality"  END)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!