Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi all,
i saw a video guide (Guy in a Cube) link below, he guide to reduce size of data by unchecking an option File -> Options and Settings -> Options then under CURRENT FILE -> Data Load under Time Intelligence -> Auto Date/Time done. checked and it works to reduce the data size.
i want to ask about is there any impact on Time Intelligence related queries / views etc. AND
please advise in what situations we can or cannot uncheck this option?
regards
Solved! Go to Solution.
@Anonymous , Once you uncheck all Default Date Hierarchies will go away. You will not [Date].Year or [Date].month etc
You have to use a new column year([Date])
I personally create a date table with all columns I need and add a custom hierarchy as per need .
You should be able to use most of the time intelligence function without date hierarchy. You can use excat columns if needed
@Anonymous , Once you uncheck all Default Date Hierarchies will go away. You will not [Date].Year or [Date].month etc
You have to use a new column year([Date])
I personally create a date table with all columns I need and add a custom hierarchy as per need .
You should be able to use most of the time intelligence function without date hierarchy. You can use excat columns if needed
thanks @amitchandak it means we can un-check this option before loading data to reduce the data size? or i misunderstood ?
regards
ok, then i will un-check that opiton to reduce data size and use new column year([Date]) for most of the requirements.
regards
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |