How to hide "All" member of Date dimension in tables?

[Oleks_Master]

Hello,

By default, there is the root member "all" in Date hierarchy.

My business users do not need it in a planning table.

How to hide All and to see YM hierarchy in table columns?

Br, Oleksandr

[Susanne_Helbig]

Hi @Oleks_Master,

did you try to use the Hide column feature of the table menu?

Right-click on the (All) member and select Hide column

Best regards
Susanne

[Oleks_Master]

Hello Susanne, please have a look at my another comment below (I have mentioned you there)..

[Oleks_Master]

Hi @N1kh1l ,

Hi @Susanne_Helbig ,

When I "select some years from date member selection" (in filter section), All member is still shown. Even if I select one year, 2024 for example, All member is displayed anyway just before 2024.

Of course I can right click and hide All column(s). But since I have reached the limit of server capacity: 75 columns (5 years per months + variances) and 2k rows, I have to count every column.

Hiding such column(s) in a table means SAC calculates them, deliver values to frontend, and hide it at the end. In other words, even if All member is hidden, it still calculated and it consumes some performance/capacity.

My intention is to exclude All member from the calculation and to save backend capacity for other really needed calculations.

Br, Oleksandr

[N1kh1l]

@Oleks_Master 

In Table Builder set your Date Hierarchy to be Year/Month. Also select what Years you want to select. Also if its a Input control which is filtering the table then edit the input control and untick the select All option.

Input Control settings

Hope this helps !!

Nikhil

[Oleks_Master]

Thank you, Nikhil. But as we don't use an input control for Date, is there a way without creating it?

[N1kh1l]

Input control is not required. I just said that If you have a date input control then this should be the setting of it. If not then just set your table as shown above.

[Oleks_Master]

The table setting is done - Hierarchy / Year, Month. And this hierarchy includes/shows All member at the very left in columns.

[N1kh1l]

Either select some years from date member selection or if you want all years but do not want the All node shown, you can right click and just hide the All column.