Skip to Content

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

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 23, 2018 at 03:10 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 19, 2018 at 05:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.