General ledger and budgets

View previous topic View next topic Go down

General ledger and budgets

Post  nverschuren57 on Fri Oct 16, 2015 8:40 am

Hi,

As adviced I have a date dimension which has a day as a key i.e. '20151016'. The point is I have different types of financial fact tables. The budget table has a granularity of a month. As this is no the primary key of the date dimension, how should it be attached?

The incurred cost in the ledger has a primary keys based on a key base on the month it is to be booked in the subledger and a document number. So its key is the subledger and the document number. So the same question for this table. How to connect it to the date dimension?

Regards,

Nico Verschuren

nverschuren57

Posts : 4
Join date : 2015-02-26

View user profile

Back to top Go down

Re: General ledger and budgets

Post  ngalemmo on Fri Oct 16, 2015 2:05 pm

Are you taking about a month (Gregorian) or a fiscal period?

Irrespective of that, it is generally better if you have a dimension for it. However it can also be done by using a specific date (first day of month, last day or month, 15th of the month) that represents the month and always use that date to locate the date dimension key. The problem with it is the model lacks clarity. You can resolve some ambiguity by using a different name for the FK in facts at a monthly grain (such as month_key (or fiscal_period_key) instead of date_key).

avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: General ledger and budgets

Post  nverschuren57 on Sun Oct 18, 2015 4:05 am

Thanks for your reply. I am working with a Georgian Calendar.

Maybe it is an idea to model the month as a shrunken dimension?

Regards,

Nico

nverschuren57

Posts : 4
Join date : 2015-02-26

View user profile

Back to top Go down

Re: General ledger and budgets

Post  ngalemmo on Mon Oct 19, 2015 3:14 pm

Yes. Having a month dimension improves clarity in the model.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: General ledger and budgets

Post  zoom on Mon Oct 19, 2015 3:33 pm

You can create flags in your date dimension to represent "Month" for specific group if their definition of "month different from each other. For example if accounting month starts on 5th of every month then create a column in your date dimension accounting_month_date_ind and set its value as 'Y' and rest of the dates have value 'N'.

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

View user profile

Back to top Go down

Re: General ledger and budgets

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