Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
Principles and Rules Listing Page

Handle different units of measure in the same fact table

Create separate fields for each different unit of measurement, either by writing the conversion factor or the converted value.
 
This page of 'Principles and Rules' is linked to:  Data Warehousing, Data Analysis/OLAP, BI platform Tools Evaluation, BI business intelligence end-to-end view,

For example, production volumes can be expressed in number of units, number of "production lots/Batches", number of shipment packs..

There are two ways to handle this requirements:

  • Have one field carrying the lowest granular unit of measure (like units of production), and have additional fields to carry the conversion factor between the granular unit of measure and higher units of measure (like 12 when the unit of measure is 'dozens'). As the OLAP gets populated from the data warehouse, the conversion factors can be applied to calculate the measures in different units OR the calculation can be done on the runtime basis.
  • Have one field carrying the lowest granular unit of measure (like units of production), and have additional fields to carry the measures in other units (like 1000 dozens against 12000 units of production).

Quick Feedback- Was this information helpful ?
Relevant Links to this page
Principles & Rules → Data Warehouse application is not limited to Analytics → Principles & Rules → Store as much detailed and granular data in data warehouse as possible → Principles & Rules → Data Normalization is not the best approach in Dimensional modeling → Principles & Rules → Keep the same names and definitions for all data elements → Principles & Rules → You cannot have a super-flexible Data warehouse → Principles & Rules → Dimensional models can be extensible and scalable → Principles & Rules → Data Marts should be ideally based upon a business process and not on a department. → Principles & Rules → Business Intelligence competency groups should be well-linked with business → Practice Techniques → Aggregation Queries on slowly changing Dimensions → Practice Techniques → Documenting your data-integration system → Principles & Rules → For a Data Warehouse/Data-Mart solution, analyze well, but be decisive → Principles & Rules → Maintain a trail of the key dimensional elements from source system to loaded → Principles & Rules → Conformed dimensions are must for cross-drilling → Practice Techniques → Checksum Approach for identifying the changed records from source systems → Principles & Rules → Dimensional model has to be aligned to the Entity-Relationship → Principles & Rules → Always Use Conformed Dimensions → Principles & Rules → You may not be a able to have a perfect ETL → Practice Techniques → Handling Sparse Dimensional tables → Principles & Rules → Do not separate the parent and child line item data → Practice Techniques → Managing time-stamps across multiple time-zones → Practice Techniques → Recording events in multiple currencies → Practice Techniques → Handle different units of measure in the same fact table → Principles & Rules → Handling of Null foreign Keys in fact tables → Principles & Rules → Dimension Attributes as NULL → Principles & Rules → Don't rely too much on Meta Data Tools to enforce Business Intelligence → Principles & Rules → Don't wait for universal models for Data Marting → 
 
Back
 
Relevant links to this page
Data Warehouse application is not limited to Analytics
Store as much detailed and granular data in data warehouse as possible
Data Normalization is not the best approach in Dimensional modeling
Keep the same names and definitions for all data elements
You cannot have a super-flexible Data warehouse
Dimensional models can be extensible and scalable
Data Marts should be ideally based upon a business process and not on a department.
Business Intelligence competency groups should be well-linked with business
Aggregation Queries on slowly changing Dimensions
Documenting your data-integration system
For a Data Warehouse/Data-Mart solution, analyze well, but be decisive
Maintain a trail of the key dimensional elements from source system to loaded
Conformed dimensions are must for cross-drilling
Checksum Approach for identifying the changed records from source systems
Dimensional model has to be aligned to the Entity-Relationship
Always Use Conformed Dimensions
You may not be a able to have a perfect ETL
Handling Sparse Dimensional tables
Do not separate the parent and child line item data
Managing time-stamps across multiple time-zones
Recording events in multiple currencies
Handle different units of measure in the same fact table
Handling of Null foreign Keys in fact tables
Dimension Attributes as NULL
Don't rely too much on Meta Data Tools to enforce Business Intelligence
Don't wait for universal models for Data Marting
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators

Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Behavior
Sales Channel Data Management
Sales Channel SWOT
Sales force density
Sales Cost and Profitability Overview
Read more...
  Customer Relationship Management
Customer Value and Profitability- BI
Customer Segmentation approach
Customer Segmentation Actions
Exit barriers for Customer Retention
Drivers for Customer Satisfaction & Retention
Read more...
  Human Resources & Leadership
Fostering Innovation
Maximize the output first and then the potential
Feedback does not mean only negative feedback
People become the way you treat them
Lead diverse and collaborative teams
Read more...
 
 
Business Performance & Planning
SWOT Assessment Report
Shifting the mind-set to leading Indicators- KPIs
Strategic Planning leadership commitment
Business Objectives Drill Down
Individual goal Sheet
Read more...
  Business Intelligence & Data Quality
time-stamps for multiple time-zones
Data Warehouse Performance Management
Data Warehouse Test Data
Data Warehouse job control and audit
Dimension Attributes as NULL
Read more...
  IT Vendors & Tools Management
Vendor Evaluation Matrix
Scalability Technical Evaluation
Technical Customization Evaluation
Multi Cube OLAP Architecture
Vendor future plans Strategic fit
Read more...