Measures and Multiple versions of Org Hierarchy

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!