Forum Discussion
Date hierarchy missing
Hey community! Date hierarchy isn't showing for my Exit Date field. It is tied to a Date dimension as Many:1 single direction active relationship and it's the correct data type "Date" but the ...
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 can you check if under option you have turned of "Auto Date/Time", also the field on whcih you have relatonship it will not show hierarchy for that even "Auto Date/Time" is on.
parry2k I did have "Auto Date/Time" checked under Options. I have unchecked it, and nothing has changed.
Anonymous it need to be checked in case you want date hierarchy. Can you make sure your column data type is date?