Queries multiple fact tables at the same time

View previous topic View next topic Go down

Queries multiple fact tables at the same time

Post  jpers36 on Tue Aug 04, 2015 11:17 am

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

View user profile

Back to top Go down

Re: Queries multiple fact tables at the same time

Post  ngalemmo on Tue Aug 04, 2015 11:53 am

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum