Parameters to Call BEx Web Applications

[mpatos77]

hi all.
I am making a call to a query from Visual Composer to them I am
occupying the following code:

http://server:50000/irj/servlet/prt/por ... 0050_Q0045
&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALYE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZYEAR
&BI_COMMAND_2-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=Z0COSCENTER_0ORGUNIT
&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VAL_ZORGUNIT
&BI_COMMAND_3-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALMMO
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZMONTH

So far so good, I can run the querys without problem.
But when attempting to call a query that has as an input variable
interval, I failed to find the way to go.

Someone could give me some indication about it, what would be the way
called an interval.

The input variable for the quey is used for the feature 0CALMONTH2 (0P_CALMO - ZDATE_END)

I tried using the following alternatives, all with no luck:
alternative 1:
&BI_COMMAND_3-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALMO - ZDATE_END
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZMONTH1 - VALUE_ZMONTH2

alternative 2:

&BI_COMMAND_3-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALMMO
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZMONTH1
&BI_COMMAND_4-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_4-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=ZDATE_END
&BI_COMMAND_4-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_4-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZMONTH2



search within to achieve the following code, but I've tried
managed to find the right way to use it, any suggestions?

&BI_COMMAND_3-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=INFO_OBJECT_MEMBER_VARIABLE
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1=INTERVAL_SELECTION
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_LOW_MEMBER=MEMBER_NAME
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_LOW_MEMBER-MEMBER_NAME=VALUE_1
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_HIGH_MEMBER=MEMBER_NAME
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_HIGH_MEMBER-MEMBER_NAME=VALUE_2/b]
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=[b]¿?


from now thanks for your help

Manuel

[vasukolli]

Hello Manuel,

did you find a solution?

We have same issue, trying to form a command url for Posting date but it is not working.. any clue??

&BI_COMMAND_5-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_5-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=DT_POSTDATE
&BI_COMMAND_5-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=INFO_OBJECT_MEMBER_VARIABLE
&BI_COMMAND_5-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1=RANGE_SELECTION
&BI_COMMAND_5-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-RANGE_SELECTION=INTERVAL_SELECTION
&BI_COMMAND_5-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_LOW_MEMBER=MEMBER_NAME
&BI_COMMAND_5-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_LOW_MEMBER-MEMBER_NAME=03102008
&BI_COMMAND_5-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_HIGH_MEMBER=MEMBER_NAME
&BI_COMMAND_5-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_HIGH_MEMBER-MEMBER_NAME=05152009

Please let me know

Som

[hellasangel]

I found a very good article here on calling a Web Application through URL parameters:
http://www.just-bi.nl/news/?article=40

A BEx Web Template 7.0 can be opened via an URL. By sending certain parameters the variables can be filled automatically. This will be explained in two steps. First we open the template without setting the variables. In the next step we explain how to pass the variable values as well.

Step 1: Open a Web Template via URL (without filling variables)
The URL that is required to open the BEx Web Tempate 7.0 exists of three different parts:

•Hostname
•Path
•Template

Hostname
The easiest way to retrieve the hostname of each server is by just executing the web template and copy the host name. Everything until "/irj/..." is part of the hostname:

http://hostname:9999/irj/...
Hostname = http://hostname:9999/

Note that every system has its own hostname. So the hostname for development is different than the hostname for acceptance and production. You need to retrieve the hostnames for each of you systems on which the dashboard will be published. You can use logic in Xcelsius to determine the system you are on (in InfoView via the CELogonToken or in a BEx Web Template via Javascript - more details in an article will follow).
Based on the system on which the dashboard is opened, the hostname should be set.

Path
The path is static and will be the same on each system:

/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons! 2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?

Template
A parameter called TEMPLATE must be passed. This parameter should contain the technical name of the BEx Web Template 7.0 that should be opened.

TEMPLATE=ZTECHNAME_OF_TEMPLATE


Combined we will have the following URL to open a BEx Web Template 7.0:

http://hostname:9999/irj/servlet/prt/po ... F_TEMPLATE

Of course it is possible to dynamically change the technical name of the Web Template. This enables you to assign different templates to different KPI values in your dashboard. Based on the selected KPI the template can then be opened that contains the details of the KPI.

Step 2: Pass the selections in Xcelsius automatically to the variables in the BEx query
The next step is passing the selections made in Xcelsius to the variables of the BEx query. This can be done by adjusting the URL we have created in the first step. Below you will see the ways you need to adjust the URL (based on the type of variable).

One variable (of type single value)
&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALYE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZYEAR

One variable (of type multiple single values)
&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=ZZIMR_DM1
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=CACAM;EIG

One variable (of type interval values)
&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=ZZIMRINT
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=CACAM+-+EIG

One variable (of type Selection Option)
Including single value CACAM, Excluding single value EIG

&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=ZZIMRINT
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=CACAM+-+EIG

Including range CACAM to EIG

&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=ZIMRSELO
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=CACAM+-+EIG

Excluding range CACAM to EIG

&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=ZIMRSELO
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=!CACAM+-+EIG

Two variables (both of type single value)
&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALYE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZYEAR

&BI_COMMAND_2-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=Z0COSCENTER_0ORGUNIT
&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VAL_ZORGUNIT