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

What is the proper way to connect a periodic snapshot table to a date dimension?

2 posters

Go down

What is the proper way to connect a periodic snapshot table to a date dimension? Empty What is the proper way to connect a periodic snapshot table to a date dimension?

Post  falcon00 Fri Jan 10, 2014 4:46 pm

I have a fact table with monthly budget forecast. The "book" says I should connect to the date dimension using the last day of the month. I was thinking that since these are forecast figures I should use the beginning of the period. Or should I take the third option and crate a month dimension and populate it with month and year instead of the standard date dimension?


Last edited by falcon00 on Mon Jan 13, 2014 11:25 am; edited 1 time in total

falcon00

Posts : 17
Join date : 2013-11-07

Back to top Go down

What is the proper way to connect a periodic snapshot table to a date dimension? Empty Re:What is the proper way to connect a periodic snapshot table to a date dimension?

Post  hkandpal Fri Jan 10, 2014 5:29 pm

Hi,

you can use the begining of the month, if that works as the budget forecast is monthly. You dont need to create a sepearte dimension as you can pick up the starting month date from the current dimension.

thanks

hkandpal

Posts : 113
Join date : 2010-08-16

Back to top Go down

Back to top

- Similar topics

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