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

[Former Member]

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.

[KodandaPani_KV · Accepted solution]

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.

[Former Member · Accepted solution]

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?