Skip to Content

We can load the master data through two data manager package provided in BPC NW 7.5:

  1. /CPMB/IMPORT_IOBJ_MASTER is used for loading BPC members from BW master data and texts and creation of BPC members from BW hierarchy text nodes
  2. /CPMB/IMPORT_IOBJ_HIER is used for assigning the PARENTH% hierarchies in BPC member sheets

Detailed of above two can be found out in below link:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c02d0b47-3e54-2d10-0eb7-d722b633b72e?QuickLink=index&overridelayout=true&50843823515844

The first package /CPMB/IMPORT_IOBJ_MASTER will provide the feature to filter out the members based on SET SELECTION,

but /CPMB/IMPORT_IOBJ_HIER doesn’t have any filter condition.

E.g: We are loading ENTITY dimension and we have different regions &

countries like RUSSIA, USA, EUROPE, POLAND, EQUADOR etc.. The BI Staging Layer will consist of all the mentioned members and same hold good for hierarchy.

ID DESCRIPTION PARENTH1
TOT_REG All REGIONS
USA USA TOT_REG
RUSSIA RUSSIA TOT_REG
EURPOE EUROPE TOT_REG
POLAND POLAND EUROPE
EQUADOR EQUADOR EUROPE

Now if we have to load the members of only European countries(poland, equador ) then through SET SELECTION in /CPMB/IMPORT_IOBJ_MASTER we can filter out only EUROPEAN countries. But if we try to load the hiearchy it will get failed stating “Other members doesn’t present in master data”.

To overcome the above issue, we can prepare the conversion file named “NODENAME.xls” and we can give all the memebers to skip like below:

EXTERNAL INTERNAL FORMULA
RUSSIA *SKIP
USA *SKIP

I hope you find it useful in your projects.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply