SAC - Keeping columns with no data visible​

[former_member714075]

Hi,

I am trying to set up a standard layout in SAC. According to this the number of columns should be fixed, i.e. it should remain the same even if there are no data to be displayed in a particular column.

In the following example, we split each KPI in 3 periods (previous year, current year and variable vs previous year):

For some rows, there are no results for some of the periods:

So when we filter the table leaving only the highlighted rows, the columns with no results (“-“) are hidden and the layout changes. The table looks like that:

Is there any way to change this behavior? Can it be adjusted on story level or maybe it’s a matter of model or view settings?

Thanks in advance for your help!

[William_Yu1]

You can switch on 'Unbook data' mode for dimensions in your column.

[former_member714075]

William Yu, thanks for your prompt answer. I tried this already but sadly no result...

[William_Yu1]

make sure that all dimension in column axis have this setting on

[franco_p]

Have you tried to hide the Nulls in Table Columns and/or rows?

[former_member714075]

William Yu, thanks for your prompt answer. I tried this already but sadly no result...

[deshmukh]

sebastian.parzychowski

Were you able to achieve this? i also have the same requirement.

Thanks.