Package Link do not allow to update Master data then Hierarchy

[former_member588503]

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 ?

[former_member186338]

Another idea: try to use overwrite option in hierarchy load!

[former_member588503]

In fact, I use only update option, a lot of members exist.

In the other dimension, CGR (entity type) member can move from assignment.

If I use overwrite option, can you confirm me that none data will be lost ?

[former_member186338]

I am talking about hierarchy overwrite! No data is stored in hierarchy 🙂 Hierarchy override is safe method.

But even with master data overwrite: if some member has data it will not be deleted.

[former_member588503]

We tried that as well but it did not change the outcome. The hierarchy is still updated in web admin but not in the EPM add-in even after metadata clear and refresh or restarting Excel.

For information, ENABLE_SHARED_OBJECT is not activated on our environment.

We also tried changing and activating the hierarchy via transaction RSH1. Then after running program UJA_REFRESH_DIM_CACHE, the dimension is correctly refreshed in web admin but still not in EPM add-in.

[former_member186338]

Sorry, but if you have correct hierarchy in Web admin, then your issue is not related to hierarchy load. Something is wrong with your bpc system - cache refresh etc... May be it's the right time to contact SAP support - they will connect remotely and test.

[former_member588503]

Yeah that was my guess also... Thank you for your time.

I'll try to update this post if/when our investigation pans out.

[former_member186338]

Try to reproduce this error in the fresh copy of ENVIRONMENTSHELL!

[former_member588503]

Sorry it is my first post/question in the forum.

Vadim, I have already test this method and :
- If I run package step by step, all is ok.
- If I launch package link with both packages, the problem appear. The hierarchy is not "validated/processed".

To show you all logs, here are the actions done :
1: In BPC admin, I modify my dimension STATUT : the member STATUT_NA leave the hierarchy STATUT_TOT

2: In EPMaddin, after refresh metadata, I verify this process (It is ok)

3: Run package to update Master Data

4: Run package to update hiérarchy

5: In EPMaddin, after refresh metadata, I verify this process. STATUT_NA is in STATUT_TOT (It is ok)

To test both packages in package link, the step 1and 2 are done again.
1: Run package link with both package

2: In EPMaddin, after refresh metadata, I verify this process. STATUT_NA is in STATUT_TOT (It is ok)

I confirm you that in SAP BPC admin, the parent of STATUT_NA is STATUT_TOT.

To complete information :

Version of BPC : 10.1

Version SAP NetWeaver : 7.50

Version BW : BW 750 SP 8

[former_member186338]

I can see that you hardcoded all selections in advanced DM scripts. In general it's OK, but for troubleshooting it's better to start with standard packages.

Create 2 standard packages to load master data and to load hierarchy.

Run both answering prompts.

Create a package link for 2 packages. Set and save prompts.

Run package link with saved prompts.

In general it's absolutely standard think to load master data and hierarchy in the same package link. I have done it many times.

[former_member588503]

Indeed this package is normally easy to set up.
I did not understand where is the problem and my colleague too.

So I have done test with 2 standards packages in package Link.
After prompt selection, the result is ok.

--> However after refresh metadata, the dimension is not correct.
Members are not attached to the parent.

[former_member186338]

On the Selection screen please check Key Date. Sometimes it can be wrong.

Please provide logs of standard packages in the package link.

Also provide separate standard package log for hierarchy load - is it working correctly if launched separately.

I need the info to help you...

[former_member588503]

Vadim,

When I launch default package keynote is the date of the day.
In custom script by default I have used 99991231 but we are not time dependent.

Log of import Master Data :

/CPMB/MODIFY effectué en 0 secondes
/CPMB/BW_IOBJ_MASTER_SOURCE effectué en 0 secondes
/CPMB/BW_IOBJ_TEXT_SOURCE effectué en 0 secondes
/CPMB/MERGE_IOBJ_MD_DATA effectué en 0 secondes
/CPMB/IOBJ_SOURCE_MD_CONVERT effectué en 0 secondes
/CPMB/SPLIT_IOBJ_MD_TXT_DATA effectué en 0 secondes
/CPMB/BPC_MASTER_DATA_TARGET effectué en 2 secondes
/CPMB/BPC_TXT_DATA_TARGET effectué en 1 secondes
/CPMB/CLEAR effectué en 0 secondes

[Selection]
--------------------------------------------------------------
INFOOBJECT = ZBPC_STAT
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>HR9TM0PW93UI0473OV1EQFWNY</ID><MemberID /><Level /><HierName>PARENTH1</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy></Selection><Selection Type="Language" TextType="3" /><Selection Type="AttributeList"><Attribute>ZBPC_STAT</Attribute><Attribute>FLAG_EXCL</Attribute></Selection><KeyDate>20180615</KeyDate><Relation><Value Right="Hierarchy" Left="Attribute">1</Value></Relation></Selections>
WRITEMODE = 2
FORMAT = Yes
TRANSFORMATION = \ROOT\WEBFOLDERS\ATALIAN_PROPRETE\CDG_PLANNING\DATAMANAGER\TRANSFORMATIONFILES\IMPORT_STATUT_BW.xls
DIMNAME = STATUT
CLEAR_ALL = No

[Message]
--------------------------------------------------------------
Nom de tâche MASTER DATA SOURCE:
Compte d'enregistrement:                                                17

Nom de tâche TEXT SOURCE:
Compte d'enregistrement:                                                16

Nom de tâche CONVERT:

Aucun rond 1:
Rejeter le compte: 0
Compte d'enregistrement: 17
Ignorer compte: 0
Accepter compte: 17


Nom de tâche MASTER DATA TARGET:
Soumettre compte: 17

Nom de tâche TXT DATA TARGET:
Soumettre compte: 17
modèle : CDG_PLANNING. Statut de package : SUCCESS

Log of import Hierarchy :

/CPMB/MODIFY effectué en 0 secondes
/CPMB/BW_IOBJ_HIER_SOURCE effectué en 0 secondes
/CPMB/IOBJ_SOURCE_HD_CONVERT effectué en 0 secondes
/CPMB/BPC_HIER_DATA_TARGET effectué en 3 secondes
/CPMB/CLEAR effectué en 0 secondes

[Selection]
--------------------------------------------------------------
INFOOBJECT = ZBPC_STAT
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>20180615</KeyDate></Selections>
WRITEMODE = 2
FORMAT = Yes
TRANSFORMATION = \ROOT\WEBFOLDERS\ATALIAN_PROPRETE\CDG_PLANNING\DATAMANAGER\TRANSFORMATIONFILES\IMPORT_HIERARCHIE_BW.xls
DIMNAME = STATUT
DIMNAME_KEYDATE = 
DIMNAME_DATEFROM = 

[Message]
--------------------------------------------------------------
Nom de tâche HIERARCHY DATA SOURCE:
Compte d'enregistrement:                                                17

Nom de tâche CONVERT:

Aucun rond 1:
Le fichier de conversion ne contient pas de règle de conversion qualifiée
Rejeter le compte: 0
Compte d'enregistrement: 17
Ignorer compte: 0
Accepter compte: 17

Nom de tâche HIERARCHY DATA TARGET:
Soumettre compte: 17

modèle : CDG_PLANNING. Statut de package : SUCCESS

I confirm you that if I launch package seperately, all is ok.
The log of Import Hierarchy launched alone, is the same.

Thank you.

[former_member186338]

Please correct unreadable question - instead of incorrect "Insert File" use correct "Insert Image"

[former_member186338]

P.S. And start with simple test for one dimension:

1. Run package for master data load

2. Run package for hierarchy data load

3. Run package link with both packages.

Show all logs