Forum Discussion
Problems with created time values
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Amitchandak,
thanks for your support.
So far I have taken everything into account, but I cannot explain one phenomenon.
Every time I create the relationship, my data table is no longer marked as a date data type.
1.
2.
The formats are all created correctly, but the evaluation in a table does not work.
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.