Modification Module “com.sap.ip.bi.rig.Input” for #SAP #BW-IP
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
Hi Martin,
thanks, very usefull information!
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