FA OTBI - Workforce Performance - Performance Rating Real - Time - Department Hierarchy Field As Parameter
Last updated on APRIL 17, 2018
Applies to:Oracle Fusion Performance Management Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Customer requirement is to use the department hierarchy dimension as a parameter in an otbi report. When they add it as a table prompt, all they get is the name of the department tree and no ability to drill down into the different levels of the tree. When they add it as a prompt that appears before the report is rendered, it seems to have no output on the report. The only place this value seems to be valuable is within an otbi report as a field in the report but even then they are seeing poor performance.
To be clear, this is the department field in the Department Hierarchy dimension. It should serve as a hierarchical field that can drill into and we'd like to use this as a parameter versus needing individual parameters for each level of the tree.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms