i need your help on this case.
A Department dimension was added when the PBCS application was created.. now i am adding an Employee dimension but need to match it with the Department dimension.
i mean, like when added Employee 1 under Employee dimension, the system will know which dept the employee belongs in the Department dimension.
is that possible??
or would be better to just create Employee dimesion with departmental heirarchy?
if that is the case, the Department dimension will not be tagged in the cube where the Employee dimension is.
any insights is greatly appreciated!!!!