locked
SSAS Tabular Hide all key columns at dimension tables from user interfaces RRS feed

  • Question

  • I want to hide all Key columns so that users will not see them as they browse data with excel. I hope I can do this in one click or so for all dimension columns since I keep rebuilding the full project from scratch few times a week still.

    Ho can I accomplish this?

    Thank you

    Gokhan Varol


    • Edited by GV1973 Saturday, July 23, 2016 3:03 PM
    Tuesday, August 6, 2013 3:33 PM

Answers

  • not possible.  you can multi-select the columns you want to hide from the model diagram view, but there is no single "click this button to hide all key columns".

    BI Developer and lover of data (Blog | Twitter)

    • Proposed as answer by Darren GosbellMVP Wednesday, August 7, 2013 3:26 AM
    • Marked as answer by Elvis Long Thursday, August 15, 2013 1:13 AM
    Tuesday, August 6, 2013 4:45 PM

All replies

  • not possible.  you can multi-select the columns you want to hide from the model diagram view, but there is no single "click this button to hide all key columns".

    BI Developer and lover of data (Blog | Twitter)

    • Proposed as answer by Darren GosbellMVP Wednesday, August 7, 2013 3:26 AM
    • Marked as answer by Elvis Long Thursday, August 15, 2013 1:13 AM
    Tuesday, August 6, 2013 4:45 PM
  • With the project open cube, enter the dimension settings, click the right button on the attribute name and Advanced, change to false in AttributeHierarchyVisible option.
    Friday, January 30, 2015 6:59 PM