Answer Prompt file for UJD_TEST_PACKAGE_LINK

[Former Member]

Hi All,

I am trying to trigger a BPC Data Manager Package link through program

UJD_TEST_PACKAGE_LINK. Package link has two tasks namely 'AMT GC1', AMT GC2'.

Prompts are not set for both the tasks.

package-link.jpg

Then I ran the Program UJD_TEST_PACKAGE_LINK by setting all the necessary parameters and passed the below "Answer Prompt File".

answer-prompt.jpg

Execution of the program results with following error "You do not have authorization".

I feel I am missing something in Answer Prompt file (Probably syntax error).

Could you help in resolving the issue.

Thanks & Regards,

Ramesh.

[kpitchiah]

Ramesh,

I have the problem in creating answer prompt file for BW info provider extract. I have created file as you mentioned but the selection part is getting truncated could you please advice

[former_member186338]

Open a new question and explain full details. I will not answer here.

[Former Member]

Hi All,

Finally I am able to trigger the BPC Package link using below Answer Prompt.

<?xml version="1.0"?>
<LINK_PROCESS>
<ANSWERPROMPT PROCESSID="AMT GC3">%InforProvide% XXXXX
%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="Selection"><Attribute><ID>ZB_DATE</ID><Operator>1</Operator><LowValue>31.03.2017</LowValue><HighValue

/></Attribute></Selection><Selection

Type="FieldList"><FieldID>0CHNGID</FieldID><FieldID>0CS_CHART</FieldID><FieldID>0CS_DIMEN</FieldID><FieldID>0CS_

ITEM</FieldID><FieldID>0CS_PARTNER</FieldID><FieldID>0CS_SITEM</FieldID><FieldID>0CS_SITEMCT</FieldID><FieldID&g

t;0CS_UNIT</FieldID><FieldID>0CS_VERSION</FieldID><FieldID>0CURKEY_GC</FieldID><FieldID>0CURKEY_LC</FieldID><Fie

ldID>0CURKEY_TC</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>ZB_CURGC2</FieldID><F

ieldID>ZB_CURGC3</FieldID><FieldID>ZB_CURGC4</FieldID><FieldID>ZB_CURLC</FieldID><FieldID>ZB_CURTC</FieldID><

FieldID>ZB_DATE</FieldID><FieldID>ZB_GC1KEY</FieldID><FieldID>ZB_GC2KEY</FieldID><FieldID>ZB_GC3KEY</FieldID><

;FieldID>ZB_GC4KEY</FieldID><FieldID>ZB_GUID</FieldID><FieldID>ZB_REPPER</FieldID><FieldID>ZB_WID</FieldID><F

ieldID>ZC_FUNCID</FieldID><FieldID>ZC_GAADID</FieldID><FieldID>ZC_RGPDTY</FieldID></Selection></Selections>
%TRANSFORMATION% \ROOT\WEBFOLDERS\XXXXX\XXXXX\DATAMANAGER\TRANSFORMATIONFILES\TRANSACTION DATA\IC_ELIMINATION\AMOUNT_GCKEY3.XLS
%TARGETMODE% 1
%RUNLOGIC% 0
%CHECKLCK% 0
</ANSWERPROMPT>

<ANSWERPROMPT PROCESSID="AMT GC4">%InforProvide% XXXXX
%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="Selection"><Attribute><ID>ZB_DATE</ID><Operator>1</Operator><LowValue>30.03.2017</LowValue><HighValue

/></Attribute></Selection><Selection

Type="FieldList"><FieldID>0CHNGID</FieldID><FieldID>0CS_CHART</FieldID><FieldID>0CS_DIMEN</FieldID><FieldID>0CS_

ITEM</FieldID><FieldID>0CS_PARTNER</FieldID><FieldID>0CS_SITEM</FieldID><FieldID>0CS_SITEMCT</FieldID><FieldID&g

t;0CS_UNIT</FieldID><FieldID>0CS_VERSION</FieldID><FieldID>0CURKEY_GC</FieldID><FieldID>0CURKEY_LC</FieldID><Fie

ldID>0CURKEY_TC</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>ZB_CURGC2</FieldID><F

ieldID>ZB_CURGC3</FieldID><FieldID>ZB_CURGC4</FieldID><FieldID>ZB_CURLC</FieldID><FieldID>ZB_CURTC</FieldID><

FieldID>ZB_DATE</FieldID><FieldID>ZB_GC1KEY</FieldID><FieldID>ZB_GC2KEY</FieldID><FieldID>ZB_GC3KEY</FieldID><

