compounded default variable in web template URL

[claudio_ciardelli2]

Hello, I would like to pass the value of a variable TST_CSALES on the compounded characteristic 0CUST_SALES (compounded to Division, Distribution Channel and Sales Organisation) to a BW web template.

I know the general syntax should be:

(URL)&VAR_NAME_1=<variablename>&VAR_EXT_1=<value>

But in the case of my variable how do I write the value.

If I enter a value manually it has to be like:

1/1/1/10000

Should my UR contain this:

(URL)&VAR_NAME_1=TST_CSALES&VAR_EXT_1=1/1/1/10000

I do not see any mention of compounding in the webAPI reference for BW.

I am on BW3.5

[former_member184494 · Accepted solution]

Claudio,

I think it shouold be

PROOCESS_VARIABLE=<variablename>&VAR_EXT_1=<value>

Please check and revert..

Arun

Assigning points is a way of saying thank you on SDN

[claudio_ciardelli2 · Accepted solution]

No, it does not work.

[former_member184494 · Accepted solution]

Claudio,

This is what we implemented :

<SAPBW Server Details>?SAPLanguage=EN&BSPLanguage=E&CMD=LDOC&TEMPLATE_ID=<Yourtemplatename>&cmd1=PROCESS_VARIABLES&SUBCMD=VAR_SUBMIT&VAR_NAME_1=<your variable name>&VAR_VALUE_EXT_1=+<variable value>

Arun Varadarajan

[former_member184494 · Accepted solution]

Was not able to see full URL and wanted to make sure you got the whole line

<BW Server Details>&CMD=LDOC&TEMPLATE_ID=<your template>&cmd1=PROCESS_VARIABLES

&SUBCMD=VAR_SUBMIT&VAR_NAME_1=SSMONTH&VAR_VALUE_EXT_1=

<your variable value>

Please join the above into one single line... this works for us currently.

The URL is valid but if your value is not correct , you will get an error which says invalid value or the report will run without the variable. Please make sure that the variable format is proper. in alll likelihood your variable value might be 11110000 without the /

Arun Varadarajan

Message was edited by: Arun Varadarajan

[claudio_ciardelli2 · Accepted solution]

Arun,

I still get the same error.

Did you work with compounded variables?

[former_member184494 · Accepted solution]

Mine was a simple variable on Month , so passed the required value.

When you input it using the variable entry , try

11110000 , if it automatically changes it to 1/1/1/10000 the code above might work , else try 1/1/1/10000 in the URL given above.

Arun

Also can you send the URL ? with the details like server name etc removed ?

Message was edited by: Arun Varadarajan

[claudio_ciardelli2]

I need to mention that the tst_csal variable is of hierarchy node type. This might be related the problem below

I managed to pass the value using this syntax

<url>&var_name_1=TST_CSAL&var_value_ext_1=1%2f1%2f1%2f10000

The value 1/1/1/10000 gets into the variable tst_csales in the selectio screen.

However, if I execute or try to change this value I get an error:

When trying to change the value:

System error in program CL_RSR_WWW_RENDERER and form GET_VARDEF_FOR_F4:03

When I push execute or check;

Web application processing terminated

Diagnosis

The system had to terminate processing of the Web application.

The reason could be that the system was no longer able to find the Web application server session.

System response

Processing the navigation step is not possible.

Procedure

Call up the Web Application again.

Note: Use the start URL and not the URL that is currently displayed in the Web Browser.

Procedure for System Administration

Notification Number BRAIN 278