Skip to main content
GruppiStudent Resource PageDomanda di Tableau Community Forums Member (Inactive)
Tableau Community Forums Member (Inactive) (Salesforce) ha fatto una domanda in Student Resource Page
19 dic 2023, 20:43

My question is how can i have multiple relations fact tables with multiple relations dimension tables

I have a large dataset and i want to relation it. My example is:

 

I want to relate table "13TipoHidrocarburo" with tables "VolumenCNH", "VolumenContratista" and "VolumenFMP" but at the same time this tables has relations with "DatosContratosPC_FMP...." one (the root table). I can´t complete my relation. I attach my example.

 

Thank you so much,

Abimael Aguilar

Captura de pantalla 2023-12-19 143815.png
3 risposte
  1. Steve Wood (RealNZ)
    20 dic 2023, 08:33

    Hi @Abimael Aguilar​ 

    If I've undertstood what you want to do:

    Hi @Abimael Aguilar​ If I've undertstood what you want to do:Unfortunately this isn't possible with (just) relationships at the moment - though it is coming in a future release I believe.Unfortunately this isn't possible with (just) relationships at the moment - though it is coming in a future release I believe.

    However you could get around this in different ways.

    (1) If you have access to the underlying database you could create a view onto TABLE D for each time you want to relate it to the other tables.

    (2) You could double click into the physical join layer for the tables you want to join onto TABLE D, and join onto TABLE D using a physical join.

    https://help.tableau.com/current/pro/desktop/en-us/datasource_datamodel.htm

    Ta, Steve.

Scrivi una risposta...
0/9000