locked
Cannot make Key value invisible RRS feed

  • Question

  • I have a cube that works perfectly, but i cannot make the key values of my cube dimension invisible.

    AttributHierarchyVisible is set to false both for the dimension and for the cube, but the key value is still shown when i drill down to the bottom in Excel. What is wrong here?

    Regards


    Tore

    Monday, December 5, 2016 9:57 AM

Answers

  • I have a cube that works perfectly, but i cannot make the key values of my cube dimension invisible.

    AttributHierarchyVisible is set to false both for the dimension and for the cube, but the key value is still shown when i drill down to the bottom in Excel. What is wrong here?

    It depends on what you mean by "drill down to the bottom in Excel" - what are you drilling down? If this is a user hierarchy have you included the Key attribute in that hierarchy? If so that is your issue. Hiding the AttributeHierarchy does not have any effect on any user hierarchies you may have created. You need to remove the Key from any user hierarchies where you don't want it seen.

    http://darren.gosbell.com - please mark correct answers

    Monday, December 5, 2016 11:46 AM