Topics: Standing Discussions
May 25, 2016 at 10:00 AM
Hi All,

I have a product line hierarchy which as 10 levels in tabular model, there is no issue setting this hide member if property with option "NONAME" for all the 10 levels, But when i do full process for that table, processing takes end less time.

when i remove or not applying this hide member if property then table process in no time.

My table just contains 130 rows.

Can some one please suggest me, should we not use this property for the hierarchies which has more levels like mine.

May 25, 2016 at 11:33 AM
Sorry, but this is a common issue. Tabular HideMemberIf seems to work OK for a small number of levels, but I have not seen it work once you get up to the number of levels that you have. (This could be one reason why Microsoft does not support this property) You will probably have better luck using a dax pattern like this one
May 25, 2016 at 1:41 PM
Darren is right. Common issue and there may be nothing we can do. But try a few things:

You might check what version of SSAS you are running and install the latest service pack and cumulative update.

You might also see if your hierarchy is natural. See notes here for how: