Forum Discussion

PaisleyPrince's avatar
PaisleyPrince
Icon for Advocate II rankAdvocate II
8 months ago
Solved

Filter two fact tables via the same date table

Hi, I have a single date table which is used to filter a fact table with a project start date and the total fees applicable to that project over a period of years. I now have a new fact table to add...
Need Help
  • Kejmil's avatar
    Kejmil
    8 months ago

    Hi,
    The best approach:
    FactA -> DataTable

    FactB -> DataTable

    Requirements:
    proper key between both tables needed.
    cardinality (many to one (*:1) (date table needs to have unique key)

    Cross-filter direction:
    Single

    Make this relationship active: Yes

     

Kejmil's avatar
Kejmil
Regular Visitor
8 months ago

Hi,
The best approach:
FactA -> DataTable

FactB -> DataTable

Requirements:
proper key between both tables needed.
cardinality (many to one (*:1) (date table needs to have unique key)

Cross-filter direction:
Single

Make this relationship active: Yes