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
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Measures and Multiple versions of Org Hierarchy

edited May 15, 2018 1:44AM in Reporting and Analytics for HCM 1 comment

Summary

Issue with Org Fields introducing a multiplier of delivered measures

Content

Hi community!

Recently we have introduced a new organization structure into our application. Old one Inactive and New one active. Performed both row and column flattening. This has caused issues where when any Level of Organization (01,02,03, etc) is introduced as a filter/prompt or column in a report that any, specifically Annualized Salary, values are duplicated. Has anyone else had this issue before?

Filtering on Org Status = Active under the same dimension results in an endless loop for many of our queries. 

Written in OTBI. Thank you!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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