Skip to Content
1
Jul 17, 2019 at 08:04 AM

Master Data Load Issue from BW to BPC 10.1

822 Views

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


Attachments

cc.png (4.7 kB)