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

Time bound variables YTD ,QTD as columns or rows.

3 posters

Go down

Time bound variables YTD ,QTD as columns or rows. Empty Time bound variables YTD ,QTD as columns or rows.

Post  ParuD Wed Sep 14, 2011 5:50 am

While working on the Fact measures I am working on the principles that all the measrures which are at the same granualr level was at different columns like the one shown below.

PRODUCT COUNTRY Month Curr Month YTD QTD
P1 C1 Jan-01 30 30 30

But also I have seen fact working in the other way

PRODUCT COUNTRY Month TIMEVIEW
P1 C1 Jan-01 30 CURR MONTH VALUE
P1 C1 Jan-01 30 YTD VALUE
P1 C1 Jan-01 30 QTD VALUE

With the second approach I see the numberof rows being increased.

Can any one tell me which approach is the best where we have to use the each method.


ParuD

Posts : 2
Join date : 2011-09-13

Back to top Go down

Time bound variables YTD ,QTD as columns or rows. Empty Re: Time bound variables YTD ,QTD as columns or rows.

Post  ngalemmo Wed Sep 14, 2011 1:43 pm

If the measures are well defined, then use columns. It makes life simpler for the BI tools.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Time bound variables YTD ,QTD as columns or rows. Empty Re: Time bound variables YTD ,QTD as columns or rows.

Post  hang Wed Sep 14, 2011 7:23 pm

Don't use the second option as it creates confusion and risks double counting the fact.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

Back to top Go down

Time bound variables YTD ,QTD as columns or rows. Empty Re: Time bound variables YTD ,QTD as columns or rows.

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