Friday, 31 August 2012

Dimensions and Measures in Datawarehouse

Data warehouse consist of both dimensions and measures.
Dimensions are descriptive details about various objects allowing for their detailed analysis. For example time dimension allows us to see object with respect to year, quarter, month, day and hour. And customer dimensions helps in analyzing the customer who affects the business more.
Measures unlike dimensions give the fact numeric value instead of the detailed analysis.
Different type of measures are listed below:
  • Additive measures are measures that can be added across all dimensions. For example customer count in numbers can be added across all dimensions.
  • Semi-additive measures are measures that can be added across some, but not all dimensions. For example the bank account balance is simply a snapshot in time and cannot be added over time. However you could add multiple accounts of the same customer to get the total balance for that customer.
  • Non-additive measures are measures that cannot be added across any dimensions. For example the procurement is simply a snapshot in time and cannot be summed over time. Also you cannot combine procurement for various items.

3 comments:

  1. Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updatingmicrostrategy online training

    ReplyDelete
  2. business intelligence development
    http://www.aricrypta.com/managed-services/ 

    We specialize in Enterprise and Custom Software Development. We offer Business Intelligence, onshore and offshore App development services to global customers.

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis