BPC Dimension member hierarchy gets wiped out afte...

Read only

661

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

Hi Team,

We are working on BPC standard 11.1 over B4HANA2.0. We have automated the Master data id/text/attributes and Hierarchy loads from B4 to BPC.

We are loading Master data id/texts/attributes for GL Account via the standard process chain :/CPMB/IMPORT_IOBJ_MASTER. And we are loading the hierarchy using standard process chain : /CPMB/IMPORT_IOBJ_HIER.

We are facing an issue where, if the Master data loads or Hierarchy Loads in BPC fail for any reason, the automated BPC dimension member hierarchy gets completely wiped out. This causes issues in reporting as there are times when loads fail and hierarchy is wiped out and report shows no data at hierarchy level.

Do we have a solution to this issue. Kindly suggest.

Regards,
SHUBHAM

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

Comment

Accepted Solutions (0)

Answers (1)

Load hierarchy in update mode.

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

Comment

Hi Vadim,

We are loading Master data id/attributes and Hierarchy in update mode.

Regards,
SHUBHAM

shubham_verma

"We are loading Master data id/attributes and Hierarchy in update mode." - Not sure! Please check again... Provide screenshots

Hi Vadim,

We have hardcoded the Data manager Script for the Update mode run. See if it works for you.

Dimension name in BPC is GL_ACCOUNT_CONS, BW InfoObject is: 0GL_ACCOUNT.

DMP Script for GL Account Master data Id load:

Clear All members: No(0)

Format: External(0)

Write mode: 2

'PROMPT(MASTERSELECTION, %INFOOBJECT%, %SELECTION%, "Please select the infoobject and the selection",,)

'PROMPT(RADIOBUTTON,%WRITEMODE%,"Write Mode",2,{"Overwrite","Update"},{"1","2"})

'PROMPT(RADIOBUTTON,%FORMAT%,"Choose format.",1,{"Internal Format","External Format"},{"1","0"})

'PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

'PROMPT(DIMENSIONNAME,%DIMNAME%,"Dimension name:",,,%DIMS%)

'PROMPT(RADIOBUTTON,%CLEAR_ALL%,"Clear all members for overwrite mode before loading?",0,{"No","Yes"},{"0","1"})

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%TEMPNO3%,%INCREASENO%)

INFO(%TEMPNO4%,%INCREASENO%)

INFO(%TEMPNO5%,%INCREASENO%)

INFO(%TEMPNO6%,%INCREASENO%)

INFO(%TEMPNO7%,%INCREASENO%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_SELECTION,<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Selection Type="Attribute" /><Selection Type="Hierarchy" ImportText="1"><Hierarchy><ID>FA8Z538LP20ZOX6ID7XDE4RKT</ID><MemberID /><Level /><HierName>LWG</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>0INCST_FLAG</Attribute><Attribute>0LOGSYS</Attribute><Attribute>0SEM_POSIT</Attribute><Attribute>0SOURSYSTEM</Attribute><Attribute>0GLACCEXT</Attribute><Attribute>0CHRT_ACCTS</Attribute></Selection><KeyDate /><Relation><Value Right="Hierarchy" Left="Attribute">2</Value></Relation></Selections>)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,INFOOBJECT,0GL_ACCOUNT)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_FORMAT,0)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,OUTPUTNO,%TEMPNO2%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_SELECTION,<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Selection Type="Attribute" /><Selection Type="Hierarchy" ImportText="1"><Hierarchy><ID>FA8Z538LP20ZOX6ID7XDE4RKT</ID><MemberID /><Level /><HierName>LWG</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>0INCST_FLAG</Attribute><Attribute>0LOGSYS</Attribute><Attribute>0SEM_POSIT</Attribute><Attribute>0SOURSYSTEM</Attribute><Attribute>0GLACCEXT</Attribute><Attribute>0CHRT_ACCTS</Attribute></Selection><KeyDate /><Relation><Value Right="Hierarchy" Left="Attribute">2</Value></Relation></Selections>)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,INFOOBJECT,0GL_ACCOUNT)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_FORMAT,0)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO,%TEMPNO1%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO2,%TEMPNO2%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,MASTERDATA_SELECTION,<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Selection Type="Attribute" /><Selection Type="Hierarchy" ImportText="1"><Hierarchy><ID>FA8Z538LP20ZOX6ID7XDE4RKT</ID><MemberID /><Level /><HierName>LWG</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>0INCST_FLAG</Attribute><Attribute>0LOGSYS</Attribute><Attribute>0SEM_POSIT</Attribute><Attribute>0SOURSYSTEM</Attribute><Attribute>0GLACCEXT</Attribute><Attribute>0CHRT_ACCTS</Attribute></Selection><KeyDate /><Relation><Value Right="Hierarchy" Left="Attribute">2</Value></Relation></Selections>)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INFOOBJECT,0GL_ACCOUNT)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,OUTPUTNO,%TEMPNO3%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,FORMULA_FILE_NO,%TEMPNO7%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\XYZ\LW_CONSOLIDATION\DATAMANAGER\TRANSFORMATIONFILES\GL_ACCOUNT_CONS_MD_LOADS.XLS)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SUSER,%USER%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPP,%APP%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,DIMNAME,GL_ACCOUNT_CONS)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,OUTPUTNO,%TEMPNO4%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,INPUTNO,%TEMPNO4%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO,%TEMPNO5%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO2,%TEMPNO6%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,INPUTNO,%TEMPNO3%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,INPUTNO,%TEMPNO5%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,DIMNAME,GL_ACCOUNT_CONS)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,WRITEMODE,2)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO7%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,CLEAR_ALL,0)

