Multiple fiscal calendars

rcman at 18h36
16
Jul
2010
Multiple fiscal calendars

We are an aggregator. We sell and ship our own products and act as distributors for a number of other entities. We would like to give our distributees access to our internal BI reports dealing with invoicing and shipping. They each have the potential to have different fiscal calendars and we would like them to be able to run the same reports against our fiscal calendar or against theirs. We need to be able to add new distributees constantly. What is a reason
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Hi, We have an interesting challenge with our Date dimension. We need to carry multiple calendars - one per country, and one for the Group. When loading the FACT, we create a record per invoice for the country and a record for the group calendars. Thi
Hi everyone, I have a couple of questions regarding fiscal dates and snapshot dates/data: 1. How would someone model a "fiscal" dim when a date maps to two fiscal months? e.g. Fiscal Year 2010 Fiscal Month 12 Fiscal Month Date
We have a need to compare monthly transaction amounts that are associated with 15 month fiscal years. A fiscal year 2009-10 would span July 2009 thru September 2010. But there can be transaction amounts in fiscal year 2010-11 associated with calendar
CBI: Fiscal Policy Will Control Monetary Policy has Been Activated in Case the Federal Court Decision 07/02/2011 17:45 Baghdad, February 7 (Rn) - The Central Bank of Iraq on Monday that fiscal policy will impose its control over monetary policy
I am trying to put together the bus matrix (to identify the facts tables) for a government correctional agency and am debating between multiple facts for each event in the life cycle of an offender vs. fewer fact tables. I wanted to avoid joining multiple
Forums from same category
See also
more_less
Informations

4 Replies For the topic :
"Multiple fiscal calendars"

This topic has been viewed 1713 times.

Last message :
16/07/2010 at 18h36 by "rcman"