Having a misunderstanding with the LDM. I'm gettin...
# gd-beginners
d
Having a misunderstanding with the LDM. I'm getting a lot of warnings and I don't know hwy. What I'm doing: I have changed one our tables from having one join criteria SIDD Login ins Cases User_id User_id to having a second join criteria SIDD Login ins Cases User_id User_id day date However I'm getting 83 warning messages. I'm not sure why though, some of these metrics don't even use the Logins or Cases table For example, one that gives me a warning is in the call_topic table
Copy code
SELECT IFNULL(
  (SELECT COUNT({dataset/call_topic})
WHERE {label/feedback} = "Thumbs Down"
and {fact/feedback_shown} = 1)
,
0)
m
Hi Doug, these errors are related to how the Logical Data Model (LDM) is affected by the changes you made in your joins. When you modify the relationships between tables, especially adding additional join criteria, it can have a ripple effect on how queries and metrics are processed, even if they don’t directly use the tables you modified. By adding a second join criteria between
SIDD Login
and
Cases
, you have introduced a more complex join, which is impacting other parts of the LDM. Even if some metrics (like the one in your
call_topic
table) don’t directly reference
Logins
or
Cases
, it might still check the integrity of the entire model, especially when those tables are used in the underlying LDM. You can learn more about this topic here: https://www.gooddata.com/docs/cloud/model-data/evolve-your-model/monitor-model-changes/