;FieldID>ZB_GC4KEY</FieldID><FieldID>ZB_GUID</FieldID><FieldID>ZB_REPPER</FieldID><FieldID>ZB_WID</FieldID><F

ieldID>ZC_FUNCID</FieldID><FieldID>ZC_GAADID</FieldID><FieldID>ZC_RGPDTY</FieldID></Selection></Selections>
%TRANSFORMATION% \ROOT\WEBFOLDERS\XXXXX\XXXXX\DATAMANAGER\TRANSFORMATIONFILES\TRANSACTION DATA\IC_ELIMINATION\AMOUNT_GCKEY4.XLS
%TARGETMODE% 1
%RUNLOGIC% 0
%CHECKLCK% 0
</ANSWERPROMPT>
</LINK_PROCESS>

Thanks & Regards,

Ramesh.

[former_member186338]

Do you really think it's a good idea to select your own answer as correct?

[Former Member]

Since I have posted this query, I have marked this as Correct answer. I have reverted it back now. Based on further responses I'll decide accordingly.

Thanks

[former_member186338]

In my answers I have explained you what exactly to do. Have you add something I missed?

[former_member186338]

Now I see what was incorrect in your answer prompt! Has to be:

<LINK_PROCESSES>
<LINK_PROCESS_PROCESSID='AMT GC3'>
%InforProvide%    XXXXX
%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="Selection"><Attribute><ID>ZB_DATE</ID><Operator>1</Operator><LowValue>20170331</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0CHNGID</FieldID><FieldID>0CS_CHART</FieldID><FieldID>0CS_DIMEN</FieldID><FieldID>0CS_ITEM</FieldID><FieldID>0CS_PARTNER</FieldID><FieldID>0CS_SITEM</FieldID><FieldID>0CS_SITEMCT</FieldID><FieldID>0CS_UNIT</FieldID><FieldID>0CS_VERSION</FieldID><FieldID>0CURKEY_GC</FieldID><FieldID>0CURKEY_LC</FieldID><FieldID>0CURKEY_TC</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>ZB_CURGC2</FieldID><FieldID>ZB_CURGC3</FieldID><FieldID>ZB_CURGC4</FieldID><FieldID>ZB_CURLC</FieldID><FieldID>ZB_CURTC</FieldID><FieldID>ZB_DATE</FieldID><FieldID>ZB_GC1KEY</FieldID><FieldID>ZB_GC2KEY</FieldID><FieldID>ZB_GC3KEY</FieldID><FieldID>ZB_GC4KEY</FieldID><FieldID>ZB_GUID</FieldID><FieldID>ZB_REPPER</FieldID><FieldID>ZB_WID</FieldID><FieldID>ZC_FUNCID</FieldID><FieldID>ZC_GAADID</FieldID><FieldID>ZC_RGPDTY</FieldID></Selection></Selections>
%TRANSFORMATION%    \ROOT\WEBFOLDERS\XXXXX\XXXXX\DATAMANAGER\TRANSFORMATIONFILES\TRANSACTION DATA\IC_ELIMINATION\AMOUNT_GCKEY3.XLS
%TARGETMODE%    Yes

...

%variable%(Tab)value

Just look again on the sample here:

https://blogs.sap.com/2016/08/16/how-to-create-ujdtestpackagelink-answer-prompt/

[Former Member]

I have modified the file and ran the program using the new file. Issue still persist.

[former_member186338]

Please post your new answer prompt file. May be you have other mistakes...

[former_member186338]

By the way - variables like %TARGETMODE% etc... has to be assigned numeric value:

%TARGETMODE% 1

instead of Yes.

Look on my answer here:

https://answers.sap.com/questions/273905/bw-process-chain-step-to-import-transactional-data.html

[Former Member]

Thank You Vadim for your continuous support.

[former_member186338]

And how do you fill other fields in UJD_TEST_PACKAGE_LINK?

What User ID was selected?

[Former Member]

I ran the program using my ID and it has SAP_ALL Authorization.

[former_member186338]

A am not asking how you run the program!

What do you have in User ID field? Screenshot, please...

[Former Member]

PFA the Screenshot,

se38.jpg

[former_member186338]

43500543 - is it a valid user id? With correct BPC security settings?

[Former Member]

Yes. It is a Valid User ID. Nothing has been restricted for this ID in BPC.

I was able to run UJD_TEST_PACKAGE successfully using this ID. But running

UJD_TEST_PACKAGE_LINK only fails.

[former_member186338]

OK, try to set answers in the package link (for both tasks) and run UJD_TEST_PACKAGE_LINK with empty answer prompt!

