Measures and Multiple versions of Org Hierarchy — Cloud Customer Connect
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

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!