Skip to Content
avatar image
Former Member

How to do Exception on Date(Key Figure) comparing to System date


I want to define a exception on date(KF) comparing to System date. I will explain you the scenario. The date on which i am trying to build a exception is actually a characteristic but I converted that into KF in query.

I tried all methods creating formula variable with manual entry in exception defining on zdate and also tried formula variable with replacement path which replaces with system date. But definition is correct but when I run I dont see the exception colours there..Am I defining something wrong in the exceptions!!!

Let me know if you need any more information!!


Edited by: anil BR on Oct 17, 2008 10:40 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 18, 2008 at 05:22 AM

    Hi Anil,

    The system interprets the threshold values in the exceptions as numbers.

    This means for example that is not possible to enter a date directly as a threshold value. In BEx Query Designer, you can specify a date as a threshold value by using a form variable with processing type Customer Exit as the threshold value. The form variable must have the dimension Date. The customer exit provides the required date.


    If you are using web reporting, you can try this.

    Instead of creating exception based on date, create a new formula/CKF by deriving difference between 2 dates, and use that for exception reporting(you can hide this, if you dont want to display).

    You can set whether the exception is to affect data cells or characteristic cells. In accordance with your setting, the highlighting for the exception is displayed on the numbers for the selected key figure or the text for the most detailed characteristic value.

    When you display the exception on data cells, you can choose whether the exception is to be displayed on the evaluated structure element, on another structure element, or on all structure elements.

    When you display the exception on characteristic cells, you can choose whether the exception is to be displayed on the rows, on the columns, or on both the rows and column

    More info: [Defining Exceptions|]

    Hope it Helps


    [Dont forget to close the call by assigning poings.... - Food for Points: Make a Difference through Community Contribution!|]

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      I tried that too..But its not giving output as per requirement. Please check the requirement in the above posts.