on 08-03-2005 11:51 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.