Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Problems with created time values

Hello, everyone, I have a problem. I created a date table as usual and created a relationship with my dates. (Date to Date) When creating a table, the date values from the date table are not display...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    According to your screenshot, I think the month in matrix column field is created by Time intelligence.

    As far as I know, the date hierarchy by Time intelligence in fact table will be destroyed. In your screenshot, we can find this.

    If there is no relationship between "Abfrage1" and "Kalendar", date hierarchy for [DateCreated] works.

    If there is a relationship between two tables, only date hierarchy in dimdate table will work.

    In my side, I can reproduce your issue.

    Here I suggest you to use date hierarchy from dimdate table instand of data table.


    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.