Forum Discussion
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...
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'.
Thank you ! Initially i was skeptical about the data model as I was always thinking the model should be star / snowflake type but the model I work is kind of exactly opposite to star model. However, I tried to create dashboard based on your tips above. So far so good 🙂