Forum Discussion

SMOYAMI's avatar
SMOYAMI
Frequent Visitor
5 years ago

Relations between date an 2 tables interconnected

Hello there, 

 

I have and issue that is driving me crazy and I am sure I will find the answer in this very spot.

 

I´ll try to explain, I have two databe with various common columns (AP Planes de Acción, APTTareas PLanes de Acción ), I need to relate them with and ID common number, it means APXXXX can have several APTXXXX1, APTXXXX2, and both of the database must be connected with a date table to combine in the visuals

 

I created a dim_APNumber table to interconnect both tables by AP Number, and I tryed to make and independent relationship between Date and Planes de Acción, and date an Tareas de PLanes de Acción, in this las case, i cannot active the realationship so the details of the visual using a common date filter doesn´t work properly.

 

Thank you

 

Relations:

Date - Planes de Acción (AP Date of the event)

Date - Tareas de planes de Acción(AP Date Actual start)

Spoiler
 

 

 

2 Replies