Entering content frame

Function documentation Command Sequences Locate the document in its SAP Library structure

Use

Many questions require you to change several objects in different ways with commands. For example, you cannot use the current methods with a single request (command) for filtering a data provider for the fiscal year 1999 and another data provider for 2000.

A command sequence allows you to add new commands to an original command. Data is requested from the OLAP processor and the HTML page is sent back to the Web Browser only after all of the commands have been processed.

·        The subsequent command sequences are added to the original command as parameter CMD_N. If the command is within an >SAP_BW_URL> tag, you need to make sure that the complete command sequence is set in quotation marks. No quotation marks can be set within the command sequence. If the command sequence is transported using a URL, you have to make sure that you replace the characters ‘=’ and ‘&’ with their hexadecimal display in the command sequence

¡        Replace ‘=’ with ‘%3D’

¡        Replace ‘&’ with ‘%26’

Each subsequent command can have a maximum of 250 characters. If it contains more characters, these extra characters are cut off.

Note

If the command sequence is too large to fit in a URL then you can add the parameter ‘NO_OUTPUT' to a command. As a result, the command is executed and an empty page is returned. However, no data is read. This is useful, for example, if a main frame is addressed from a control frame. Using JavaScript, you can carry out a sequence of single commands in the main frame and leave out the ‘NO_OUTPUT’ parameter from the last command. See also Example Scenario for the Parameter NO_OUTPUT.

See examples 1 and 2 below.

·        The parameter APPLY_CMD_ON_TARGET and its values “X” and “ ” allow you to choose whether the subsequent commands are used in a new page created by the main command or whether they are used in the same page as the main command.

See example 3 below.

Examples

...

       1.      Start a Web application and filter data provider 1 according to DE and data provider 2 according to US

http://myAppServer:myPort/SAP/BW/BEx?CMD=LDOC&template_id=yourTemplate&CMD_1=DATA_PROVIDER%3DDP1%26FILTER_IOBJNM%3D0COUNTRY%26FILTER_VALUE%3DDE&CMD_2=DATA_PROVIDER%3DDP2%26FILTER_IOBJNM%3D0COUNTRY%26FILTER_VALUE%3DUS

       2.      Command URL to filter Data Provider 1 according to calendar year 2000, change the title of the GRAPHIC graphic to ‘2000’, and change the title of the TABLE table to ‘Details2000’

<SAP_BW_URL DATA_PROVIDER='DP1' FILTER_IOBJNM='0CALYEAR' FILTER_VALUE='2000' CMD_1='ITEM=GRAPHIC&CAPTION=2000' CMD_2='ITEM=TABLE&CAPTION=Details2000'>

       3.      Page 1 contains a link to the details. This link starts page 2. The navigation status of the page 1 print parameters is transferred and at the same time the target page is parameterized, for example, navigation is switched off.

<SAP_BW_URL cmd="release_data_provider" data_provider="dp" template_id="template_2" apply_cmd_on_target="X" cmd_1="item=*&multi=X&generate_links=">

       4.      Swap the axes of DataProvider 1 and place the 0Country characteristic in the rows

<SAP_BW_URL cmd=“SWITCH_AXES“ data_provider=“dp“ cmd_1=“data_provider=dp&cmd=expand&iobjnm=0Country&axis=y“>

 

Leaving content frame