MEMBERGET parameters

This topic describes changes in the way MEMBERGET handles invalid or mismatched specification of its hierarchy and element parameters.

There was an issue with error checking in MEMBERGET, which was solved in version 10.3.1. Some users had exploited the issue in their reports and the solution caused inconvenience. The faulty behavior is reimplemented through a patch and will remain until a further version. The patch is available on the Infor Support Portal in Solution 1107030.

Here is a summary of the current behavior:

  • The hierarchy parameter of the MEMBERGET function is ignored, unless the element parameter is invalid.
  • If the element parameter is invalid, the specified text is parsed in an attempt to identify which element name was intended and the hierarchy to which it belongs

The current behavior is described in these scenarios:

Valid hierarchy parameter with invalid element parameter

In this scenario, the output of the MEMBERGET function depends on whether the invalid element name can be parsed and the intended name determined.

The element parameter might be invalid in these ways:

  • There is a typographical error
  • The parameter is valid, but does not belong to the specified hierarchy
  • A hierarchy is specified instead of an element
  • A dimension is specified instead of an element

Example 1

=MEMBERGET("data_connection", "Cube", "H2","H1.error","self")

In this example, the text H1.error is parsed and the correct element name identified.

The formula returns the default element of hierarchy H1.
Note: In versions prior to 10.3, the formula returns the default element of hierarchy H2.

Example 2

In this example, the element parameter contains meaningless text, or a dimension or hierarchy name:

=MEMBERGET("data_connection", "Cube", "H2","nonsense","self")

In this case, the element parameter cannot be parsed.

The formula returns the default element of hierarchy H2. This behavior is unchanged.

Invalid hierarchy parameter with invalid element parameter

In this scenario, the output of the MEMBERGET function depends on whether the invalid element name can be parsed and the intended name determined. If the element parameter can be parsed, the invalid hierarchy parameter is ignored.

Example 1

Here, the user specifies a dimension name in the hierarchy parameter and an invalid element name.

=MEMBERGET("data_connection","Cube", "Dim1", "H1.error", "self")

In this case, the element parameter can be parsed. The formula returns the default element of hierarchy H1.

In versions prior to 10.3, the formula returns the default element of the default hierarchy of the dimension specified in the hierarchy parameter.

Example 2

Here, the user specifies a dimension name in the hierarchy parameter and an element name that cannot be parsed:

=MEMBERGET("data_connection","Cube", "Dim1", "nonsense", "self")

The formula returns the default element of the default hierarchy of the dimension specified in the hierarchy parameter.

Invalid hierarchy parameter with valid element parameter

Here, the user specifies an invalid hierarchy parameter with an element parameter which is valid in a hierarchy.

=MEMBERGET("data_connection","Cube", "error", "H1_element", "self")

The formula returns the default element of the hierarchy to which the specified element belongs.

Note: In version 10.3.1 this behavior was altered to return #NA! if the hierarchy parameter was incorrectly specified.