Forum Discussion
How to remove Date Hierarchy
Hi Anonymous
Go to File --> Options and Settings --> Options --> Current File -> Data Load
and turn off 'Auto Date/Time' (under Time Intelligence)
Sorry wrong advise.... actually when you drag it into values, you can right click and select the date name instead of the Date Hierarchy - then it will display as a single date.
If you turn the auto date stuff off.. you would then have to have your own date tables.
Community ChampionHi Anonymous
Go to File --> Options and Settings --> Options --> Current File -> Data Load
and turn off 'Auto Date/Time' (under Time Intelligence)
Disabling time intelligence disables ALL hierarchies in the file. If you need to keep some of them and get rid of one right click on the field (Visualizations/Columns), check it and uncheck "Data Hierarchy".
