Forum Discussion
Fundamental Data Model Relationship Question
Hello,
I've created a data model with a Fact table and Dim table. I've also create a relationship(1:M) from the Dim to the Fact table. Now, when a start creating a Table Visual for my "spot-checking" needs and bring in the Key fields from both tables that I created my relationship based on, the amount of records are inflated. I would think I would only see records in the Table Visual where the Key fields match between the Fact table and Dim table but it seems as if a cross-join of some sort is happening behind the scenes but I think I'm missing something fundamental here in my understanding.
As you can see the screenshot, the 2nd Key field(From Dim table) is being replicated when the 1st Key field(From Fact table) in the screenshot is unique as I build out my Table Visual. I'm expecting to see only records where the two Key fields match. However, it seems like all records from the Dim Table will "cross join" to each record in the Fact table based on the relationship created between the tables. The Key field from the Dim table is unique and I created a 1:M relationship to the Fact table.
Any explanation would be helpful.
- This measure ignores (ALLEXCEPT) the relation and creates foreach combination a result.
13 Replies
- mwegenerMost Valuable Professional
Hi Anonymous ,
could you post a screenshot of your data model view?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
- AnonymousNot applicable
mwegener , Anonymous
Here is the data model screenshot. I'll also add that there will be some cases that there's no Key field value from the Dim table that matches the Key field value in the Fact table. All the Key field values from the Dim table will find a matching Key field value in the Fact table, just not the other way around.
- mwegenerMost Valuable ProfessionalIs there any Measure in your Table Visual?
- AnonymousNot applicable
HI Anonymous ,
It seems like table records not fully matched, right? If this is a case, I'd like to suggest you create a calculated table that extracts two table key fields, then you can sue it as bridge to link two tables.
BTW, I'm not so clear for your data structure, can you please share some sample data to help us clarify your scenario and test?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng