Skip to Content
0
Former Member
Aug 12, 2009 at 06:14 PM

using a range of dates for Key Date

257 Views

In a HR Bi data warehouse, we have a position-to-position hierarchy, where each of the nodes are time dependent. So, it shows for each node, valid from and valid to dates, and all the employees who are reporting to that position. This hierarchy is built on the infoobject 0HRPOSITION, which is maintained in R/3 and extracted to BI.

Let us take an example: Position 1000 is valid from 1-1-2006 to 6-30-2006 Employees reporting to this position are A,B,C,D

Position 1000 is valid from 7-1-2006 to 12-31-9999 Employees reporting to this position are A,E,F,G

When a user chooses the position 1000, and date range 1-1-2006 to 12-31-2006, it show the complete list of employees as

A,B,C,D,E,F,G.

Because the Keydate can only be a single value, and it is automatically taking today's date, and pulling the nodes based on that.

I have created a hierarchy node variable on the 0HRPOSITION infoObject, and entered the value 1000, with no value for the keydate.

The system is simply showing employees, A,E,F and G. That is my problem

My requirement is this: I like to be able to give a date range, (for the hierarchy) say from 1-1-2006 to 12/31/2006 and get the complete list of Employees, which is A,B,C,D,E,F,G.

Is this possible? Can I change the way this hierarchy is defined so that I can pull the possible values for a range?