Understanding Fact (Measure) Modeling
One key and core part of your BI solution is the business facts that you choose to include. As mentioned previously, facts are also called measures. Measures are the key metrics by which you ascertain the success of your business. Some examples include daily sales amount, product sales quantity, net profit, and so on. Clearly selecting the appropriate facts is a critical consideration in your model.
An Example
If you have been thorough in the business requirements gathering phase of your BI project, modeling facts should be simple. In most cases, facts are numeric and are aggregated by summing the facts across all levels of all dimensions. There are, however, exceptions to this rule. An example of the most ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.