Logical Grouping of ProfitCenter/CostCenter Records

[Former Member]

Hi,

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.

Thanks,

Manesh

[Former Member · Accepted solution]

Hi Manesh,

You can always create the logical grouping for Divisions in BW in a hierarchical format. But when the structure changes you would have to manually update the same every time.

If the hierarchy were maintained in a source system like R/3 it would always be possible to extract the latest version, reducing manual intervention. I would say a preferable way.

But you would need to check whether the standard datasource for Profit center hierarchy in R/3 supports

cost center assignment also. If not then creating the same in BW seems to be the only option I can think of.

Hope it helps.