Forum Discussion

erbabu's avatar
erbabu
New Member
8 years ago
Solved

How to: using one column (customer) for multiple date columns in a fact table

Hi   I have the below table.   Customer, DateSold, first-purchasedate-by-customer (calculated column based on DateSold)   I have associated DateSold and first-purchasedate-by-customer to DateDi...
  • erbabu's avatar
    8 years ago

    Update:

    I was able to achieve it by creating a new table with a copy of data from parent table (first-purchasedate-by-customer,Customer) and associating this table first-purchasedate-by-customer to DateDim table & created visualization.