Hi All,
What I'm trying to do is to link my EmployeeDetails Dimension Birth Date field to my Time Dimension Primary Key field. It links successfull in the Datasourceview but what I want is when you drag on Year field from the Time Dimension and the Birth Date field from my EmployeeDetails Dimension, it should look like this in the Cube:
| Year |
Birth Date |
| 2002 |
2002/02/01 |
|
2002/08/25 |
|
2002/12/31 |
| 2003 |
2003/04/06 |
Currently whats happenning is the following(All Birth Date's repeats under all Years):
| Year |
Birth Date |
| 2002 |
2002/02/01 |
|
2004/08/25 |
|
2008/12/31 |
| 2003 |
2002/02/01 |
|
2004/08/25 |
|
2008/12/31 |
I have not started with my Fact tables yet. Will that make a difference? Currectly I only have a Time Dimension and an EmployeeDetails Dimension.
I'm I doing something wrong?
Any response will be most appreciated.
Should there be any questions, please do not hesitate to ask.
Thank you,
Joos