Storing Fiscal Year in a table

View previous topic View next topic Go down

Storing Fiscal Year in a table

Post  jgpage on Mon Jun 11, 2012 5:04 pm

Hi,

We are modelling tax bills and other related data. A question has come up on the topic of how to store the Fiscal Year for the data.

One option is to store the SK from our date tables (the SK representing day 1 of the fiscal year), another is just to store the year (e.g. 2012).

The tables will be access via a BI tool (no expectation that an end user will create a query, so SQL complexity for the user is not a concern).

Any opinions/guidance on these options or other options that should be considered?

Thanks

jgpage

Posts : 2
Join date : 2012-06-04

View user profile

Back to top Go down

Re: Storing Fiscal Year in a table

Post  ngalemmo on Mon Jun 11, 2012 5:20 pm

What is the business rule to determine the fiscal period that something belongs? Is it billing date, due date, or some other date?

Either way, fiscal period should be an attribute of the date dimension and you use whichever date role in the fact data that complies with the rule. You usually do not have fiscal period as its own dimension.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Storing Fiscal Year in a table

Post  jgpage on Mon Jun 11, 2012 5:55 pm

The fiscal year starts on 7/1, so the SK would be 20120701 for all rows in FY 2012.

Thanks for the input.

jgpage

Posts : 2
Join date : 2012-06-04

View user profile

Back to top Go down

Re: Storing Fiscal Year in a table

Post  Jeff Smith on Mon Jun 11, 2012 10:57 pm

Why wouldn't you have a field in the date dimension called Fiscal Year? For dates from 7/1/2012 to 6/30/2013, the Fiscal Year would be 2012. For dates from 7/1/2011 to 6/30/2011, the fiscal year would be 2011. You could also have Fiscal Year Quarters.

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Storing Fiscal Year in a table

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