Forum Discussion

rkoehler's avatar
rkoehler
New Member
7 years ago

Add Date as Hirarchie

I've added some Tables from MS Sql Server.
In one Table is a Date Time Field


now i'm missing the hirachical Structure with Quarter Year Month

like here, i've done before from an Excel Sheet

 

any hints?

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    The automatic calendar hierarchy may have been switched off.

     

    Try:
    Click the File tab, click Options and Settings to open the Options dialog box
    Choose the Data Load page
    Select the Auto Date/Time check box.

    • rkoehler's avatar
      rkoehler
      New Member
      7 years ago

      is checked,

      also show Date as Hierachie or similar (i've a german interface)

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi rkoehler,

         

        Please check if the data type of [Date_Time] field loaded from Sql Server is set to Date/Time under Modeling tab. If it is Text, it won't show this column as Hierarchy.

         

        Regards,

        Yuliana Gu