[Former Member]

I have set prompts directly in Package link and ran the program with empty answer prompts. It is working as expected. But I want to pass the answer prompt file while running the program.

[former_member186338]

Sorry, but without understanding how do you created the answer prompt it's not possible to help you...

Please read:

https://blogs.sap.com/2016/08/16/how-to-create-ujdtestpackagelink-answer-prompt/

[Former Member]

Hi Vadim,

I have created the Answer Prompt file based on the suggested blog only.

Attaching the file content below,

<LINK_PROCESSES>
<LINK_PROCESS_PROCESSID='AMT GC3'>
InforProvide = XXXXX
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="Selection"><Attribute><ID>ZB_DATE</ID><Operator>1</Operator><LowValue>20170331</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0CHNGID</FieldID><FieldID>0CS_CHART</FieldID><FieldID>0CS_DIMEN</FieldID><FieldID>0CS_ITEM</FieldID><FieldID>0CS_PARTNER</FieldID><FieldID>0CS_SITEM</FieldID><FieldID>0CS_SITEMCT</FieldID><FieldID>0CS_UNIT</FieldID><FieldID>0CS_VERSION</FieldID><FieldID>0CURKEY_GC</FieldID><FieldID>0CURKEY_LC</FieldID><FieldID>0CURKEY_TC</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>ZB_CURGC2</FieldID><FieldID>ZB_CURGC3</FieldID><FieldID>ZB_CURGC4</FieldID><FieldID>ZB_CURLC</FieldID><FieldID>ZB_CURTC</FieldID><FieldID>ZB_DATE</FieldID><FieldID>ZB_GC1KEY</FieldID><FieldID>ZB_GC2KEY</FieldID><FieldID>ZB_GC3KEY</FieldID><FieldID>ZB_GC4KEY</FieldID><FieldID>ZB_GUID</FieldID><FieldID>ZB_REPPER</FieldID><FieldID>ZB_WID</FieldID><FieldID>ZC_FUNCID</FieldID><FieldID>ZC_GAADID</FieldID><FieldID>ZC_RGPDTY</FieldID></Selection></Selections>
TRANSFORMATION = \ROOT\WEBFOLDERS\XXXXX\XXXXX\DATAMANAGER\TRANSFORMATIONFILES\TRANSACTION DATA\IC_ELIMINATION\AMOUNT_GCKEY3.XLS
TARGETMODE = Yes
RUNLOGIC = No
CHECKLCK = No
</LINK_PROCESS>
</LINK_PROCESSES>

<LINK_PROCESSES>
<LINK_PROCESS_PROCESSID='AMT GC4'>
InforProvide = XXXXX
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="Selection"><Attribute><ID>ZB_DATE</ID><Operator>1</Operator><LowValue>20170331</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0CHNGID</FieldID><FieldID>0CS_CHART</FieldID><FieldID>0CS_DIMEN</FieldID><FieldID>0CS_ITEM</FieldID><FieldID>0CS_PARTNER</FieldID><FieldID>0CS_SITEM</FieldID><FieldID>0CS_SITEMCT</FieldID><FieldID>0CS_UNIT</FieldID><FieldID>0CS_VERSION</FieldID><FieldID>0CURKEY_GC</FieldID><FieldID>0CURKEY_LC</FieldID><FieldID>0CURKEY_TC</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>ZB_CURGC2</FieldID><FieldID>ZB_CURGC3</FieldID><FieldID>ZB_CURGC4</FieldID><FieldID>ZB_CURLC</FieldID><FieldID>ZB_CURTC</FieldID><FieldID>ZB_DATE</FieldID><FieldID>ZB_GC1KEY</FieldID><FieldID>ZB_GC2KEY</FieldID><FieldID>ZB_GC3KEY</FieldID><FieldID>ZB_GC4KEY</FieldID><FieldID>ZB_GUID</FieldID><FieldID>ZB_REPPER</FieldID><FieldID>ZB_WID</FieldID><FieldID>ZC_FUNCID</FieldID><FieldID>ZC_GAADID</FieldID><FieldID>ZC_RGPDTY</FieldID></Selection></Selections>
TRANSFORMATION = \ROOT\WEBFOLDERS\XXXXX\XXXXX\DATAMANAGER\TRANSFORMATIONFILES\TRANSACTION DATA\IC_ELIMINATION\AMOUNT_GCKEY4.XLS
TARGETMODE = Yes
RUNLOGIC = No
CHECKLCK = No
</LINK_PROCESS>
</LINK_PROCESSES>

Thanks & Regards,

Ramesh.