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.
Hi Harish,
Useful information ..thanks for sharing 🙂 .
Hi Ganesh,
Thanks for the feedback. 🙂
Br, Harish
Hi Harish,
Nice approach and easy step by step 😉 Expecting lot more on WAD from you 😛
Thanks for sharing.
Regards,
Suman
Hi Suman,
Thanks for the cheerful comments and the rating.
Br, Harish
Hi Harish,
Good approach and nice presentation. Very useful one.
Thanks for your efforts and sharing with us.
Thanks
Raman
Hi Raman,
Appreciate your comments and feedback.
Br, Harish
Nice one,
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