Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to create data model with limited dimensions but multiple fact tables

I need to create a dashboard using multiple excel files that are coming thru automated workflows. Each file is a fact file but the fields are all different except 3 columns. Each of the 3 columns hav...
Need Help
  • MisterFry's avatar
    MisterFry
    4 years ago

    Hi Poova, 

    You've kinda answered your own question here. 

    You would create one-way relationships between each of the dimensions, and each of the facts, where relevant. Because you're using one-way relationships, you won't run into circular references.

    In the case of many to many relationships, you can still specify a single cross filter direction though the default is 'both'.  

MisterFry's avatar
MisterFry
Icon for Resolver III rankResolver III
4 years ago

Hi Poova, 

You've kinda answered your own question here. 

You would create one-way relationships between each of the dimensions, and each of the facts, where relevant. Because you're using one-way relationships, you won't run into circular references.

In the case of many to many relationships, you can still specify a single cross filter direction though the default is 'both'.