Skip to Content

Objective

This document describes some of the functions that make the planning enabled web template to be user-friendly. Some of the standard enhancements available are

  1. Select the entire cell content on a click
  2. Copy and Paste data to Web template
  3. Jump to next cell on pressing Enter

Let us see in detail how to achieve the above enhancements.

Steps:

Step 1: Create a new Single Module modification for your Analysis Item in the Internal Display.

1.JPG


Step 2: Define an ALIAS and use the implementation com.sap.ip.bi.rig.Planning

2.JPG

2.2.JPG



Step 3: Customizations

To achieve the customizations mentioned in the objective, we need to define appropriate parameters for the implementation com.sap.ip.bi.rig.Planning

     1. Select the entire cell content on a mouse click

Oftentimes in a planning enabled web template, users frequently edits the planned data. In order to do so, user needs to double-click the input enabled cell to select the entire entry. This enhancement will allow users to select the entire cell content by simply clicking the input-enabled cell once.

To achieve this, we need to create parameter ENABLE_SELECT_ON_CLICK of type Boolean as below.

To deactivate this setting, use parameter DISABLE_SELECT_ON_CLICK of type Boolean value.

3.JPG 

      2. Copy Paste data to Web template

Sometimes, users might have entered the plan values in an excel sheet and would like to copy and paste it to the web template. To achieve this, we need to use parameter ENABLE_COPY_PASTE.

To deactivate this setting,  modify parameter as DISABLE_COPY_PASTE and set it as active.

Note:

Sometimes if you have used Scrolling module (com.sap.ip.bi.rig.Scrolling) alongside Planning module (com.sap.ip.bi.rig.Planning), Copy Paste functionality won’t work for scrollable columns and you can paste only for fixed area. Check sap note 1878087

4.JPG

     3. Jump to next row/column on pressing Enter

In a planning web template, users might want to have the interface similar to excel, where upon clicking Enter, the cursor should move to next row/column. To navigate to next cell in the same row, define parameter as NEXT_CELL_ROW_FIRST.

For next row of same column on pressing return, define parameter as NEXT_CELL_COLUMN_FIRST.

  5.JPG

To disable the above jumping settings, use parameter DISABLE_NEXT_CELL_ON_RETURN and set it as active of type boolean.


More information on Scrolling customizations in WAD is available in the below document.

Scrolling Customizations in Web Application Designer (BEx)

Note:

1. Some of the customizations might be available by default and if’s not available by default, you can do so by using appropriate parameters.

2. All the above customizations will work on a web template built over an input-ready query.

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply