There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
HideMemberIf on Tabular has very slow response or generates timeout error
I have a ragged hierarchy that is 1 - 10 levels deep. I originally had the formula for each level set so that it returned the same name as the node above if the depth of the leaf node didn't go down to that level. I tried to use HideMemberIf = ParentName,
but I kept getting timeout error messages from BIDS Helper.
I changed my formulas to just return blank if the leaf node didn't go down to that level and then tried HideMemberIf = NoName. This works eventually, but I have to wait for a good 3 minutes after setting this as SSDT goes to Not Responding for a while. Eventually,
it starts responding again, but this is a bit slow and painful for a 10 level hierarchy.
Am I doing something wrong? Is there something I can do to optimize this?