This page has been automatically translate with Google from the Italian language.

PLANNING OF THE DATAWAREHOUSE FOR THE VIRTUAL WAREHOUSE

CONCEPTUAL PLANNING

The conceptual planning involves uses it of requirement customer captured during the previous phase in order to design the conceptual outline of the Datamart.
The adopted model is the Dimensional Fact Model, that outline of fact for every fact of interest characterized from the customer previews the creation of one.
A fact outline is in a position to graphically describing all the concepts of the multidimensional model: facts, measures, dimensions and hierarchies.
The first fact in analysis is "Supplyes".



Figure. Outline of fact for the supplyes
Three dimensions exist, ognuna with three various hierarchies:
  1. product, with three distributions; that more important is the deepening of the type of the product that allows to confront produced that they have uses, similar dimensions, shapes.
  2. date, with depth of period.
  3. warehouse, that it allows to identify the position of the warehouse in various dimensions.
Then one is passes to analyze to the fact "Purchases subsequently to you" and requirement of the supplies, through the fact "Deliveries".


Figure. Outline of fact for the purchases
Its Possible to make one demanded of the acquired amount and the paid amount for it:
  • in one particular week
  • in one particular zone of demand
  • in one particular zone of destination
  • for one particular family of products
  • with one particular type of confection
  • and a particular one marks


Figure. Outline of fact for the deliveries

 


Top | Summary | < < Previous | Next > >
>> Home Page newsletter.unitec.it <<