problems in query result with infoset and timedep infoobject

[Former Member]

Hi,

I have the following situation:

infoobject ZEMPLOYEE timedep

Infocube 0C0_CCA_C11 (standard cost center/cost element postings)

-> infoset with infoobject and infocube linked with outer join

My query should show all active employees in one month without any posting in the infocube.

My testdata looks like this:

pernr date from date to cost center

4711 01.01.1000 31.12.2002

4711 01.01.2003 31.01.2009 400000

4711 01.02.2009 31.12.9999

That means the employee is only active between 01.01.2003 and 31.01.2009.

I expect the following result in the query with key-date 31.01.2009:

4711 01.01.2003 31.01.2009 400000

I expect the following result in the query with key-date 01.02.2009:

no result

-> because the employee is not active anymore, I don't want to see him in the query.

My query delivers the following result:

4711 01.02.2009 31.12.9999

The first and the last entry in master data is automatically created by the system.

I tried to exclude the not active employees by selection over cost center in the filter (like cost center between 1 and 9999999, or exclude cost center #). But unfortunately the filter selection does not work, because obviously the attributes are not filled in the last entry.

Is there anyone who can tell me how I can exclude the last entry in the master data in the query?

Any help is much appreciated! Points will be assigned!

best regards

Chris

[Former Member]

Lets give it another try

If you can make your query read from only info provider it could work

To change that setting

Select Characteristic-> Advanced tab->Filter Values selection during query execution-> Only values in info provider.

[Former Member]

Hi,

we developed now a new infoobject for the employee status, where we can select the active employees.

Thank's for your support!

regards

Chris

[Former Member]

Think of using other Characteristics from your data model such as

Employee Group= Active

Employment Status= Active

If restriction on Cost cente # is not working think of using conditions in some way to get the desired results.

Let me know if you this doesn't work. Thanks.

~Abhijit

[Former Member]

HI,

problem is that I can't use employe status in this case, beacuse for any reason the people don't use it.

I have also tried with exceptions and conditions, but the attributes ar enot filled, so it seems that nothing works.

Do you have any other suggestions?

Thanks!

best tregards

Chris