Master Data Load Issue from BW to BPC 10.1

[former_member493004]

Hello,

Product version: BPCNW 10.1 Classic.

BW :Release 751 and SP level 0002.

In the model Consolidation, we have dimensions ENTITY,ACCOUNT,INTERCO To name few.

Script to be launched by Data Manager package.

Calculation Logic:- The master data to be pulled from BW.

Issue:- when trying to load master data for few dimensions like entity,interco, its not getting updated from BW to BPC.

Getting no Reject record and no specific error.

transformation and conversion files looks ok; I could not get whats missing here. Can anyone help/guide me on this.

below is the transformation file used:-
 *OPTIONS
  FORMAT = DELIMITED
  HEADER = YES
  DELIMITER = TAB
  AMOUNTDECIMALPOINT = .
 SKIP = 0
  SKIPIF =
  VALIDATERECORDS=YES
  CREDITPOSITIVE=YES
  MAXREJECTCOUNT=
  ROUNDAMOUNT=
  SUPPRESSCHARACTER="
 
*MAPPING
 ID=*str(CO)+ID
 CURRENCY=*str(USD)
 INTCO=*str(I)+ID
 COUNTRY=/ERP/COUNTRY
 ROW_SOURCE=*NEWCOL(S4)
  
  *CONVERSION
  ID=MasterData\COMPCODECONV.XLS

conversion file:- screenshot attached
 

Below is the Detail log after i ran package:-

/CPMB/MODIFY completed in 0 seconds
/CPMB/BW_IOBJ_MASTER_SOURCE completed in 0 seconds
/CPMB/BW_IOBJ_TEXT_SOURCE completed in 0 seconds
/CPMB/MERGE_IOBJ_MD_DATA completed in 0 seconds
/CPMB/IOBJ_SOURCE_MD_CONVERT completed in 0 seconds
/CPMB/SPLIT_IOBJ_MD_TXT_DATA completed in 0 seconds
/CPMB/BPC_MASTER_DATA_TARGET completed in 0 seconds
/CPMB/BPC_TXT_DATA_TARGET completed in 0 seconds
/CPMB/CLEAR completed in 0 seconds


[Selection]
--------------------------------------------------------------


INFOOBJECT = /ERP/COMPCODE
SELECTION = <?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Attribute"><Attribute><ID>/ERP/COMPCODE</ID><Operator>1</Operator><LowValue /><HighValue /></Attribute></Selection><Selection Type="Hierarchy" ImportText="1" /><Selection Type="Language" TextType="2" /><Selection Type="AttributeList"><Attribute>/ERP/COMPCODE</Attribute><Attribute>/ERP/CHRTACCT</Attribute><Attribute>0FISCVARNT</Attribute><Attribute>/ERP/COUNTRY</Attribute></Selection><KeyDate>20190712</KeyDate><Relation><Value Right="Hierarchy" Left="Attribute">1</Value></Relation></Selections>
WRITEMODE = 2
FORMAT = Yes
TRANSFORMATION = \ROOT\WEBFOLDERS\YYYYY\XXXXX\DATAMANAGER\TRANSFORMATIONFILES\MASTERDATA\ERP COMPCODE.XLS
DIMNAME = ENTITY
CLEAR_ALL = No

[Message]
--------------------------------------------------------------

Task name MASTER DATA SOURCE:
No records are returned from /ERP/COMPCODE
Record count:                                                 0
Task name TEXT SOURCE:
Record count:                                                 0
Task name CONVERT:
No 1 Round:
Reject count: 0
Record count: 0
Skip count: 0
Accept count: 0




Task name MASTER DATA TARGET:
Submit count: 0


Task name TXT DATA TARGET:
Submit count: 0


model: XXXXX. Package status: WARNING

[former_member186338]

Please, NEVER use "Insert File" instead of correct "Insert Image" - if you want my answers!

[former_member186338]

Clear message:

No records are returned from /ERP/COMPCODE

Provide RSA1 screenshots - what do you have in /ERP/COMPCODE

Check keydate

[former_member493004]

Hi Vadim,

there are few records in COMPCODE. screenshot below:-

I did not understand about keydate.

can you pls help.

[former_member186338]

ambika.raina

Look on master data table - DATEFROM, DATETO

Compare it with keydate selected in DM selection

[former_member493004]

Hi Vadim,

when i looked at /erp/compcode these fields are not there. I think there is some master data issue at source itself.

but I am also facing issue while loading Account master data from BW.

LOGIC: Need to load GL act master data from BW with acct type and rate type but these attributes are not in source.

