When we are doing the analysis on Employee head count, Data is not clear.
Detail :
All the data is coming from one particular Head count cube. and 4 reports are existing on that.
When we are executing Attrition on Monthly wise report, Data is Correct as per the cube and the records as well, but When we are running Attrition report on YTD, data is mismatching.
For Example, Consider from April 2011
One Employee has worked for 4 months in GRADE E and has been promoted to GRADE D on 1st Aug,2011 and now he is working under Grade D from the past 4 months.
When we run this Attrition Report on this day giving variable month as NOV,2011..... It is showing ATTRITION VALUE as 7 under GRADE D and NO Value in GRADE E. (Actual Output :: ATTRITION VALUE Grade E : 4 and GRADE D : 3)
CAN any one help me on this Issue?
Thanks in Advance.