Skip to main content

    BI in SQL vNext

    New

    Support ragged hierarchies in Tabular through HideMemberIf equivalent

    Vote (58) Share
    Greg Galloway's profile image

    Greg Galloway on 20 Apr 2015 11:16:38

    Currently if you have a ragged hierarchy you will see blank branches/leaves in your hierarchy in your Tabular model. BIDS Helper allows you to set HideMemberIf, but since the SSAS server for Tabular doesn't officially support this, it appears to not work properly on a significant percentage of dimensions. Please support HideMemberIf or an equivalent properly.

    Comments (3)
    Greg Galloway's profile image Profile Picture

    7c4c8544 0f6e-4f5b-8dec-025f8be04038 on 18 Aug 2020 01:25:14

    RE: Support ragged hierarchies in Tabular through HideMemberIf equivalent

    Given that the tabular engine has supported this capability for about four years, and multidimensional has supported even more complex implementations of dimensional hierarchies; it just makes sense for Power BI to honor ragged hierarchies.

    Greg Galloway's profile image Profile Picture

    980886e1 179e-416a-8f0d-26972de3844d on 05 Jul 2020 23:17:26

    RE: Support ragged hierarchies in Tabular through HideMemberIf equivalent

    Yes, Still all Power BI visuals except Hierarchy Slicer visual shows blank branches in ragged hierarchy. this is the critical functionality needed.

    Greg Galloway's profile image Profile Picture

    c215c285 489c-4696-b7f1-687e11c420a2 on 05 Jul 2020 22:38:45

    RE: Support ragged hierarchies in Tabular through HideMemberIf equivalent

    Upcoming support for ragged hierarchies (Hide blank members) in SQL Server vNext CTP 1.1. for SSAS tabular compatibility 1400:
    https://blogs.msdn.microsoft.com/analysisservices/2016/12/16/whats-new-for-sql-server-vnext-on-windows-ctp-1-1-for-analysis-services/

    Update on BIDSHelper: https://bidshelper.codeplex.com/discussions/660769