TASK(/CPMB/BPC_TXT_DATA_TARGET,INPUTNO,%TEMPNO6%)

TASK(/CPMB/BPC_TXT_DATA_TARGET,DIMNAME,GL_ACCOUNT_CONS)

*********************************************************************

Below is the hardcoded DMP script for GL Account Hierarchy:

Write Mode: Update(2)

Format: External(0)

'PROMPT(HIERARCHYSELECTION, %INFOOBJECT%, %SELECTION%, "Please select the infoobject and the selection",,)

'PROMPT(RADIOBUTTON,%WRITEMODE%,"Write Mode",2,{"Overwrite","Update"},{"1","2"})

'PROMPT(RADIOBUTTON,%FORMAT%,"Choose format.",1,{"Internal Format","External Format"},{"1","0"})

'PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

'PROMPT(DIMENSIONNAME,%DIMNAME%,"Dimension name:",,,%DIMS%,0)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%TEMPNO3%,%INCREASENO%)

INFO(%DIMNAME_DATEFROM%,)

INFO(%DIMNAME_KEYDATE%,)

TASK(/CPMB/BW_IOBJ_HIER_SOURCE,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/BW_IOBJ_HIER_SOURCE,MASTERDATA_SELECTION,<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Selection Type="Hierarchy" ImportText="0"><Hierarchy><ID>FA8Z538LP20ZOX6ID7XDE4RKT</ID><MemberID /><Level /><HierName>LWG</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy></Selection><KeyDate /></Selections>)

TASK(/CPMB/BW_IOBJ_HIER_SOURCE,INFOOBJECT,0GL_ACCOUNT)

TASK(/CPMB/BW_IOBJ_HIER_SOURCE,MASTERDATA_FORMAT,0)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,FORMULA_FILE_NO,%TEMPNO2%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\XYZ\LW_CONSOLIDATION\DATAMANAGER\TRANSFORMATIONFILES\GL_ACCOUNT_HIER_LOADS.XLS)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SUSER,%USER%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SAPP,%APP%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,DIMNAME,GL_ACCOUNT_CONS)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,OUTPUTNO,%TEMPNO3%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,INPUTNO,%TEMPNO1%)

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,KEYDATE,%DIMNAME_KEYDATE%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,INPUTNO,%TEMPNO3%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,DIMNAME,GL_ACCOUNT_CONS)

TASK(/CPMB/BPC_HIER_DATA_TARGET,WRITEMODE,2)

TASK(/CPMB/BPC_HIER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO2%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,DATEFROM,%DIMNAME_DATEFROM%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,KEYDATE,%DIMNAME_KEYDATE%)

Regards,
SHUBHAM

