INFOR.GET.AXIS and Zero Suppression when more than one dimension is in rows or columns

Jose Salinas

Hi everyone,

I am trying to build an Excel Integration report with Entity and Account on rows and Date on columns. I am also using the INFOR.GET.AXIS formula to create this report. It works but I get an error when trying to add zero suppression to the report.

I found a sample report in our community forum and have been trying to follow the same example, but I haven't had any luck. I'm sure I'm missing something, and I'm hoping someone who has encountered the same issue might be able to help me identify the problem.

I've tested the unique names of all elements being fed to the zero suppresion filter by calling on caption attirbute via INFOR.GET.ELEMENTS formula, and they all returned correct captions so seems like maybe I'm just not getting the syntax down correctly in the FilterZS or the INFOR.GET.AXIS formula. I've included my current syntax below. My dimension names are long, so simplified them for readibility.

The error I receive when trying to apply the zero suppresion is #VALUE and in Application Logs I see: "#VALUE! error when calculating formulas. Generating GetAxis report. Hierarchy and members are empty. Hierarchy and default member can't be detected."

Filter Elements: ("Top level" selected for all filter elements)

Measures,Unit,Currency,FinDim1,FinDim2,FinDim3,FinDim4,FinDim5,FinDim6,FinDim7,FinDim8,FinDim9,FinDim10,Ledger,Project,Scenario,System

Row Elements:

1st element is (Entity.Children) and 2nd element is Descendants(Account,100,Leaves)

Column Elements:

Descendants(Calendar,100,Leaves)

My zero suppresion filter for Entity is:

FilterSZ({Entity.Children},(Measures,Unit,Currency,FinDim1,FinDim2,FinDim3,FinDim4,FinDim5,FinDim6,FinDim7,FinDim8,FinDim9,FinDim10,Ledger,Project,Scenario,System),{Descendants(Calendar,100,Leaves),Descendants(Account,100,Leaves)})

My zero suppresion filter for Account is: (Excluded Entity dimension based on example of sample report found)

FilterSZ({Descendats(Account,100,Leaves)},(Measures,Unit,Currency,FinDim1,FinDim2,FinDim3,FinDim4,FinDim5,FinDim6,FinDim7,FinDim8,FinDim9,FinDim10,Ledger,Project,Scenario,System),Descendants(Calendar,100,Leaves))

My INFOR.GET.AXIS formula for row elements:

INFOR.GET.AXIS(Database,Cube,FALSE,,"Entity",{"MEMBER_CAPTION,MEMBER_UNIQUE_NAME"},"Account FilterSZ ref above",,,"Account",{"MEMBER_CAPTION,MEMBER_UNIQUE_NAME"},"Entity FilterSZ ref above")

Thank you for your time!

Jose

Vit Holy

Hello @jose-salinas2 ,

Shouldn't it be FIlterZS? Or is it just typo?

In case it does not resolve your issue, feel free to raise support ticket where you can provide the report and the database? Once I'll have a bit time I can take a look.

Note: please be aware that such filtering (FilterZS) - in such per-partes report type (i.e. having get.axis and read.values formulas) - has some limitations (e.g. when you start doing crossjoins, etc.).

InforUX_CEBUsability360-02012024.pdf