Queries multiple fact tables at the same time
2 posters
Page 1 of 1
Queries multiple fact tables at the same time
Validating my data model to ensure that existing report designs can be migrated to it, I've come across a report that includes measures at two different levels. Dimension A fully defines the grain of fact table A' and contributed to the grain of fact table P. Measures from fact table A' are presented as attributes of dimension A in a report that is primarily driven by fact table P. What's the proper solution for this -- add the measures from A' to A as attributes, or build the report to pull from multiple fact tables?
jpers36- Posts : 1
Join date : 2015-08-04
Re: Queries multiple fact tables at the same time
You can either query the two facts or build a new aggregate fact if performance is an issue.
You combine facts by summarizing each individually on common dimensions (or dimension attributes) and join the two aggregates.
You combine facts by summarizing each individually on common dimensions (or dimension attributes) and join the two aggregates.
Similar topics
» Multiple time zones for fact tables
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Do I need multiple fact tables or dimensions
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» Multiple Fact Tables vs. Consolidated Fact Table
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Do I need multiple fact tables or dimensions
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» Multiple Fact Tables vs. Consolidated Fact Table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum