Hi All,
This article Covers the Modelling of Employee dimension. Though the task looks simple it took me quite some time to think over it. Ralph kimball has mentioned 5 good design tips you can go through it. I have found one implementation done by IBM on its sample that comes with Cognos. So discussing the implementation here
Though Fixed depth hierarchies have issues when we are implementing type 2 as entire dimension needs to be end dated when CEO gets changed. But considering we are implementing type 1 the idea of keeping this information in separate columns in best.
It has further disadvantage of not being able to filter directly on employee name. You need to find first find the designation that is whether the employee is manger 1 , manager 2 and then you can filter on it.
We will now look at how to do the Basic ETL logic to populate this Employee table from source table to get the required structure
The other point to be considered is how do we implement security in such a way that when a user logs in he should be able to see only his subordinate expense but not the expense of others this has to be implemeted in Cognos
This article Covers the Modelling of Employee dimension. Though the task looks simple it took me quite some time to think over it. Ralph kimball has mentioned 5 good design tips you can go through it. I have found one implementation done by IBM on its sample that comes with Cognos. So discussing the implementation here
Though Fixed depth hierarchies have issues when we are implementing type 2 as entire dimension needs to be end dated when CEO gets changed. But considering we are implementing type 1 the idea of keeping this information in separate columns in best.
It has further disadvantage of not being able to filter directly on employee name. You need to find first find the designation that is whether the employee is manger 1 , manager 2 and then you can filter on it.
We will now look at how to do the Basic ETL logic to populate this Employee table from source table to get the required structure
The other point to be considered is how do we implement security in such a way that when a user logs in he should be able to see only his subordinate expense but not the expense of others this has to be implemeted in Cognos
No comments:
Post a Comment