Skip to Content
0
Jun 14, 2018 at 01:25 PM

Package Link do not allow to update Master data then Hierarchy

299 Views Last edit Jun 14, 2018 at 03:55 PM 4 rev

Hello,

In a BPC project, I have an issue with the Package Link.

We have create an interface between BPC and an ERP system. Thanks to this interface, we collect transactional data but also master data to the CGR (entity type), STATUT (user type), REGROUPEMENT (User type), and POSTE (account type) dimension.
We create Package Link to update all of the referential. For each dimension, the first task allow to update master data and the second must update the hierarchy.

It is on the second task that we have a problem. In fact, when we open the dimension in admin BPC, good parents are visible but in excel the new hierarchy is not updated.
--> As none process have been realized
We must process dimension in admin BPC or launch update hierarchy package again.

Several tests were conducted. At the end, if we launch in package link only the update hierarchy, the job is OK. But if before we launch an update of master data the job is KO.

By default, all the packages have parameterized scripts. We have test to use the standard package in select all information, but the result is the same...

The script of update Master Data used in package is :

INFO(%INFOOBJECT%,ZBPC_STAT)
INFO(%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" /><Selection Type="Language" TextType="3" /><Selection Type="AttributeList"><Attribute>ZBPC_STAT</Attribute><Attribute>FLAG_EXCL</Attribute></Selection><KeyDate>99991231</KeyDate><Relation><Value Right="Hierarchy" Left="Attribute">1</Value></Relation></Selections>)
INFO(%WRITEMODE%,2)
INFO(%FORMAT%,1)
INFO(%TRANSFORMATION%,\ROOT\WEBFOLDERS\Environment\Model\DATAMANAGER\TRANSFORMATIONFILES\IMPORT_STATUT_BW.xls)
INFO(%DIMNAME%,STATUT)
INFO(%CLEAR_ALL%,0)
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,%SELECTION%)
TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,INFOOBJECT,%INFOOBJECT%)
TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_FORMAT,%FORMAT%)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,OUTPUTNO,%TEMPNO2%)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_SELECTION,%SELECTION%)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,INFOOBJECT,%INFOOBJECT%)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_FORMAT,%FORMAT%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO,%TEMPNO1%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO2,%TEMPNO2%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,MASTERDATA_SELECTION,%SELECTION%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,INFOOBJECT,%INFOOBJECT%)
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,%TRANSFORMATION%)
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,%DIMNAME%)
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,%DIMNAME%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,WRITEMODE,%WRITEMODE%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO7%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,CLEAR_ALL,%CLEAR_ALL%)
TASK(/CPMB/BPC_TXT_DATA_TARGET,INPUTNO,%TEMPNO6%)
TASK(/CPMB/BPC_TXT_DATA_TARGET,DIMNAME,%DIMNAME%)

The script of update Hierarchy used in package is :

INFO(%INFOOBJECT%,ZBPC_STAT)
INFO(%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>HR9TM0PW93UI0473OV1EQFWNY</ID><MemberID /><Level /><HierName>PARENTH1</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy></Selection><KeyDate>99991231</KeyDate></Selections>)
INFO(%WRITEMODE%,2)
INFO(%FORMAT%,1)
INFO(%TRANSFORMATION%,\ROOT\WEBFOLDERS\Environment\Model\DATAMANAGER\TRANSFORMATIONFILES\IMPORT_HIERARCHIE_BW.XLS)
INFO(%DIMNAME%,STATUT)
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,%SELECTION%)
TASK(/CPMB/BW_IOBJ_HIER_SOURCE,INFOOBJECT,%INFOOBJECT%)
TASK(/CPMB/BW_IOBJ_HIER_SOURCE,MASTERDATA_FORMAT,%FORMAT%)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,FORMULA_FILE_NO,%TEMPNO2%)
TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)
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,%DIMNAME%)
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,%DIMNAME%)
TASK(/CPMB/BPC_HIER_DATA_TARGET,WRITEMODE,%WRITEMODE%)
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%)

My package link is :

All my package are visible here :

Can you help me ?

Attachments