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

[Former Member]

Hello,

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!!

Thanks.

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

[Former Member]

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.

OR

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|http://help.sap.com/saphelp_nw70/helpdata/EN/43/21b4cd14cd06f4e10000000a422035/content.htm]

Hope it Helps

Srini

[Dont forget to close the call by assigning poings.... - Food for Points: Make a Difference through Community Contribution!|https://www.sdn.sap.com/irj/sdn/index?rid=/webcontent/uuid/007928c5-c4ef-2a10-d9a3-8109ae621a82]

[Former Member]

Hi Srinivas,

Thanks for your quick reply. See my comments below :

1)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.

-->Actually I tried this solution before this post : created customer exit with system date populating in I-STEP=2 and tried I-STEP=1 too also and defined DATE in Dimension ID's before this. But When I run the query the expected ZDATE column which should show RED only when the ZDATE<system date is not behaving that way..Its showing RED for the whole column irrespective of date. I need green to be displayed for ZDATE>system date. Can you throw some light on this aspect?

OR

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

2) 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

--> I tried this too prior to this post: I created a formula based on our ZDATE key figure and system date. So that we get numerical values and defined the exception on that. Its working fine by displaying green and RED as expected. But the requirement is to display exception only on ZDATE as per the logic. It should not effect whole query. If we define exception on the formula its not working out. I also tried defining exception on this formula and display the output on the 'FOLLOWING STRUCTURE ELEMENT'-ZDATE. That means it should display the exception definition on ZDATE rather than our formula. But its not happening that way..Its again displaying the exception on the formula and leaving out ZDATE

I hope I am clear enough. Let me know if you need anymore information.

[Former Member]

Hi,

Create a customer exit variable at exceptions which will get the current date and use it to define the exceptions.

Regards.

[Former Member]

Vinay,

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

Thanks,

Anil