Unassigned Nodes in Master Data Hierarchy Load from BW InfoObject

[Former Member]

Hi,

I am busy performing a load of Master Data in BPC 10.1 NW (Classic Model)

There are a number of nodes that are not assigned to a Parent in ECC (It's Cost Center in this case).

Is there a way that I can force them into an "unassigned parent node" in BPC (CC_UNASSIGNED, manually entered) via the Transformation File?

My current Transformation File looks like this: (it's pretty standard)

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 1

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

SUPPRESSCHARACTER=

*MAPPING

NODENAME=NODENAME

HIER_NAME=HIER_NAME

PARENT=PARENT

ORDER=ORDER

*CONVERSION

HIER_NAME=BW_COST_CENTER_HIER_CONV.XLS!CONVERSION

NODENAME=BW_COST_CENTER_HIER_CONV.XLS!NODENAME

PARENT=BW_COST_CENTER_HIER_CONV.XLS!NODENAME

I am trying to work out what condition in the *MAPPING that might be triggered by an unassigned node. For example, PARENT being an empty string, or something like that. Any ideas?

Many thanks

Kind Regards

Nick

[former_member186338 · Accepted solution]

Have you tested something like:

PARENT=IF(PARENT=STR() THEN STR(CC_UNASSIGNED);PARENT)

P.S. It's also depends on what conversion you have for parent... please show!

[Former Member · Accepted solution]

Hi Vadim,

Appreciate the response. Thanks.

I did give your approach a try before on PARENT (sorry, should have mentioned that I had), but no luck. I will try again tomorrow just to be sure.

From what I've seen in RSA1, it almost seems that if a Member is not part of a hierarchy, then it almost appears to be non-existent (certainly in the hierarchy structure, obviously not for Attribute / Text). I need to research this a bit more.

I will also post the Conversion File contents for you.

Kind Regards

Nick

[Former Member · Accepted solution]

Hi Nick.

It depends on your selection during master data upload, if you select a hierarchy in the hierarchy selection tab then any other members not part of the hierarchy will not be loaded, so in your case non-existent.

so it all depends what do you want to archive, do you want to load all member from that info object? then just leave hierarchy empty during the selection.

If you want all members outside a hierarchy into a custom one in BPC then you have to use routine BADI. or you update the hierarchy in BW.

Andy

[Former Member · Accepted solution]

Thanks, Andy

Makes perfect sense.

I have used hierarchy filters for my attribute / text load (all the hierarchies in one step), but yet all the unassigned nodes are returned, so maybe I need to split that out in separate steps in the Package Link, so that should solve that issue. (I faced a similar issue with the hierarchy loads)

I guess the other approach, then, is a routine BADI, as you mentioned.

Much appreciated.

Nick

[former_member186338 · Accepted solution]

Also you have to exclude in IF the root parent of your accounts...