Hi,
What you are seeing is expected behaviour.
The way that row suppression works in Dynamic Reports is by checking whether there is data for the:
- Row Elements
- Any Title Element Selectors you have defined (if you have them - your example doesn't)
- And Column Elements
The column element is the annoying bit here, because you have nested your columns - it actually takes the distinct lists from each and then essentially unions them:
Even though you are not displaying 2012 + EST together, both elements exist individually in columns - so the system still checks them.
Good news for the future - IBMers are often talking about the future release of new updated reports that will allow us I believe to Suppress Rows AND Columns. But we don't have that functionality yet.
In the interim, you can get around it in an example like yours by using an MDX expression on the row dimension instead of zero suppression.
So you could add MDX to the TM1RptRow:
{Filter (
{ [Measures].members },
[CubeName].([BudDim].[BUD],[YearDim].[2012]) <> 0
)}
+
{Filter (
{ [Measures].members },
[CubeName].([BudDim].[BUD],[YearDim].[2013]) <> 0
)}
+
{Filter (
{ [Measures].members },
[CubeName].([BudDim].[EST],[YearDim].[2013]) <> 0
)}
It can get annoying and complex to try and do it with MDX on bigger reports though.
You can make the MDX life easier for you in those instances by having Consolidations of the years for each "Version" for example, and then you check whether the intersection of the Year Consolidation combined with the relevant version is not 0. I would not recommend doing individual column checks like I have above if you have more than a few columns!
Thanks,
Declan
------------------------------
Declan Rodger
Technical Director
Spitfire Analytics
------------------------------
Original Message:
Sent: Thu October 14, 2021 12:54 PM
From: Corentin Gombert
Subject: Suppress 0 in Dynamic Reports
Hi,
I've got a question on suppress 0 using on PAfE Dynamics Reports.
In a cube, if we have 2 dimension, for instance Version and Year, the zero suppression have a problem :
Versions : BUD / FCT
Years : 2020 / 2021
If we have the values :
BUD 2021 : 0
FCT 2020 : 0
BUD 2020 : 1000
And build an dynamic reports with just BUD 2021 and FCT 2020, the line is not suppressed with the zero suppression.
I think this is the normal behaviour of PAfE but colleagues told me that they do not encounter this situation on there applications.
In the screenshot in attachment, the cube have just 3 dimension and there is a zero suppression. There is value on EST 2012 REVENUE.
Corentin
------------------------------
Corentin Gombert
------------------------------
#PlanningAnalyticswithWatson