Forum Discussion
Date Hierarchy Not Available
In that file's options, under Data Load, is "Auto Date/Time" unchecked? That will disable automatic hierarchies.
You can manually create them by right-clicking on the date, New Heirarchy, then drag in the other pieces you need (day, month, whatever).
I prefer doing that as I don't like the auto-date/time stuff. I want to manually control my date table.
In that file's options, under Data Load, is "Auto Date/Time" unchecked? That will disable automatic hierarchies.
You can manually create them by right-clicking on the date, New Heirarchy, then drag in the other pieces you need (day, month, whatever).
I prefer doing that as I don't like the auto-date/time stuff. I want to manually control my date table.
That's it!
Thank you for the reply and thank you for the alternative it's really better than enabling this Auto Date/Time.