Actual Vs Budget Amount in Sales DW

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
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
See also
more_less
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"