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
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
LEGO Island Discussion, modding, news and more!
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
HmongThoobNtiajTeb. com/
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Search
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"






