My Oracle Support Banner

FA OTBI - Workforce Performance - Performance Rating Real - Time - Department Hierarchy Field As Parameter (Doc ID 2387577.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle Fusion Performance Management Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

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. 
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.