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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

No fact table exists at the requested level of detail (Assignment and DoR SAs)

edited Sep 11, 2021 9:57PM in Reporting and Analytics for HCM 19 comments

Summary

[nQSError: 14025] No fact table exists at the requested level of detail (Assignment and DoR SAs)

Content


Hello,

Just wondering if anyone faced this type of issue earlier:

1) Built a simple Performance Tile using  two  subject-areas (Workforce Management - Documents of Record Real Time AND Workforce Management - Worker Assignment Real Time)
2) Perf Tile displays the intended results fine but if I add a filter {"Workforce Management - Worker Assignment Real Time"."Organization Hierarchy"."Tree Version Status"}, it errors-out with the below standard error message.

State: HY000. Code: 14025. [nQSError: 14025] No fact table exists at the requested level of detail:

3) Checked 'DIMENSIONALITY' in 'Advanced' tab and included 'SET VARIABLE ENABLE_DIMENSIONALITY=1,NO_FORCE_TO_DETAIL_BIN=1;' in pre-fix as well (Refreshed Server Metadata too)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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