hi all,
I am working on a HR cube for which the details are as below:
--------------------------
HR Cube-
1. History is been maintained in the source data (Peoplesoft HRMS)
2. Data of :
a. Personal Information (Name*, Hiredate, birthdate, address etc)
b. Educational Details (more than 1 record per employee, Graduation, post
graduation)
c. Job Related data (Company*, Grade*, Department* etc)
d. Actions (Hired, Seperated, Promoted, transfered etc)
e. Apraisal Data (Goals set, Rating Obtained etc, Quarterly basis)
3. Requirement :
a. Count based on : Time (Year, Quarter, Month), Company, Actions (Hired,
Seperated etc), Education , Marital Status.

4. Problems:
a. Most of the attributes are changing. name (in case of marriage),
Company(transfer) etc
b. Data is not present but has to be considered.
i.e There will be atleast one record of an employee. (i.e. at the time of
hired) but it can be the only entry in the database if the there is no change
in his/her proifile, still when I show count for any time period till this
employee leaves the organization, s/he should be counted.

--------------------------
I am using MS Analysis Services 2000 and source db is SQL (Peoplesoft).
I am stuck up at the design level and can't come to a good enough design
model. Can you people suggest me a modelling aproach for this. Any
suggestions, links or supporting info would be greatly appreciated.

regards,