Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date table - Relationship NOT Working

Hi all,   I am trying to create a relation to a Date Table and use Time intelligence functions, but it looks like there is some issue with the relationship.   I have looked into many similiar iss...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    One of the following

    1. date calendar does not have all the dates

    2. The transaction table date has time but shown in the date format. So change the format and to date with time and check. It  has time to create a new date column date = table[datetime].date

     

amitchandak's avatar
amitchandak
Super User
6 years ago

One of the following

1. date calendar does not have all the dates

2. The transaction table date has time but shown in the date format. So change the format and to date with time and check. It  has time to create a new date column date = table[datetime].date

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks. I have looked in the calendar, but at the end it was missing values for 2020. How I didn't see that...

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, 

     

    I am facing similar issues.  I have created a separte date table using calendar auto function and marked the date column in the date table as the date table.  The fact table has multiple date columns with time stamp.  I have changed the date columns in the fact table to date only format and connected it with the date table.  Even then the relationship didnt work.  I also tried modifying the date column in the date table to date/time even then i am facing the similar issues of getting the matrix as mentioned in the post above.  Can you please suggest what you meant when you referred to new date column date = table[datetime].date.  I also checked whether all the dates are there in the date table.  Even the dates are there since its created using calendar auto function.

     

    Any other suggestion would help.

     

    Thanks & Regards,

     

    Padmaja 

    Thanks