MEMBERGET parameters
This topic describes changes in the way MEMBERGET handles invalid or mismatched specification of its hierarchy and element parameters.
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.
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.