Question & Answer
Question
In Planning Analytics Version 12, no results are returned to a FILTER expression if the cells included in the FILTER are not fed.
Answer
In Planning Analytics Version 12, the MDX engine issues zero suppressed requests to the TM1 engine to get the values and evaluate the search condition in the FILTER expression. This is a change of behaviour from Planning Analytics Version 11.
If the cell is not fed the TM1 engine will not return that cell to the MDX engine.
If the cell should be included, a FEEDER statement must be written.
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEAI8G","label":"Planning Analytics as a Service"},"ARM Category":[{"code":"a8m3p000000GoaGAAS","label":"Planning Analytics-\u003EPlanning Analytics as a Service Specific"}],"ARM Case Number":"TS019359632","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":""}]
Was this topic helpful?
Document Information
Modified date:
16 June 2025
UID
ibm17236805