Measures and Multiple versions of Org Hierarchy
Summary
Issue with Org Fields introducing a multiplier of delivered measuresContent
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!