Why is this date showing as a hierarchy?

[Chillytouch]

Hi,

I am currently making a new report and I am recycling some data elements from a report that a previous developer worked on. Looking at this custom table "WeekCalendar", the "fiscal_first_day_of_period" (and similar columns) show as basic columns. That is how I want it to be. However when I created the same exact table in a new report, it is showing those same fields as date hierarchys which I do not want. Is there any way to change that? I only know how to change it when you put the field into a visual, but that doesn't change how it shows in the table. Any thoughts as to why this happened/how to change it?

Thank you! 

[Greg_Deckler]

@Chillytouch File | Options and settings | Options and turn off Auto Time Intelligence for GOBAL and Current File.

[OzkanDhont · Accepted solution]

Hi @Chillytouch !

The hierarchy has been auto generated?

You can turn it off in Options and Settings > Data Load > Time Intelligence > Uncheck Auto date/time.

Hope it helped!

Kind regards,

OD

[Chillytouch]

That worked, thanks a ton!!!