Logical Grouping of ProfitCenter/CostCenter Records
I have this scenario where in I got a set of records in the cube which consists ProfitCenter/Cost Center combinations.
ProfitCenter is a Hierarchy.
Now I need to create a set of logical groups (called Divisions) from these set of combinations.
Client had asked us to hardcode this.
Is this the only viable solution?
I can send the sample file (which represents the ProfitCenter/CostCenter combination) if someone needs more clarity.