SAP BPC 10.1: “Member XXXXX does not exist” when r... - SAP Community

Hi Expert

I need your expert advice regarding errors in loading hierarchy into SAP BPC10.1 from SAP BW7.4.

When executing hierarchy package to load 0GL_ACCOUNT / 0PROFIT_CTR / 0COSTELMNT / 0COSTCENTER it shows following error multiple times:

“Member <Hierarchy Node Name> does not exist”

OR

"Detected duplicate members ID <Hierarchy Node Name>"

My Transformation file code is following:

*OPTIONS FORMAT =

DELIMITED HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

NODENAME=NODENAME

HIER_NAME=HIER_NAME

PARENT=PARENT

ORDER=ORDER

*CONVERSION

HIER_NAME=CE_HIER_CONV.XLS

NODENAME=CE_HIER_CONV.XLS!NODENAME

My Conversion file contained:

CONVERSION Tab:

EXTERNAL INTERNAL FORMULA SCPNLK.FAC PARENTH2

NODENAME Tab:

EXTERNAL INTERNAL FORMULA * js:%external%.toString().replace(/\s+/g,"")

How can I remove these errors?

Waiting for your helpful reply.

Regards

ISKhan

SAP Managed Tags:
SAP Business Planning and Consolidation, version for SAP NetWeaver

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Sorry, but do you understand that the tag:

SAP Business Planning and Consolidation, version for the Microsoft platform

has no relation to your question? The question is about BPC NW

First you load members using /CPMB/IMPORT_IOBJ_MASTER

You have to provide full details about this process (including selection screens) to understand issues with hierarchy load. Hierarchy load is working with master data loaded!

Accepted Solutions (0)

Answers (15)

Answers (15)

vadim.kalinin If you detect any missing code of my master data and hierarchy Transformation & Conversion files. Can you please mention the correction?

MASTER DATA TRANSFORMATION FILE:-

*MAPPING
ID=0CO_AREA+ID
SCALING=*NEWCOL(Y)
CO_AREA=0CO_AREA

HIERARCHY DATA TRANSFORMATION FILE:-

*MAPPING 
NODENAME=NODENAME
HIER_NAME=HIER_NAME
PARENT=PARENT
ORDER=ORDER 

*CONVERSION 
HIER_NAME=CE_HIER_CONV.XLS
NODENAME=CE_HIER_CONV.XLS!NODENAME

HIERARCHY DATA CONVERSION FILE

CONVERSION Tab:

EXTERNAL    INTERNAL FORMULA 
SCPNLK.FAC  PARENTH2

NODENAME Tab:

EXTERNAL   INTERNAL                                      FORMULA 
*          js:%external%.toString().replace(/\s+/g,"")

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Cost Element data display in RSA1:

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Already shared screen shot of Info objects used in 0COSTELMNT. in page1.

If you need data in RSA1 then I share you also. please let me know.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

vadim.kalinin kindly response.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Again:

Please provide a screenshot of dimension members of 0COSTELMNT in RSA1

Check COSTELMNT dimension in BPC:

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Check now Attribute & Compounding tab screen shot:

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

As you said I copied my transformation files of MD and Hierarchy load and screen shots of all steps in sequence.

What you need more to troubleshoot the issue?

As per COSTELMNT dimension screen shot hierarchy column is empty.

How can I fill it with hierarchy nodes.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Please provide a screenshot of dimension members of 0COSTELMNT in RSA1

vadim.kalinin waiting for your response.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Sorry, but I do not see clear picture... Your transformation file don't match the dimension results...

Check the Cost Element dimension with loaded data screen shot:

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

How can we load Parent and base members with text in master data load?

If Conversion code needed in Transformation & Conversion files what should be ?

in RSA1 hierarchy cost element shows as:

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Please post a screenshot of the BPC dimension with members loaded! I want to see result

During master data load you load both base members and parents.

*MAPPING

ID=0CO_AREA+ID

result will be combination of 0CO_AREA and 0COSTELEMENT

During hierarchy load each loaded member will be checked against hierarchy in 0COSTELEMENT:

NODENAME=NODENAME "not 0CO_AREA+ID

PARENT=PARENT "not 0CO_AREA+ID

Look on hierarchy SCPNLK.FAC of 0COSTELEMENT in RSA1

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

How can I load both base members and parents with text during master data load?

In RSA1 hierarchy shows as:

PROFIT & LOSS (MONTHLY ANALYSIS)  00000001 0HIER_NODE SCPNLK.FAC        01    00000000 00000002 00000000
        GROSS MARGIN              00000002 0HIER_NODE SCPNLKGM.FAC      02    00000001 00000003 00000077
             REVENUE              00000003 0HIER_NODE SCPNLKR.FAC       03    00000002 00000004 00000050
                SALE              00000004 0HIER_NODE SCPNLK1007.FAC    04    00000003 00000005 00000023 
                  INTERNAL SALES  00000005 0COSTELMNT SCDAA002          05    00000004 00000000 00000006
                  ADJ OF SALES    00000006 0COSTELMNT SCDAB001          05    00000004 00000000 00000007

imran.shafiq

Sorry, but unreadable! Screenshot will be better!

Thanks for mentioning. Check now.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I think Conversion file is use only for hierarchy so please suggest the conversion file code.

Images are attached.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I will NEVER answer to the question with images inserted using "Insert File" instead of correct "Insert Image"!

Thanks for correcting my tag selection.

My Transformation file code for COST CENTER / COST ELEMENT / PROFIT CENTER Master Data loading:

*OPTIONS

FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=YES
MAXREJECTCOUNT=
ROUNDAMOUNT=

*MAPPING

ID=0CO_AREA+ID
SCALING=*NEWCOL(Y)
CO_AREA=0CO_AREA

All the Master Data loading steps with screen shots is attached for your review.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

CONVERSION section is missing...

No images inserted...

Javascript in your conversion file will replace all spaces from ID with nothing!

Sample: different ID's

AAA BB C
AAA  BB C
AAABBC
AAA BBC

Will result in the same ID

AAABBC

Can be the reason for your issue - check in BW ID's with spaces

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count

13

3

2

1

1

1

1

1

1

1