How can I define an exception in query designer on hidden cells?

[former_member358853]

My task is to highlight those data entry cells in a query which have been changed now compared to the values stored in the last saved version of the query. I have taken an example of Quantity.

For this, we have the following columns:

1. The column available for data entry QC (current version)

2. The column which derives the data from the previous perid QL (data saved in the last version derived via a customer exit variable)

3. The column with the formula which calculates the difference between QC and QL on which the exception can be defined.

I want to define an exception on column 1, which says highlight the cell if the corresponding value in column 3 is not 0. This works perfectly until I hide columns 2 & 3. The requirement is to hide columns 2 & 3, because these should not be visible to the end user who enters data in this query. My research so far has indicated clearly that I cannot create exceptions/conditional formatting on hidden cells so far.

Has anyone found a workaround this problem so far? Perhaps something in BW?

[former_member151004]

Hi Dewikarani Rao,

I believe that the question should be added to the "BW Business Explorer (SAP BEx)" area.
Could you please change the tag of this question?

Thanks,
Diego Ferrary

[gcybill]

Hi Dewikarani,

To complement to @eugeniy.lancev notes, you can actually refer to the workaround solution in the note 1372271.

Only known workaround for the BI/BW Java runtime is to use the "Column Width Module" (search SAP Help for "Example Column Width Module") and to hide the column or row of the structure element the exception is defined on. For Analysis Office you may try to hide the corrrsponding row or column.

You can practically set column width (any client applicable) to as minimum as possible to as if the column is hidden.

[former_member231709]

The highlighting doesn't work with hidden structure elements. For more details see note 1372271 - BICS: Exception highlighting feature of BICS based clients and frontends