Data warehouse reporting questions?

The slowly changing dimension should have a natural key that identifies the source of the row (otherwise how would it know what to compare to detect changes). This should be constant amongst all iterations of the dimension. You can get a count of employees by computing a distinct count of the natural key.

The slowly changing dimension should have a natural key that identifies the source of the row (otherwise how would it know what to compare to detect changes). This should be constant amongst all iterations of the dimension. You can get a count of employees by computing a distinct count of the natural key.

Edit: If your transaction table (suggestion) has a date on it, a distinct count of employees grouped by a computed function of the suggestion date (e.g. Datepart (yy, s. SuggestionDate)) and the business unit should do it. You don't need to worry about the date on the employee dimension as the applicable row should join directly to the transaction table.

I do have a natural key on the employee table. The biggest problem is getting a count of employees for a particular business unit for a given time period when querying against the cube. If a schema is required please let me know and I'll post something – bdowden Jun 15 '09 at 16:15.

Add another fact table for number of Employees in each store for each month -- you could use max number for the month. Then average months for the year, use this as "number of employees in a year". Load your new fact table at the end of each month.

The new table would look like: fact table: EmployeeCount KeyEmployeeCount int -- surrogate key KeyDate int -- FK to date dimension, point to last day of a month KeyStore int -- FK to store dimension NumberOfEmployes int -- (max) number of employees for the month in a given store If you need a finer resolution, use "per week" or even "per day". The main idea is to average the NumberOfEmployes measure for a given store over the year.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.