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.