Introduction

If an Analysis Item displays a large number of input ready cells and you load or refresh the template the spinning wheel can stop for up to a minute until the expected data is shown. Also the “com.sap.ip.bi.rig.Planning” and “com.sap.ip.bi.rig.CopyPaste” modules can’t cope with that and a huge perfromance impact is expirienced. Both modules are described in Analysis Web Item Parameter Modification.

com.sap.ip.bi.rig.Input

The module com.sap.ip.bi.rig.Input replaces both above ones. The “copy&paste” functionality got enhanced and supports now also “CTRL-C” and “CTRL-V”.

The two modules “RIG Planning” and “RIG Copy & Paste” can be replaced with the code below. The value ENABLE_DYNAMIC_INPUT improves perfromance significantly if a huge number of input ready cells are shown or copy/pasted as the rendering performance is now on clientside.

<bi:MODIFICATION type=”CHOICE” value=”MOD_SINGLE_MODULE” >

  <bi:MOD_SINGLE_MODULE type=”COMPOSITE” >

    <bi:ACTIVE value=”X” />

      <bi:MOD_SELECT type=”CHOICE” value=”MOD_GENERIC_MODULE” >

        <bi:MOD_GENERIC_MODULE type=”COMPOSITE” >

          <bi:MOD_REFERENCE value=”com.sap.ip.bi.rig.Input” />

            <bi:MOD_PARAMETER_LIST type=”ORDEREDLIST” >

              <bi:MOD_PARAMETER index=”1″ type=”COMPOSITE” >

                 <bi:MOD_PARAM_NAME value=”ENABLE_DYNAMIC_INPUT”>

                <bi:MOD_PARAM_VALUE type=”CHOICE” value=”BOOLEAN” >

                  <bi:BOOLEAN value=”X” />

               </bi:MOD_PARAM_VALUE>

           </bi:MOD_PARAMETER>

        </bi:MOD_PARAMETER_LIST>

      </bi:MOD_GENERIC_MODULE>

    </bi:MOD_SELECT>

  </bi:MOD_SINGLE_MODULE>

</bi:MODIFICATION>

The following parameters are available. Those are decribed in  note 1644770.

  • INCLUDE
  • ENABLE_DYNAMIC_INPUT
  • RESTORE_CELL_FOCUS
  • RESTORE_CELL_FOCUS_CUSTOM_FUNCTION
  • DISABLE_SELECT_ON_CLICK

If you plan to copy/paste a huge amount of cells you need to increase the MaxParameterCount described in Note 1678387

To report this post you need to login first.

2 Comments

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

    1. Dinesh Vemula

      Hi Martin,

      I implemented yours Copy paste functionality but i m facing some issues.In our table,where our data cells are empty and when we use the keyword ‘SHIFT’ to select the different cells and use ‘CTRL+C’ and try to paste it on notepad,its showing duplicate data for those empty cells E.g if the enitre row has word “Result” written in one data cell  then when we try to select different cells with “SHIFT” and copy it and then paste it on notepad then it will show the word “Result” in empty data cells too.Could u please help us and suggest us whether where we are going wrong

      Regards,

      Dinesh

      (0) 

Leave a Reply