Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Queries multiple fact tables at the same time

2 posters

Go down

Queries multiple fact tables at the same time Empty Queries multiple fact tables at the same time

Post  jpers36 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

Back to top Go down

Queries multiple fact tables at the same time Empty Re: Queries multiple fact tables at the same time

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

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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