Forum Discussion
Relationship issue
Hi Experts,
I am facing an issue while creating a relationship bewteen the tables. Explaining the scenario:- Having 9 different tables in the dashboard.
Table 1 - SEP Server
Table 2 - SCCM Server
Table 3 - AD sys Server
Table 4 - SEP EUC
Table 5 - SCCM EUC
Table 6 - AD sys EUC
Table 7 - CMDB Server
Table 8 - CMDB EUC
Table 9 - Calendar
I have to create a relationship btween below listed tables to write the query.
1) Table1, Table2 & Table 3 should be map under Table 7(CMDB server)
2) Table 4, Table5, & Table 6 should be map under Table 8(CMDB EUC)
3) Table 9 (Calendar) should be map under all the 8 tables
I tried to create a relationship between tables but not able to create a relationship between CMDB tables (Server / EUC) vs calendar table. Getting below message, rest all the relationship are done in the dashboard.
Can any one help me to fix this issue?
PS: The one showing in the below msg is requried to write a query, so
Relationship error
Thanks,
11 Replies
This sounds quite complex, I believe we should start out with an Image of the current relationshipstructure. It would also be preferable if you could sketch up exactly how you are thinking the relationships should work, as it's quite hard to grasp from teh text alone.
Furthermore, information regarding the types of tables (Transactional / Dimensional) will help us determine if it's possible to combine the data at an earlier stage.
Br,
JAlright. You are creating ambiguity as there are more than one filtering path.
When you apply a filter to calendar, there are two paths:
As there is an active relationship between CMB(EUC) and SSM any filter that affects CMB(EUC) automatically filters SSM. This is why the system doesn't like the relationship, when you put a filter on calendar, the system wants to filter SSM twice.
In terms of solution, i would propose you either use the USERELATIONSHIP() fuction to activate an inactive relationship for a specific calculation or append the CMB(EUC) & CMDB(Server) tables and filter directly on their common date column.
In the CMB(EUC) & CMDB(Server) tables, which column a you trying to create the calendar relationship to?
Br,
J
Anonymous , the last error can come if you bidirectional relationship or loops in the relations
