Forum Discussion
Creating Date Tables
As of today (10/26/18), what's the most convenient way to create date tables in BI? Apparently there used to be a feature whereby one only had to click a single button to drop a date table into the m...
I have done this precisely as described above, but when I mark it as date table in the main report I am no longer able to create a Date hierarchy. What am I doing wrong?
edhans
Community Champion
Community Championright-click on a date field and select Create Hierarchy, then right-click on a second date field and add to that hierarchy, and so on.
Ah right, ok.
But why does making a Field the date table remove the date hierarchy?
- edhans
Shouldn't. Turning off "Automatic Date/Time Intelligence" does turn off the automatic hierarchy, and that is a good thing. You do NOT want a date hierarchy (which is a hidden date table) for every date field in your model. Build your own hierarchies as needed - which don't create hidden tables.