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

Is "Month" leve mandatory for a Time Dimension?

4 posters

Go down

Is "Month" leve mandatory for a Time Dimension? Empty Is "Month" leve mandatory for a Time Dimension?

Post  sapisfun Wed Feb 06, 2013 2:53 pm

One of my colleagues suggested to have only "Year" and "Day" level for a Time Dimension to improve the cube performance for one of our projects. His idea is that if the customer wants a Month level, he/she can query from the underlying data mart directly. I don't agree with it. Please advise whether a "Month" level could be omitted in a Time Dimension.

sapisfun

Posts : 1
Join date : 2013-02-06

Back to top Go down

Is "Month" leve mandatory for a Time Dimension? Empty Re: Is "Month" leve mandatory for a Time Dimension?

Post  ngalemmo Wed Feb 06, 2013 3:28 pm

You could drop anything you want. Question is, does it make sense?
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Is "Month" leve mandatory for a Time Dimension? Empty Re: Is "Month" leve mandatory for a Time Dimension?

Post  BoxesAndLines Wed Feb 06, 2013 8:01 pm

How does that improve performance? There are just as many rows in the dimension.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Is "Month" leve mandatory for a Time Dimension? Empty Re: Is "Month" leve mandatory for a Time Dimension?

Post  thedude Thu Feb 07, 2013 5:44 am

It is unlikely to make any difference to performance and having to go to two different places (cube and mart) for similar queries doesn't make sense (or a great user experience)

thedude

Posts : 21
Join date : 2009-02-03
Location : London

Back to top Go down

Is "Month" leve mandatory for a Time Dimension? Empty Re: Is "Month" leve mandatory for a Time Dimension?

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