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

Dimensional Hierarchy

2 posters

Go down

Dimensional Hierarchy Empty Dimensional Hierarchy

Post  kclark Tue Sep 14, 2010 12:53 pm

I have a question about dimensional hierarchies:

If I have a dimension, with attributes,

-Type
--Size
---ID

Could Size be look at as a whole regardless of Type if it falls a level below Type in the hierarcy?

kclark

Posts : 70
Join date : 2010-08-13

Back to top Go down

Dimensional Hierarchy Empty Re: Dimensional Hierarchy

Post  ngalemmo Tue Sep 14, 2010 1:14 pm

Assuming they are simply dimensional attributes, then sure, they can be used independently. Wither you are using relational tables or cubes, there is no reason you could not look at things by size regardless of type.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Dimensional Hierarchy Empty Re: Dimensional Hierarchy

Post  kclark Tue Sep 14, 2010 2:07 pm

In what scenario would this not work? Just so I know I am asking the right question.

kclark

Posts : 70
Join date : 2010-08-13

Back to top Go down

Dimensional Hierarchy Empty Re: Dimensional Hierarchy

Post  ngalemmo Tue Sep 14, 2010 2:17 pm

Offhand, I can't think of one...
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Dimensional Hierarchy Empty Re: Dimensional Hierarchy

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