Skip to Content
avatar image
Former Member

Time dependent masterdata in Query /different key Dates in one query ?

Hello experts,

i have a report requirement.

Report must show all employees, who begann in last 5 years to work, their starting salaries and their first department in the Company.

EMPLOYEE is time-dependent Infoobject.

DEPARTMANT is time.dependent attribute of Infoobject EMPLOYEE.

STARTING DATE is an attribute of Infoobject EMPLOYEE

Salaries are in an Infocube.

In Query Designer, i can select only one "Key date"

But i Need for each employee a different Key-Date (STARTING DATE)

How is it possible ? Do you have any other ideas ?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 17, 2015 at 03:16 AM

    HI,

    you want total employers for the last 5 years? if yes

    please fallow th below steps.

    create the one customer exit varible pick the values form the last 5 years.

    keep the employee  in the rows panel remaining put it into free char panel.

    In Query Designer, i can select only one "Key date"

    But i Need for each employee a different Key-Date (STARTING DATE)

    in query designer put the STARTING DATE in free char - if you drag to rows panle you will get stating date of employee.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Phani,

      thanks, i have a customer exit variable for last 5 years.

      According to STARTING DATE for each employee, Report should Show their beginning salaries.

      If i give a key date for query, then that Shows only the salaries on that day.

      If i dont put any date on query -key date then that shows all current salaries.

      But what i need is, beginning salaries for each of them.

      Do you have any other ideas?