Data mashup - multiple fact tables

If your Data Discovery cube contains multiple fact tables, it is strongly advised to introduce common dimension tables as well.

With common dimension tables you can ensure a proper many-to-one fact-to-dimension relation between your tables. Direct relations between fact tables are not recommended as they may be many-to-many relations, and usually will produce errant data.

An example of a cube design with two fact tables and two dimension tables:

Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.