BW Master Data Load

[Former Member]

Hi All

I am trying to load only a portion of the account master data from a BW InfoObject. The portion would only include certain accounts under one parent member. ie Operational Expenses. I understand that the DM package should do this by inputting the member ID in the hierarchies tab when in the 'Set Selection' area. This however isn't working. Does anyone know if this functionality does actually work? and what I may be doing wrong.

I am using CPM 800 SP 14.

Thanks

[former_member186338]

It works!

Please provide screenshots of the selection tabs. Looks like you are doing something incorrect...

Vadim

[Former Member]

Hi Vadim

Please see below. I have also tried adding the leading zero's and it doesn't make a difference.

I would like to add, when doing it as per below the DM package doesn't load the hierarchy nodes. The nodes do however load when leaving the member ID blank

Thanks

/CPMB/MODIFY completed in 0 seconds

/CPMB/BW_IOBJ_MASTER_SOURCE completed in 1 seconds

/CPMB/BW_IOBJ_TEXT_SOURCE completed in 4 seconds

/CPMB/MERGE_IOBJ_MD_DATA completed in 0 seconds

/CPMB/IOBJ_SOURCE_MD_CONVERT completed in 1 seconds

/CPMB/SPLIT_IOBJ_MD_TXT_DATA completed in 0 seconds

/CPMB/BPC_MASTER_DATA_TARGET completed in 6 seconds

/CPMB/BPC_TXT_DATA_TARGET completed in 1 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

INFOOBJECT = 0GL_ACCOUNT

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>0CHRT_ACCTS</ID><Operator>1</Operator><LowValue>1000</LowValue><HighValue /></Attribute></Selection><Selection Type="Hierarchy" ImportText="1"><Hierarchy><ID>NV9HRP1KVY97A552TYU3XK8UF</ID><MemberID>100089</MemberID><Level /><HierName>1000</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy></Selection><Selection Type="Language" TextType="3"><Language>E</Language></Selection><Selection Type="AttributeList"><Attribute>0GL_ACCOUNT</Attribute><Attribute>0BAL_FLAG</Attribute><Attribute>0GLACCEXT</Attribute><Attribute>0INCST_FLAG</Attribute><Attribute>0LOGSYS</Attribute><Attribute>0SEM_POSIT</Attribute><Attribute>0SOURSYSTEM</Attribute><Attribute>0CHRT_ACCTS</Attribute></Selection><KeyDate>20160610</KeyDate><Relation><Value Right="Hierarchy" Left="Attribute">2</Value></Relation></Selections>

WRITEMODE = 2

FORMAT = Yes

TRANSFORMATION = \ROOT\WEBFOLDERS\DWS_V2\DEMAND_PLAN_2\DATAMANAGER\TRANSFORMATIONFILES\BW_D_ACCOUNT_LOAD_TFORM.xls

DIMNAME = D_ACCOUNT

CLEAR_ALL = No

FILTERMD = 2

[Message]

--------------------------------------------------------------

Task name MASTER DATA SOURCE:

Record count:                                              1051

Task name TEXT SOURCE:

Record count:                                              1787

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 1051

Skip count: 0

Accept count: 1051

Task name MASTER DATA TARGET:

Submit count: 1051

Task name TXT DATA TARGET:

Submit count: 1051

model: DEMAND_PLAN_2. Package status: SUCCESS

[former_member186338]

You have selected Attributes OR Hierarchies!

[Former Member]

Hi Vadim

When I select 'Attributes AND Hierarchies' I get 'Warning' for package status and no data is loaded.

/CPMB/MODIFY completed in 0 seconds

/CPMB/BW_IOBJ_MASTER_SOURCE completed in 1 seconds

/CPMB/BW_IOBJ_TEXT_SOURCE completed in 4 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 = 0GL_ACCOUNT

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>0CHRT_ACCTS</ID><Operator>1</Operator><LowValue>1000</LowValue><HighValue /></Attribute></Selection><Selection Type="Hierarchy" ImportText="1"><Hierarchy><ID>NV9HRP1KVY97A552TYU3XK8UF</ID><MemberID>100089</MemberID><Level /><HierName>1000</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy></Selection><Selection Type="Language" TextType="3"><Language>E</Language></Selection><Selection Type="AttributeList"><Attribute>0GL_ACCOUNT</Attribute><Attribute>0BAL_FLAG</Attribute><Attribute>0GLACCEXT</Attribute><Attribute>0INCST_FLAG</Attribute><Attribute>0LOGSYS</Attribute><Attribute>0SEM_POSIT</Attribute><Attribute>0SOURSYSTEM</Attribute><Attribute>0CHRT_ACCTS</Attribute></Selection><KeyDate>20160610</KeyDate><Relation><Value Right="Hierarchy" Left="Attribute">1</Value></Relation></Selections>

WRITEMODE = 2

FORMAT = Yes

TRANSFORMATION = \ROOT\WEBFOLDERS\DWS_V2\DEMAND_PLAN_2\DATAMANAGER\TRANSFORMATIONFILES\BW_D_ACCOUNT_LOAD_TFORM.xls

DIMNAME = D_ACCOUNT

CLEAR_ALL = No

FILTERMD = 2

[Message]

--------------------------------------------------------------

Task name MASTER DATA SOURCE:

No records are returned from 0GL_ACCOUNT

Record count:                                                 0

Task name TEXT SOURCE:

Record count:                                              1787

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: DEMAND_PLAN_2. Package status: WARNING

[former_member186338]

What is the logic on your attribute selection tab?

[Former Member]

Please see below