Missing suppression
Suppress cell missing a value.
Availability
Features | Microsoft | |||||||
---|---|---|---|---|---|---|---|---|
Essbase | SSAS | Planning | PBCS | Essbase | SSAS | Planning | PBCS | |
Missing supression | ✅ | ❌ | ❌ | ❌ | ✅ | ❌ | ❌ | ❌ |
Missing col | ❌ | ❌ | ✅ | ✅ | ❌ | ❌ | ✅ | ✅ |
Missing row | ❌ | ❌ | ✅ | ✅ | ❌ | ❌ | ✅ | ✅ |
Functionnality
Activating this setting will automatically remove cell where the value is missing after an Ad-Hoc.
Two further options exists:
Missing col suppression which delete any column where all the datas are missing.
Missing row suppression which do the same for the rows.