I tried to give in transformation file but getting below error:-

Failed Dimension attribute ACCTYPE does not exist.

Need to know as how to give Accttype and ratetype when it is not in source.

below is the transformation file used:-

   *MAPPING
  ID=*STR(A)+ID
   ACCTYPE=*IF(ID(1:1)=*STR(1)
  then *STR(AST); ID(1:1)=*STR(2) then *STR(LEQ);ID(1:1)=*STR(3) then
  *STR(LEQ);ID(1:1)=*STR(4) then *STR(INC);ID(1:1)=*STR(5) then *STR(EXP);ID(1:1)=*STR(6) then *STR(EXP);ID(1:1)=*STR(7) then *STR(EXP))
  RATETYPE=*IF(ID(1:1)=*STR(1) then *STR(CLO); ID(1:1)=*STR(2) then *STR(CLO);ID(1:1)=*STR(3) then *STR(CLO);ID(1:1)=*STR(4) then *STR(AVG);ID(1:1)=*STR(5) then
  *STR(AVG);ID(1:1)=*STR(6) then *STR(AVG);ID(1:1)=*STR(7) then *STR(AVG))

[former_member186338]

Use conversion file!

In transformation:

ACCTYPE=ID

Then in conversion:

1* AST

2* LEQ

...

[former_member493004]

hi Vadim,

I tried this way but getting error:-

conversion file maintained as below:-

Transformation file :-

  *MAPPING
 ID=*STR(A)+ID
 ACCTYPE=ID
 RATETYPE=ID
 ROW_SOURCE=*STR(S4)
  *CONVERSION
  ID=MasterData\GL_Acct Conv.xls!ID
  RATETYPE=MasterData\GL_Acct Conv.xls!RATETYPE
  ACCTYPE=MasterData\GL_Acct Conv.xls!ACCTYPE
 

thanks,

Ambika

[former_member186338]

ambika.raina

Sorry, but what do you mean by this line in CONVERSION:

ID=MasterData]GL_Acct Conv.xls!ID

Why do you need conversion for ID??

And you are not providing this "ID" tab in the conversion file.

Error show the issue with ID!

[former_member493004]

this line: ID=MasterData\GL_Acct Conv.xls!ID :- master Data is the folder name where conversion file is saved.

Also I have three tabs in conv file: ID (where few accts to be skipped), ACCTYPE and RATETYPE

RATETYPE screenshot:-

thanks,

Ambika

[former_member186338]

ambika.raina

Then, looking on your error you have issues with BW object!

Duplicate member ID 'A' - means that you have number of lines with empty ID value!

ID=*STR(A)+ID

If BW ID is empty then ID=A

[former_member186338]

ambika.raina

P.S. For testing you can fix:

ID=*STR(A)+ID
ACCTYPE=*STR(EXP)
RATETYPE=*STR(AVG)
ROW_SOURCE=*STR(S4)

without any conversion file

And try to load!

[former_member493004]

Hi Vadim,

ok tried with changing the transformation as per below:-

Package status is success but nothing really updated in Account dimension.

not able to understand as whats wrong in here.

  *MAPPING
  ID=*STR(A)+ID
  ACCTYPE=*STR(EXP)
  RATETYPE=*STR(AVG)
   ROW_SOURCE=*STR(S4)
 CONNVERSION
 
 
  
 

[former_member186338]

ambika.raina

Sorry, but I am unable to see, what you are doing!

Where is at least the package log??

[former_member493004]

Hi Vadim,

Sorry for delayed reply.

few points when i try to load master data for Entity from /ERP/COMPCODE:-

1. in P table of this info object cannot see any data so I am not sure how can data be loaded from this real time info object to BPC. I am not sure of how to load data from these HANA enabled infoobjects.

can you pls guide/help.

[former_member186338]

ambika.raina

Sorry, but I am unable to understand what are you doing!

First you have issues with COMPCODE

Then issues with ACCOUNT

Then again with COMPCODE without data...

[former_member493004]

Hi Vadim,

Actually I have to load master data from few infoobjects and these are ERP infoobjects.

and none is working.

i want to understand how can i load master data from these ERP infoobjects.

as i mentioned earlier when i look at P table of /erp/compcode, i cannot see any data but in frontend of /erp/compcode,can see some data and when trying to load this data to BPC dimensions its not loading. the same is the case with ERP/gl_acct and erp/costcntr.

[former_member186338]

ambika.raina

Then your issue is not related to BPC data load, it's related to incorrect (?) setup of ERP infoobjects or...

P.S. May be you are looking for incorrect table... etc...

can be a lot of reasons