Custom list hierarchy

[sap_user62]

Hi Friends,

BPC10.1/BW7.4

BPC has 2 dimensions CostCenter and AllocationCC. AllocationCC has fewer members than CostCenter. (contains cost centers needed for allocations only)

Cost center in BW has a flag (attribute) to indicate if its a AllocationCC. This flag is used to populate the AllocationCC dimension in BPC. The attribute load works well.

CostCenter hierarchy in BPC get loaded from BW. BW does not a separate hierarchy for only Allocation costcenters.

I have a requirement to generate a list hierarchy for AllocationCC in BPC. The hierarchy would have a parent "Allocation" and all the AllocationCC would roll under it.

Is there a way to achieve it in BPC quickly or we need to write custom code to generate a hierarchy in BW.

Thanks for your time

Ed.

[former_member186338 · Accepted solution]

Why not to search? I have answered this question number of times.

In short:

After importing members from BW export members to text file then import this text file with transformation file with fixed parent assignment. Absolutely simple job!