Time bound variables YTD ,QTD as columns or rows.

View previous topic View next topic Go down

Time bound variables YTD ,QTD as columns or rows.

Post  ParuD on 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

View user profile

Back to top Go down

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

Post  ngalemmo on Wed Sep 14, 2011 1:43 pm

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

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

View user profile http://aginity.com

Back to top Go down

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

Post  hang on 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

View user profile

Back to top Go down

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

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