Gurus!

[Former Member]

HI all;

In my Headcount report; for some employees who are assigned also for future assignment (future date)under the same cost center, I am getting headcount 2; the future assignment should not come through, how do I restrict the date validation in BW?

Thank you.

[Former Member]

Hi Nitik,

You could do it using a condition over the characteristic you use to identify future assignments..

Could you please elaborate what are the info objects you have which can be used to identify future assignments..

Ashish

[Former Member]

Hey Ashish;

thanks for the reply; We are using Headcount actual as key figure, 0employee, 0costcenter, and etc..this prob rise when the same employee is assigned to same costcenter..for current and future.., we don't want the future data to be extracted in the report. Also could you give me some idea to write the condition also, Pls help me. thank you.

[Former Member]

Hi,

How are you finding whether the same employee is assigned to same costcenter..for current and future.So if you able to seperate data on this base in BW, then you can easily make a condition on this.

With rgds,

Anil Kumar Sharma .P

[former_member188975]

Hi Nitik,

May be I don't get your scenario completely, but as you mention that you do not want future data, can you not restrict / filter the query to the current month, to get the current Employee-CostCenter assignment and Headcount?

[former_member184494]

In restricting to the current month , I am not too sure of there is business content , you might have to write an customer exit variable for the same.

Arun

[Former Member]

Hi,

As Anil has already mentioned..Yu need to tel us how are you determining current and future contracts..

what is the time characteristic you are using.

If we know that we could tell you the exact condition to put in..

Ashish.

[Former Member]

Hello Friends;

Sorry for the delay; I was out of office for some family committment. Just got back, and see this amaizing reply.., as Bhanu mentioned yes we can do this in report level by restricting the Start date that we have in the cube to get the current headcount only. But since we have several report on Headcount we would like to do this on cube level..and thinking about writing a condition on update rules before loading the data into the cube..; I need help to write a logic on this I am not a geek on ABAP, This issues comes when the same employee is assigned for the same cost center twice.

let's say if the 0costcenter is same than load data 'start date (WSTRTDT)'..........

help me here...to complete this.

OR any other options...

Thank you.