Shalini's Knowledge Share

Following example demonstrates dimensional modelling for the following requirement of an invoicing application

Requirement: A dashboard to display the following:

1. Invoices against delivery method
2. Number of Invoices by month
3. Total dry Items against delivery method
4. Total Chiller Items against delivery method
5. Total Number of Invoices by Sales Person

Following dimensions have to be used for each of the below requirements

• Invoices against delivery method – Delivery Methods
• Number of Invoices by month – Calendar
• Total dry Items against delivery method – Delivery Method
• Total Chiller Items against delivery method – Delivery Method
• Total Number of Invoices by Sales Person – Person

The primary keys of all the above mentioned dimensions will be referred by the fact table and will be made a composite primary key.

Following is the final design diagram of the DB structure.