Hi OLAP gurus,

I try to imlement OLAP in my HR applications.
The customer request :
show me the number of employees per department, district, region , by
master degree and non-master degree, age, etc
* for the corrent month compared to for last year ...
etc.. etc
So here what I analyze is : 'how many employees' that meet this.. and that..
conditions..

The question is :
What should I put on Fact Table as measures ?
(so far I see the aggregate functions that will be done is COUNT)

Thanks for your help,
Krist

The number of employees is your measure; department,
district, region and degree level would be your
dimensions, in this instance. You could aggregate by
COUNTing a employee identifier, but you might be better
off by specifying an Employee Count field in your
underlying fact table, setting it as 1 for each employee,
and SUMing them.

HTH

Phil