Skip to Content
author's profile photo Former Member
Former Member

using a range of dates for Key Date

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2009 at 07:44 PM

    Is this possible?

    No.

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

    I wouldn't think so.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thank you Ajay.

      After some thinking, I have realized that these options will not work.

      We have a position-to-position hierarchy that shows who reports to who in the organization. This hierarchy is built on the Infoobject 0HRPOSITION. Each node in this hierarchy has is time-dependent. Note that, the entire hierarchy is not timedependent. Only the individual position nodes are time-dependent.

      This 0HRPOSITION infoobject exists in the Heacount cube as one of the characteristics. Here is my requirement.

      1. I want to show in a report, all the employees (directly or indirectly) reporting to a manager for a period of say, 1 year?

      I know that I can specify a key date for the hierarchy 0HRPOSITION, then the report will show all the employees (direct and indirect) reporting to a position say 6/30/2008. I don't want this for a specific date, I want to get ALL the employees (direct and indirect) reporting to a position in a range of dates( say 1 year)

      Does that make sense? How do we achieve this goal?

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.