aseem.sb at 07h55
28
Oct
2010
Actual Vs Budget Amount in Sales DW
Hello All,
I have DW for Sales. Currency the design is as follow:
Dim Tables:
1. DimCustomer
2. DimProduct
3. DimDate
Fact Table:
1. FactSales - Sales QTY Sales Amout etc. The granularity of this table is per product, per customer, per order and per day.
I have new requirement that, I need to incorporate Budgeted and Forecast sales in DW.
Curre
Hello All,
I have DW for Sales. Currency the design is as follow:
Dim Tables:
1. DimCustomer
2. DimProduct
3. DimDate
Fact Table:
1. FactSales - Sales QTY Sales Amout etc. The granularity of this table is per product, per customer, per order and per day.
I have new requirement that, I need to incorporate Budgeted and Forecast sales in DW.
Curre
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1842
- Numbers of messages : 8656
- Numbers of users : 3787
- Numbers of points : 1497
Similar topics
I am adding forecasting to an existing sales DW:
Existing Dimensions:
Dim Date (typical date dimension attributes)
Dim Customer (customer #, forecasting group, sales territory )
Dim Product (SKU, description, various product attributes)
Existing
I am having trouble with designing the date dimension for a financial data fact table.
We have two different planning approaches. An annual plan, which consists of months, and a strategic plan, which consists of the next five years. The problem is that
Consider a sales invoice line table in the source ERP system that includes these three currency fields:
ExtendedListPrice
ExtendedDiscount
ExtendedSalesAmount
(In this example ExtendedSalesAmount = ExtendedListPrice ExtendedDiscount.)
In the
I have recently watched a couple films made on a very small budget El Mariachi $7,000 and Pharoahs Army not as small a budget but it was still made for $500,000 which is far less than the cost to produce most films, both films were great. With so many
Ituloy ang Ligaya!
Forums from same category
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
LEGO Island Discussion, modding, news and more!
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
HmongThoobNtiajTeb. com/
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Search
Informations
5 Replies For the topic :
"Actual Vs Budget Amount in Sales DW"
This topic has been viewed 2409 times.
Last message :
28/10/2010 at 07h55 by "aseem.sb"






