wrong data - table connection

[Anonymous]

hi,

I have the tables model below, but when I create a report with data from 3 tables, it cuts the connection and give me wrong data (blank), whats wrong here?

the first connection is well, the view with 2 tables :

the problem when i connect the last one, factcyclestatus.

[Anonymous]

Hi @Anonymous 

This should be caused by your data model and relationship. Due to I don't know your data model, I build a sample to have a test. My sample works well.

tagging_team:

dimCycleDate:

factCycleStatus:

Result is as below.

Could you tell me where are site_id and Team column from? Are they from tagging_team table? The relationship between it and dimCycleDate table is one to many. It seems that won't cause this issue. Could you share a sample file which reproduced the issue with me? This may make it easier for me to understand your data model.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Buy maybe try to do it with many site.id and many teams...

[Anonymous]

Hi @Anonymous 

Can you share a sample with me? You can create a sample without sensitive data , this will make it easier for me to understand your issue.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi. Thanks for your reply. The team column is from tagging_team table. 

I have added all the tables data in the first picture. In your example you got good result. I dont know what the problem with my data.