Within application, how do you apply zero suppress within a hyperblock? I know how to do it within a slice but not a hyperblock. Any help would be greatly appreciated.
Hey,
Head over to list designer with the hyperblock selected, create a filter, and on the drop down option select value. Change the condition to value does not equal 0. Click fill and this will populate your data area with some defaults and any objects that are displaying the dimensions such as list views.
You can then control this via a button click (true, false flags). Apologies I can’t send screenshots at this time but the above should help.
We use a filter to get rid of zeros.
We try to never store actual zeros in the cubes because they take up space. That's why you see "null" as the value in the screenshot below.
0 is read as #NA/null. It only differentiates when comparing string literals; based on my findings
Thank you!
another example when it's important is when you are working with consolidated elements. If it's empty - it's #NA/null. But say you have two children with values 10 and -10, then the total is 0, but not null. Quite important for reporting
https://community.infor.com/infor-epm-user-group/m/infor-d-epm-platform-application-studio/1084 this is oldie but goodie still relevant very much (and other trainings about AppStudio like dynamic filters and so on might help as well)
