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:
Comments
Please sign in to leave a comment.