Modeling two dimensions

We have a facttable of employees containing a department key and a function key. The department dimension has a multilevel parent child hierarchy. The function dimension has a single level.

The business requirement is to drill down from the top level department to the its last level and then, within this last level show the functions within this department. This implies using a dimension which is a combination of the department en functionkey.

I assume there is a modeling pattern for this situation?

Regards,

Nico

"This implies using a dimension which is a combination of the department en functionkey. "

No it doesn't. It implies you use both dimensions as referenced from the fact. It is the same as any other multi-dimensional query off a fact table. That is what a star schema is designed to do.

Thanks for your reply.

Ok, so it seems if we use a concatenated key, it is a technical optimization because the query tool does not support the use of the right syntax of the MDX-query.

Regards,

Nico