Data manager link prompts

[Former Member]

Hi Guys

How-to question from me.

I have a package link for allocations that runs all possible allocations in the company. That runs to about 115 cycle segments, or in BPC speak, 115 definitions of the data manager package prompts. All of these are sequentially stored in a package link (see attached "capture.jpg")

Now with a change in the time period for planning each of these requires me to:

- definitely change the time definition for the year in which planning is being carried out (and hence the TIME dimension member for which I want the packages in the link to be run)

- change members for some of the other dimensions being prompted in certain packages e.g. receiver and sender cost centres.

I know there are blogs on how I can automate the load to packages and on how to redefine the user interface experience. But how can I download a file that stores all the prompts that are currently stored in all packages in the link? Just so I can review the currently stored prompts and then finalise those that I do intend to update.

regards

Shrikant

PS: BPC 10.0 NW is being used.

[former_member186338 · Accepted solution]

Please look on the table UJD_LINK:

Vadim

P.S. Also -here:

[Former Member · Accepted solution]

Thanks Vadim

UJD_LINK has some DMS Ids. I can see blogs that talk of using ABAP to run packages while filtering on DMS Ids. However, my question is how do we get a listing of all the prompts in the link. The DMS doesn't give that..

any ideas?

shrikant

[former_member186338 · Accepted solution]

Have you looked on the xml in the CONTENT field?

[former_member186338 · Accepted solution]

Sample of the CONTENT field with saved prompt:

<?xml version="1.0"?>##

<LINK_PROCESS xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" LINK_TYPE="LINK">## 

<PROPERTY NAME="NAME">TESTLINK</PROPERTY>## 

<PROPERTY NAME="DESCRIPTION">Test Link</PROPERTY>## 

<LINK_PROCESS LINK_TYPE="BPC_PACKAGE">##   

<PROPERTY NAME="NAME">RUNTESTDM</PROPERTY>##   

<PROPERTY NAME="DESCRIPTION">Run Test DM</PROPERTY>##   

<PROPERTY NAME="ID">C79C93EAA90F49BCAB973581C710A958</PROPERTY>##   

<TASKDATA>##     

<PACKAGE>TESTDM</PACKAGE>##     

<TEAM />##     

<GROUP>Data Management</GROUP>##     

<APPSET>SIM</APPSET>##     

<APPLICATION>INPER</APPLICATION>##     

<ANSWERPROMPT>%SELECTION%#/SIM/INPER/PRIVATEPUBLICATIONS/V.KALININ/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:PERIODS|2011.FEB##%SELECTION_KEYDATE%###</ANSWERPROMPT>##   

</TASKDATA>## 

</LINK_PROCESS>##

</LINK_PROCESS>

Vadim

[Former Member]

Thanks.. that option of coming up with an ABAP program to read the DMS link worked.

Obviously not user friendly, but where would we be if everything in SAP was user friendly.

[Former Member]

Hi Shrikant,

You can got to UJFS, select your Environment and find Model -> datamanger -> selectionfiles.

You'll see there files with extension esf. Download them and you'll see those stored prompts.

Not sure what you want to do with the tho.

[former_member186338]

Hi Gersh,

Shrikant is talking about Package Link saved prompts. And as far as I know this info is stored only in the xml of the CONTENT field of UJD_LINK, not in UJFS selectionfiles.

Vadim