7.5NW: Filter while loading Master Data Hierarchy
We can load the master data through two data manager package provided in BPC NW 7.5:
- /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
- /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:
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.
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:
I hope you find it useful in your projects.