Hide empty cell in cube RRS feed

  • Question

  • I just created a cube with 12 hierarchy. After 3rd hierarchy, some hierarchies are blank and it does not have fact values as well. I open the cube in excel, so once drill down after 3rd hierarchy, lots of blank cells are coming with (+) sign, so even drilling further down there no values. How can I set up that if hierarchy is blank, don't show in pivot table ? Or is there a way to hide it in cube browser in SSAS ?

    Thank you.

    Thursday, November 1, 2018 7:14 PM


  • Hi gurudevam,

    You can try to hide the specific level of hierarchy in pivot table.

    Hiding certain levels when using a hierarchy


    Pirlo Zhang 

    MSDN Community Support<br/> Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href=""></a>.

    • Proposed as answer by Pirlo Zhang Tuesday, November 6, 2018 2:22 PM
    • Marked as answer by gurudevam Thursday, June 6, 2019 3:47 PM
    Tuesday, November 6, 2018 2:22 PM

All replies