Building Making It Happen
Building Making It Happen
  Sign-in         Register
    
Principles and Rules Listing Page
Conformed dimensions are must for cross-drilling
If you want to have a good cross-drilling capability, its important to have conformed dimensions across multiple fact tables.
 
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,


The cross-drilling basically means that you can navigate across multiple fact tables. In other words, it's a join across two fact tables. This is possible only if you have absolutely same dimensions. This is the same principle when you are creating a join across two tables in a transactional system. The only difference is that even if the transactional tables have fields with a different name, the joins can be made as long as the data structure and format is same. In transactional system, the specific queries are made against specific transactions. It is not much different in a dimensional model and multi-dimensional (OLAP ) storage. However the scenarios of joins could be unlimited in a Data Warehouse. Given that dimensional model could be exposed to planned and unplanned queries, the non-conformed dimensions would not be able to handle unplanned query. Also for planned queries as well, we will have to do a manual intervention.

You can refer query across cubes to get some more perspective. It is always preferred to have automated joins across multiple fact tables.

   Access more details on this page   

Quick Feedback- Was this information helpful ?
Relevant Links to this page
TOPIC - Dimensional Modeling vs. Relational Modeling → Slowly Changing Dimensions SCD in Dimensional Modeling → Practice Tools → Dimensional Model Completion Checklist → 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 → Principles & Rules → Add extra buffer for ETL phase → Principles & Rules → Homework before interviews is must (Business Requirements Phase in Data Warehouse) → Principles & Rules → Excel is the competition, which should be challenged → Principles & Rules → Avoid Pure MOLAP → Practice Techniques → Field Tips Series- Streamlining & Cost-Reduction in Business Intelligence- Consolidate Data-Marts → Practice Techniques → Field Tips Series- Streamlining & Cost-Reduction in Business Intelligence- Licensing & Maintenance Contracts → Practice Techniques → Field Tips Series- Streamlining & Cost-Reduction in Business Intelligence- Governance & Standards → Practice Techniques → Field Tips Series- Streamlining & reducing cost of Business Intelligence- Evaluate Open Source → Principles & Rules → Master Data Management- Making a Right Start → Practice Techniques → How to integrate stand-alone BI environments- Gradual Approach → Principles & Rules → Business owned applications are a reality- Manage it → Principles & Rules → New Data Standards- What about existing data and applications? → Principles & Rules → Handle Each Time-stamp in the Fact Table as a separate dimension → Principles & Rules → Keep Aggregates and Details data in different Fact tables → Principles & Rules → Some considerations for Infrastructure in Data Warehouse → Principles & Rules → For Core BI platform go for a single, established and robust player → Principles & Rules → Don't be guided only by the business requirements for your Business Intelligence → Practice Techniques → Using Synonyms and Views → 
 
Back
Featured Pages
Data Warehouse Requirements Assessment
Data Warehouse Source Systems
Sponsor for a Data Quality Program
System Quality Assessment Tool

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
Internal capabilities for BI modeling and analysis
Dimensional Model- Dimension listing
Data Mart + Dimensions +facts
What is KDD- Data Mining?