Zero Suppression SAC Analytical App

[#1]

Hi,

In Analytical Application, I was hoping to perform row wise Zero suppression on measures.

For e.g. I am showing a list of G/L accounts (rows) . I am showing Actuals, Budget and Variance (columns). I want to suppress rows that have a sum of Actual + Budget + Variance equal to zero. i.e. G/l Accounts with No actuals and No budget should NOT show.

Currently Budget column holds zero values only.

The function , Table_1.setZeroSuppressionEnabled(TableAxis.Columns,true) hides the budget column all together.

The Function, Table_1.setZeroSuppressionEnabled(TableAxis.Rows,true); does not change anything.

How can I achieve zero suppression in Analytical app?

Regards,

Cleo.

[former_member302630]

We are using SAC live connection. So unfortunately, mentioned option is not available.

[Verdia_Mayank]

Hello cleo.james - how did you solve this problem? we are also using live connection and unable to suppress zero rows. It will be helpful if you can share how you solved it in SAC story or via Analytical Designer.

Thanks ,

Mayank Verdia

[venkateswaran_k]

Hi

You can achieve this by

1. Create a Calculated Measure for each row as formula (Actual + Budget + Variance).

2. Create calculated dimension Of type "Measure-Based Dimension".

3. Then in your table filter it on the dimension as created above.

Regards,

Venkat

[former_member302630]

We are using SAC live connection. So unfortunately, mentioned option is not available.

[Noel_Munday]

This is a good solution for data acquisition models. I used it and it worked well but take note that comments stop working when you use a calculated dimension.