1702675 - How to pass BEx variable values to an Xcelsius dashboard

Symptom

How to pass BEx variable values to an Xcelsius dashboard

Environment

Client Details

Xcelsius Enterprise designer SP2(trial or engage server do not offer this connectivity) or higher
Dashboard designer 4.0 all support packs and patches.
SAP GUI patch 901 or Higher.

Server Details

Sap Netweaver 7.0 EHP01 SP5 or higher(JAVA and ABAP stacks)

Important note:The BI java Stack and single sign on between ABAP and java are must to get this connectivity working.

Resolution

BEx variables can be passed to an Xcelsius dashboard using BI_COMMAND syntax added to the BEx Web launcher URL.

First Determine the BEx Web Launcher URL for your dashboard, it should look like this one :

http://myportal:50100/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons
!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?DASHBOARD=Z_MYDASHBOARD_TECH_NAME

This is the URL launched from Xcelsius Designer when using the option SAP / Launch. The DASHBOARD=Z_MYDASHBOARD_TECH_NAME parameter is the specific query string parameter that identifies which dashboard to display, where Z_MYDASHBOARD_TECH_NAME is the technical name of Xcelsius dashboard object published to the NetWeaver BW server.

Append the below BI_COMMAND syntax along with technical name of the BEx variable in the above URL

&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=TECHNICAL NAME OF BEx VARIABLE TO BE PASSED.
&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 OF BEx VARIABLE

For Example

http://<servername>:<serverport>/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?DASHBOARD=Z_MYDASHBOARD_TECH_NAME&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=TECHNICAL NAME OF BEx VARIABLE TO BE PASSED
&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 OF BEx VARIABLE

For further help check http://help.sap.com/saphelp_nw70ehp1/helpdata/en/19/c640149a0441419d921c74a0ec4680/frameset.htm

Keywords

Xcelsius, BEx, Netweaver, URL parameters, variable , KBA , BW-BEX-ET-XC , Please, use component BI-RA-XL. , How To

Product

SAP BusinessObjects Dashboards software 4.0 ; SAP BusinessObjects Xcelsius Enterprise 2008