Retrieves all immediate child values in a hierarchy as an array.
The MEMBERS identifier returns all the immediate children's values as an array. It needs to be used with an aggregate function to return values.
Example
Let us consider the scenario where we have Manufacturer, Country, and Products in the row hierarchy. For a particular manufacturer, the minimum sales at a country level can be calculated using the formula as shown in the below image.
