Modeling two dimensions

View previous topic View next topic Go down

Modeling two dimensions

Post  nverschuren57 on Thu Feb 26, 2015 5:38 am

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

nverschuren57

Posts : 4
Join date : 2015-02-26

View user profile

Back to top Go down

Re: Modeling two dimensions

Post  ngalemmo on Thu Feb 26, 2015 2:23 pm

"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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Modeling two dimensions

Post  nverschuren57 on Mon Mar 02, 2015 12:05 pm

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

nverschuren57

Posts : 4
Join date : 2015-02-26

View user profile

Back to top Go down

Re: Modeling two dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum