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.

Traversing Department Tree in Reports with a Parameter

edited Feb 14, 2018 7:33PM in Reporting and Analytics for HCM 7 comments

Summary

The ability to use one parameter in an otbi report for the department hierarchy as opposed to the multiple levels of departments being handled individually

Content

We would like to create an otbi dashboard that uses the department tree to view aggregate data for departments at different levels of the organization. Instead of using each individual department level field that is available in OTBI, we'd like to drill into one parameter that is intelligent enough to know by selecting a department at level 5 for instance that it should also include data in all the department levels below it. Does anyone have experience with this? The way the department hierarchy dimension is set up is not ideal for parameters as we don't want 12 parameters for

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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