shubham_verma

Sorry, but text is unreadable!

Use "CODE" - "Insert Code" button to post code. Also remove useless commented lines.

Hi Vadim,

Sure. below is the attached code for Loading GL_ACCOUNT_CONS dimension master data and hierarchy from BW.

Key things hardcoded in code are:

Clear All members: No(0)

Format: External(0)

Write mode: Update(2)

The code is as below:

GL_ACCOUNT_CONS master data load. DMP script below:
****************************************************************************************
INFO(%TEMPNO1%,%INCREASENO%)


INFO(%TEMPNO2%,%INCREASENO%)


INFO(%TEMPNO3%,%INCREASENO%)


INFO(%TEMPNO4%,%INCREASENO%)


INFO(%TEMPNO5%,%INCREASENO%)


INFO(%TEMPNO6%,%INCREASENO%)


INFO(%TEMPNO7%,%INCREASENO%)


TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,OUTPUTNO,%TEMPNO1%)


TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_SELECTION,
http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance">;
Type="Attribute" /> FA8Z538LP20ZOX6ID7XDE4RKT LWG 9999-12-31 E
0GL_ACCOUNT 0BAL_FLAG 0INCST_FLAG 0LOGSYS 0SEM_POSIT 0SOURSYSTEM 0GLACCEXT
0CHRT_ACCTS 2 )


TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,INFOOBJECT,0GL_ACCOUNT)


TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_FORMAT,0)


TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,OUTPUTNO,%TEMPNO2%)


TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_SELECTION,
http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance">;
Type="Attribute" /> FA8Z538LP20ZOX6ID7XDE4RKT LWG 9999-12-31 E
0GL_ACCOUNT 0BAL_FLAG 0INCST_FLAG 0LOGSYS 0SEM_POSIT 0SOURSYSTEM 0GLACCEXT
0CHRT_ACCTS 2 )


TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,INFOOBJECT,0GL_ACCOUNT)


TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_FORMAT,0)


TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO,%TEMPNO1%)


TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO2,%TEMPNO2%)


TASK(/CPMB/MERGE_IOBJ_MD_DATA,MASTERDATA_SELECTION,
http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance">;
Type="Attribute" /> FA8Z538LP20ZOX6ID7XDE4RKT LWG 9999-12-31 E
0GL_ACCOUNT 0BAL_FLAG 0INCST_FLAG 0LOGSYS 0SEM_POSIT 0SOURSYSTEM 0GLACCEXT
0CHRT_ACCTS 2 )


TASK(/CPMB/MERGE_IOBJ_MD_DATA,INFOOBJECT,0GL_ACCOUNT)


TASK(/CPMB/MERGE_IOBJ_MD_DATA,OUTPUTNO,%TEMPNO3%)


TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,FORMULA_FILE_NO,%TEMPNO7%)


TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\XYZ\LW_CONSOLIDATION\DATAMANAGER\TRANSFORMATIONFILES\GL_ACCOUNT_CONS_MD_LOADS.XLS)


TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SUSER,%USER%)


TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPPSET,%APPSET%)


TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPP,%APP%)


TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,DIMNAME,GL_ACCOUNT_CONS)


TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,OUTPUTNO,%TEMPNO4%)


TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,INPUTNO,%TEMPNO4%)


TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO,%TEMPNO5%)


TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO2,%TEMPNO6%)


TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,INPUTNO,%TEMPNO3%)


TASK(/CPMB/BPC_MASTER_DATA_TARGET,INPUTNO,%TEMPNO5%)


TASK(/CPMB/BPC_MASTER_DATA_TARGET,DIMNAME,GL_ACCOUNT_CONS)


TASK(/CPMB/BPC_MASTER_DATA_TARGET,WRITEMODE,2)


TASK(/CPMB/BPC_MASTER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO7%)


TASK(/CPMB/BPC_MASTER_DATA_TARGET,CLEAR_ALL,0)


TASK(/CPMB/BPC_TXT_DATA_TARGET,INPUTNO,%TEMPNO6%)


TASK(/CPMB/BPC_TXT_DATA_TARGET,DIMNAME,GL_ACCOUNT_CONS)

