Get Started with Redwood for Oracle Cloud HCM Begin Now
No fact table exists at the requested level of detail (Assignment and DoR SAs)
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)
1