Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

Date - Data type

Hi Everyone,   My Date Created field/option is not showing the hierarchy calendar, the data type is set to Date but its still not showing for me to get the Year, Month, Day options.  Can someone pl...
Need Help
  • sraj's avatar
    sraj
    5 years ago

    Found the issue, I had my data connectivity mode to "DirectQuery" once I changed it to "Import" I was able to see the calendar and the date hierarchy.  This is strange that it doesnt work for both the modes, anyways I am glad I tried this.  Thank you!!

negi007's avatar
negi007
Icon for Community Champion rankCommunity Champion
5 years ago

sraj Please ensure that you have time intelligence options enabled in data load option

 

 

  • sraj's avatar
    sraj
    Icon for Responsive Resident rankResponsive Resident
    5 years ago

    Yes, that option is enabled too.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello sraj ,

       

      Sometimes it won't create date hierarchy. probably you can create column for year, month, querter, day and create new hierarchy.

      • sraj's avatar
        sraj
        Icon for Responsive Resident rankResponsive Resident
        5 years ago

        Found the issue, I had my data connectivity mode to "DirectQuery" once I changed it to "Import" I was able to see the calendar and the date hierarchy.  This is strange that it doesnt work for both the modes, anyways I am glad I tried this.  Thank you!!