Skip to Content

Scrolling Customizations in Web Application Designer (BEx)

December 16, 2013 | 526 Views |
 bexsapsap bex querysap bisap business explorer (bex)wad
Follow

Objective

This document will provide information on how to enable scroll bars for an analysis item in WAD and steps to customize scrolling

Steps

Step 1: Create a Web Application

Step 2: In the ANALYSIS ITEM that is assigned a query, navigate to ‘Internal Display’ properties, set Modification as ‘Module List’ or ‘Single Module’.

Note: If you’re going to implement multiple modification modules besides Scrolling, then use Module List as Modification

1.JPG

Step 3: Create a new Single modification module as below and define Generic Module (com.sap.ip.bi.rig.Scrolling) for Scrolling as shown below

2.JPG

Step 4: Customizations

    

          1. Define a required number of columns/rows for scrolling

For defining a required number of columns to be available for scrolling, we need to define additional parameter for this.  The parameter used is COLUMN and defined as shown below.  The parameter is BOOLEAN and placeholder is INTEGER of value 4. This will freeze first four columns in your analysis item. The same is applicable for freezing rows by defining ROW instead of COLUMN              

3.JPG

          2. Define adjustable window of Scroll enabled Analysis item

Once we have enabled scrolling the window size you have defined for Analysis item may not work and hence you need to define parameters for adjusting width of the window. The parameter used is WIDTH and define as below. I have used the below width to set the pane according to my window size. This parameter is of type string and value as document.body.clientWidth – 100. In order to set the analysis item width to be half of window size define string value as document.body.clientWidth / 2

4.JPG

Note:

  • Scrolling will work if all the rows and columns of the analysis item are displayed. To set these parameters, assign zero to the following parameters
    1. Number of Data columns displayed at once
    2. Number of Data rows displayed at once

5.JPG

  • If any ROW or COLUMN is not defined, by default, the header row and leading columns are selected for scrolling.
To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  5. Former Member

    Hi Harish,

     

    is it possible to set the parameters for the web item dynamically by user input?

    I have a table with free characteristics so the number of columns is variable. I need to set the number of columns frozen dynamically. Is it possible to change this parameter assigning a value from a user input variable?

    Thank you in advance.

    best regards

    Matteo

     

    (0) 

Leave a Reply