Example: Empty Cells as Non Input-Enabled Module 

Definition

Using the Empty Cells as Non Input-Enabled module (com.sap.ip.bi.rig.NonInputableEmptyCells) you can make input-enabled cells non input-enabled.

In BI Integrated planning, automatic creation of rows and/or columns can lead to cells being created that are input enabled from a technical point of view, but for process reasons should not be input-enabled in one or more queries. Cells like these are normally locked using data slices, which means though that these combinations are locked against changes (including changes by planning functions) in the entire system. If you only want the lock to apply in one or more queries, you can override the input-enabledness of the cells in the Web Item analysis, using the module.

The technical name of this implementation is com.sap.ip.bi.rig.NonInputableEmptyCells.

Make sure that the module is activated. Otherwise, empty cells will remain input enabled.

Example

<bi:ANALYSIS_ITEM name="ANALYSIS_ITEM_1" designwidth="400" designheight="200" >

    <bi:DATA_PROVIDER_REF value="DP_1" />

    <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.NonInputableEmptyCells" />

                </bi:MOD_GENERIC_MODULE>

            </bi:MOD_SELECT>

        </bi:MOD_SINGLE_MODULE>

    </bi:MODIFICATION>

</bi:ANALYSIS_ITEM>

The section below describes the options offered in this module. These options influence how the module functions and are specified as parameters in the parameter list (MOD_PARAMETER_LIST). A parameter is made up of the following elements:

●      Name/Expression
(MOD_PARAM_NAME)

●      Value (MOD_PARAM_VALUE)

●      Placeholder List (MOD_PLACEHOLDER_LIST)

If the Placeholder List parameter is not specified, you can ignore this parameter.

Column (Optional)

If no columns are specified, the negative numbers are formatted in all columns.

Parameter	Value	Description
Name/Expression (MOD_PARAM_NAME)	COLUMN	Using this parameter you can specify the column containing the empty cells that you don’t want to set to input-enabled. The Set Column Width module describes the possible options for specifying a column as a parameter. More information: Example: Column Width Module
Value (MOD_PARAM_VALUE)	Boolean	Active

Example with non input-enabled empty cells in column with index 3

<bi:MOD_PARAM_NAME value="COLUMN" />

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

    <bi:BOOLEAN value="X" />

</bi:MOD_PARAM_VALUE>

<bi:MOD_PLACEHOLDER_LIST type="ORDEREDLIST" >

    <bi:MOD_PARAM_VALUE type="CHOICE" index="1" value="INTEGER" >

        <bi:INTEGER value="3" />

    </bi:MOD_PARAM_VALUE>

</bi:MOD_PLACEHOLDER_LIST>