Application Studio - Filtering a hyperblock

I am trying to filter a hyperblock using a global variable. I can get the hyperblock to visually suppress certain parents or children (based on a multi-selector), but it isn't filtering. For example, if I have a hierarchy with one parent and three children, the user can select the parent and/or the children, or they can select the parent with just one or two of the children. If they select a subset of the children and the parent, the parent shows the GRAND TOTAL for all children, not only the ones selected. Here is a simple mockup of what is happening:

When the user selects the parent and a couple of children, the parent still shows the total:

However, this is the result I want:

Is there a way to filter the results of the hyperblock based on the selected results?

Find more posts tagged with

Infor EPM Discussions

Comments

Peter Mayall

I have a solution but it isn't pretty. You can have a hidden column displaying the parent element. For the parent rows perform a SUMIF2 where the child's parent is equal to that row's element.

John Robson

My preferred option is to have the hyperblock show just the base elements then to calculate the sum in app studio. This works when there is only one parent.

gloerincs

I usually rely on the Select Element action using the Lookup control and the CELLGET function when dealing with multiple selections.

When using the Select Element action, the Action.Results returns a XML expression when more than one element is selected.

You can transform the XML to a comma separated list using the MULTISELECTGETMEMBERSSIMPLE function.

The XML expression can be passed as a parameter to the CELLGET function to retrieve the corresponding data slice. You could use it to display the "Parent" value in your example.

The comma separated list can be used inside the hyperblock definition, in the structure selection settings and/or filter section.

Nick Gladkov

Marcus, first let me give you some details - OLAP parents are defined as aggregation of specified elements. OLAP always aggregates/consolidate theses elements andt heses elements only and this is not defined by selection in view.

Your experience is probably connected to Business Intelligence tools where you have single 'total' per row/column it always aggregates visible elements on the screen. We have same idea in Self-Service where you can see total of visible elements.

But what is important is we also working on some user defined totals and sub-totals, where you will be able to define new lines which will be calculated as defined by user. This will solve the task you have, however this is just being defined and I can't share any more details (will know more in the upcoming weeks).

Nick

Copyright © 2025 Infor. All rights reserved.