Forum Discussion
Date hierarchy missing
Anonymous yes it is intended behaviour, in this case you will use date field from date table to work in your visuals.
In my original reply I mentioned if there is relationship on this field, it will not show hierarchy.
Anonymous so this column is used for relationship ?
parry2k Yes, it is connected to the Date Dimension table I have created. Those columns are all Data Type: Dates as well. There is a Many:1 active relationship between the "Exit Date" field in the calculated table (seen above) and the "Date" field in the DimDate table. The "Date" field in the DimDate table does have a hierarchy but not the Exit Date field.
Anonymous yes it is intended behaviour, in this case you will use date field from date table to work in your visuals.
In my original reply I mentioned if there is relationship on this field, it will not show hierarchy.