Web API

[Former Member]

Hey,

Can anyone give me some practical expample of using WEB API's for table in Web Application?

Cheers!!!!!!!!!

[Former Member · Accepted solution]

Hi,

The Business Explorer Web Application Design enables you to apply generic OLAP navigation to BW data in Web applications and Business Intelligence cockpits for simple up to highly specialized scenarios. You can implement highly individual scenarios with customer-defined interface elements by using standard markup languages and Web design APIs. Web application design comprises a broad spectrum of Web-based business intelligence scenarios, which you can adjust to meet your individual needs using standard Web technologies.

Here are some of the example why you use Web API

<b>

Command URL in the Web template:

<a href=”<SAP_BW_URL cmd=’ldoc’ TEMPLATE_ID=’EXAMPLE_TEMPLATE’>”></a>

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%26F...

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“>

</b>

You can use Web API's to customize tables for passing filter values and so on..

thanks,

Deepak

[Former Member · Accepted solution]

hi deepak thanks for ur input.....but i am looking for some practical scenario....u have any idea?

[Former Member · Accepted solution]

Hi,

We have some reports which user needs to navigate with out using RRI, for that we enhanced table interface, wrote a custom code which will use Web API to pass the filter value to next report without RRI (BW URL Command with Filter Value Command).

Other scenario, Trend Analysis Reporting with Icons or Graphs which will show a detail Chart or Report when you click these icons in the table.

Sometimes you dont want to display certain values Web Report, you cant control then in the query,so you need to write javascript or modify classes..

here is a sample code:

ZMODIFYTABLE: Process Scorecard

Modify Table Class:

method CAPTION_CELL .

*CALL METHOD SUPER->CAPTION_CELL

• EXPORTING

• I_X =

• I_Y =

• I_IS_EMPTY =

• I_IOBJNM_ROW =

• I_ATTRINM_ROW =

• I_TEXT_ROW =

• I_IOBJNM_COLUMN =

• I_ATTRINM_COLUMN =

• I_TEXT_COLUMN =

• I_IS_REPETITION =

• I_COLSPAN =

• I_ROWSPAN =

• CHANGING

• C_CELL_ID =

• C_CELL_CONTENT =

• C_CELL_STYLE =

• C_CELL_TD_EXTEND =

• .

*

• break-point.

• Remove Brand Header from table

IF C_CELL_CONTENT = 'XXX Brand'.

C_CELL_CONTENT = ' '.

ENDIF.

• Remove 'Process APPSXXXX' Header from table

IF C_CELL_CONTENT = 'Process APPSXXXX'.

C_CELL_CONTENT = ' '.

ENDIF.

• Remove 'XXXXXXXX XXXXXXX Header from table

IF C_CELL_CONTENT = 'XXXXXXXX XXXXXXX '.

C_CELL_CONTENT = ' '.

ENDIF.

• Remove XXXXX Header from table

IF C_CELL_CONTENT = 'XXXXXX'.

C_CELL_CONTENT = ' '.

ENDIF.

endmethod.

Hope this Helps what you are looking for..

thanks,

Deepak Kunavarapu

[Former Member]

Deleted