Time dependent masterdata in Query /different key Dates in one query ?
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 ?