This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 9%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVO%3C/text%3E%3C/svg%3E)
I want to create a tabular model with a ragged hierarchy. On the hierarchy I have the HideMembers
attribute set to HideBlankMembers. On SSAS 2019, the ragged hierarchy works for me with an empty string "". On SSAS 2022, it only works with a NULL value. Is it a bug in version 2022, that it is not working with empty string ""? Or should NULL be used correctly and the "bug" is that the empty string works on version 2019?
Thank you for reply.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Hi @Vančová Jana | K2,
It is not a bug in SSAS 2022. You should use NULL, not empty string, for ragged hierarchies with HideBlankMembers.
Thanks,
Akhil.