Hierarchical Filter Item should show no old intervals

[former_member271371]

I have built a hierarchy filter in my template.

The filter shows old hierarchy node. How can I suppress this?

example:

abc: Validity 01/01/2006 - 01/01/2008

abc: Validity 02/01/2008 - 09/29/2015

Only the second line is to be displayed.

Do I need to make this about the designer or WAD?

regards

Kerim

[kohesco]

Hi,

I believe your hierarchy is time dependant.  When you add time dependant objects in your query designer.  You are able to set a Key date.  The key date determens in which time interval you want to see the data of your timedependent object.  So please check in the query designer what is filled in for key date.  Go to the properties of your query in query designer and check Key date, fill in a sapvariable that sets the current day if you want to see the data in the present. ( for example variable:0CWD).

Grtz

Koen

[former_member271371]

Hello Koen,

when I use the 2 June 2007 as Key Date, then the displayed valid for this date. But I want to get displayed that were greater than or equal 01 January 2005. But I can not enter a greater than or equal 01.01.2005. How can I put this?

Regards
Kerim

[kohesco]

Hi,

a keydate is a moment in time that fits in the timerange of an object.

company   fromdate       todate

    A         01.01.2000   31.12.2004

    B         01.01.2004   31.12.2007

    C         01.01.2007   31.12.9999

key date = 01.01.2005 gives your company = B

Key date >= 01.01.2005 like your demand, can not be used, because it has to give two values (B and C), so for key date you can not set greater than, only EQUAL TO.

You will have to setup your timedependency correctly, meaning that you last todate has to be 31.12.9999

grtz

Koen