Forum Discussion

BenBlackswan's avatar
BenBlackswan
Icon for Helper V rankHelper V
3 years ago

How to remove a column from Date Hierarchy?

Hello everyone,

After a column has been placed into a Date Hierarchy, how can it be removed from that hierarchy? For example, currently I have the Year and the Quarter column in the Date Hierarchy, but when I right click on the Quarter column, there is no option for me to remove it nor can I drag it out of the Date Hierarchy.

 

 

Any help would be greatly appreciated.

Need Help

2 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    3 years ago

    Hello BenBlackswan ,

     

    you go in the data model view, then click on the hierarchy , then you will see as in the screenshot you could click X to remove it then the apply changes button will be available to click so ou click it and it will be removed.

     

     

  • calerof's avatar
    calerof
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Hi BenBlackswan,

    Use "Delete from model". It'll delete the object in the hierarchy, not the column from the table.

    Cheers,

    Fernando