**************************************************************************************************

GL_ACCOUNT_CONS hierarchy Load. DMP Script below:
**************************************************

INFO(%TEMPNO1%,%INCREASENO%)


INFO(%TEMPNO2%,%INCREASENO%)


INFO(%TEMPNO3%,%INCREASENO%)


INFO(%DIMNAME_DATEFROM%,)


INFO(%DIMNAME_KEYDATE%,)


TASK(/CPMB/BW_IOBJ_HIER_SOURCE,OUTPUTNO,%TEMPNO1%)


TASK(/CPMB/BW_IOBJ_HIER_SOURCE,MASTERDATA_SELECTION,
http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance">;
Type="Hierarchy" ImportText="0">
FA8Z538LP20ZOX6ID7XDE4RKT LWG 9999-12-31 )


TASK(/CPMB/BW_IOBJ_HIER_SOURCE,INFOOBJECT,0GL_ACCOUNT)


TASK(/CPMB/BW_IOBJ_HIER_SOURCE,MASTERDATA_FORMAT,0)


TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,FORMULA_FILE_NO,%TEMPNO2%)


TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\XYZ\LW_CONSOLIDATION\DATAMANAGER\TRANSFORMATIONFILES\GL_ACCOUNT_HIER_LOADS.XLS)


TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SUSER,%USER%)


TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SAPPSET,%APPSET%)


TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SAPP,%APP%)


TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,DIMNAME,GL_ACCOUNT_CONS)


TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,OUTPUTNO,%TEMPNO3%)


TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,INPUTNO,%TEMPNO1%)


TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,KEYDATE,%DIMNAME_KEYDATE%)


TASK(/CPMB/BPC_HIER_DATA_TARGET,INPUTNO,%TEMPNO3%)


TASK(/CPMB/BPC_HIER_DATA_TARGET,DIMNAME,GL_ACCOUNT_CONS)


TASK(/CPMB/BPC_HIER_DATA_TARGET,WRITEMODE,2)


TASK(/CPMB/BPC_HIER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO2%)


TASK(/CPMB/BPC_HIER_DATA_TARGET,DATEFROM,%DIMNAME_DATEFROM%)


TASK(/CPMB/BPC_HIER_DATA_TARGET,KEYDATE,%DIMNAME_KEYDATE%)

Hi Vadim,

Any changes/suggestions you would like to advice.

Regards,
SHUBHAM

Sorry, but it's still unreadable! I have no time to remove empty lines.

ok. I will try this time with empty line 🙂

Key things hardcoded in code are:

Clear All members: No(0)

Format: External(0)

Write mode: Update(2)

