Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Modeling two dimensions

2 posters

Go down

Modeling two dimensions Empty Modeling two dimensions

Post  nverschuren57 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

Back to top Go down

Modeling two dimensions Empty Re: Modeling two dimensions

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Modeling two dimensions Empty Modeling two dimensions

Post  nverschuren57 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

Back to top Go down

Modeling two dimensions Empty Re: Modeling two dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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