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