GL_ACCOUNT_CONS master data load. DMP script below:
****************************************************************************************
INFO(%TEMPNO1%,%INCREASENO%)
INFO(%TEMPNO2%,%INCREASENO%)
INFO(%TEMPNO3%,%INCREASENO%)
INFO(%TEMPNO4%,%INCREASENO%)
INFO(%TEMPNO5%,%INCREASENO%)
INFO(%TEMPNO6%,%INCREASENO%)
INFO(%TEMPNO7%,%INCREASENO%)
TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,OUTPUTNO,%TEMPNO1%)
TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_SELECTION,
http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance">;
Type="Attribute" /> FA8Z538LP20ZOX6ID7XDE4RKT LWG 9999-12-31 E
0GL_ACCOUNT 0BAL_FLAG 0INCST_FLAG 0LOGSYS 0SEM_POSIT 0SOURSYSTEM 0GLACCEXT
0CHRT_ACCTS 2 )
TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,INFOOBJECT,0GL_ACCOUNT)
TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_FORMAT,0)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,OUTPUTNO,%TEMPNO2%)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_SELECTION,
http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance">;
Type="Attribute" /> FA8Z538LP20ZOX6ID7XDE4RKT LWG 9999-12-31 E
0GL_ACCOUNT 0BAL_FLAG 0INCST_FLAG 0LOGSYS 0SEM_POSIT 0SOURSYSTEM 0GLACCEXT
0CHRT_ACCTS 2 )
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,INFOOBJECT,0GL_ACCOUNT)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_FORMAT,0)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO,%TEMPNO1%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO2,%TEMPNO2%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,MASTERDATA_SELECTION,
http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance">;
Type="Attribute" /> FA8Z538LP20ZOX6ID7XDE4RKT LWG 9999-12-31 E
0GL_ACCOUNT 0BAL_FLAG 0INCST_FLAG 0LOGSYS 0SEM_POSIT 0SOURSYSTEM 0GLACCEXT
0CHRT_ACCTS 2 )
TASK(/CPMB/MERGE_IOBJ_MD_DATA,INFOOBJECT,0GL_ACCOUNT)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,OUTPUTNO,%TEMPNO3%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,FORMULA_FILE_NO,%TEMPNO7%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\XYZ\LW_CONSOLIDATION\DATAMANAGER\TRANSFORMATIONFILES\GL_ACCOUNT_CONS_MD_LOADS.XLS)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SUSER,%USER%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPPSET,%APPSET%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPP,%APP%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,DIMNAME,GL_ACCOUNT_CONS)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,OUTPUTNO,%TEMPNO4%)
TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,INPUTNO,%TEMPNO4%)
TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO,%TEMPNO5%)
TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO2,%TEMPNO6%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,INPUTNO,%TEMPNO3%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,INPUTNO,%TEMPNO5%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,DIMNAME,GL_ACCOUNT_CONS)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,WRITEMODE,2)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO7%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,CLEAR_ALL,0)
TASK(/CPMB/BPC_TXT_DATA_TARGET,INPUTNO,%TEMPNO6%)
TASK(/CPMB/BPC_TXT_DATA_TARGET,DIMNAME,GL_ACCOUNT_CONS)

**************************************************************************************************

GL_ACCOUNT_CONS hierarchy Load. DMP Script below:
**************************************************

INFO(%TEMPNO1%,%INCREASENO%)
INFO(%TEMPNO2%,%INCREASENO%)
INFO(%TEMPNO3%,%INCREASENO%)
INFO(%DIMNAME_DATEFROM%,)
INFO(%DIMNAME_KEYDATE%,)
TASK(/CPMB/BW_IOBJ_HIER_SOURCE,OUTPUTNO,%TEMPNO1%)
TASK(/CPMB/BW_IOBJ_HIER_SOURCE,MASTERDATA_SELECTION,
http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance">;
Type="Hierarchy" ImportText="0">
FA8Z538LP20ZOX6ID7XDE4RKT LWG 9999-12-31 )
TASK(/CPMB/BW_IOBJ_HIER_SOURCE,INFOOBJECT,0GL_ACCOUNT)
TASK(/CPMB/BW_IOBJ_HIER_SOURCE,MASTERDATA_FORMAT,0)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,FORMULA_FILE_NO,%TEMPNO2%)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\XYZ\LW_CONSOLIDATION\DATAMANAGER\TRANSFORMATIONFILES\GL_ACCOUNT_HIER_LOADS.XLS)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SUSER,%USER%)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SAPPSET,%APPSET%)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,SAPP,%APP%)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,DIMNAME,GL_ACCOUNT_CONS)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,OUTPUTNO,%TEMPNO3%)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,INPUTNO,%TEMPNO1%)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,KEYDATE,%DIMNAME_KEYDATE%)
TASK(/CPMB/BPC_HIER_DATA_TARGET,INPUTNO,%TEMPNO3%)
TASK(/CPMB/BPC_HIER_DATA_TARGET,DIMNAME,GL_ACCOUNT_CONS)
TASK(/CPMB/BPC_HIER_DATA_TARGET,WRITEMODE,2)
TASK(/CPMB/BPC_HIER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO2%)
TASK(/CPMB/BPC_HIER_DATA_TARGET,DATEFROM,%DIMNAME_DATEFROM%)
TASK(/CPMB/BPC_HIER_DATA_TARGET,KEYDATE,%DIMNAME_KEYDATE%)

Regards,
SHUBHAM

shubham_verma

Compared your hardcoded scripts with standard. No issues except SELECTION - have you properly inserted xml code? What I can see is incorrect.

Ask a Question

Top Q&A Solution Author

User

Count

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My Account

My Account