Scrolling Customizations in Web Application Designer (BEx)

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

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

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

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

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

Number of Data columns displayed at once
Number of Data rows displayed at once

If any ROW or COLUMN is not defined, by default, the header row and leading columns are selected for scrolling.

8 Comments

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

Ganesh Bothe December 16, 2013 at 11:42 am

Hi Harish,

Useful information ..thanks for sharing 🙂 .

like (0)
1. Harish Kumar Post authorDecember 16, 2013 at 12:48 pm
  
  Hi Ganesh,
  
  Thanks for the feedback. 🙂
  
  Br, Harish
  
  like (0)
Suman Chakravarthy K December 16, 2013 at 11:44 am

Hi Harish,

Nice approach and easy step by step 😉 Expecting lot more on WAD from you 😛

Thanks for sharing.

Regards,

Suman

like (0)
1. Harish Kumar Post authorDecember 16, 2013 at 12:49 pm
  
  Hi Suman,
  
  Thanks for the cheerful comments and the rating.
  
  Br, Harish
  
  like (0)
Raman Korrapati December 16, 2013 at 2:06 pm

Hi Harish,

Good approach and nice presentation. Very useful one.

Thanks for your efforts and sharing with us.

Thanks

Raman

like (0)
1. Harish Kumar Post authorDecember 17, 2013 at 5:17 am
  
  Hi Raman,
  
  Appreciate your comments and feedback.
  
  Br, Harish
  
  like (0)
Giri Prasad January 23, 2014 at 11:58 am

Nice one,

like (0)
Matteo Nicora March 6, 2017 at 9:22 am

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

like (0)