Returns a set of all members of the first level in the given hierarchy. Or, given a level, it returns a set of all the members of that level. This function is an InterSystems extension to MDX.
Syntax and Details
Given a level name, this function is equivalent to the MEMBERS
Given a hierarchy name, this function returns a set that consists of the members of the first level defined in that hierarchy.
Given a dimension name, this function returns a set that consists of the members of the first level defined in the first visible hierarchy of this dimension.
For example, consider the following cube contents:
The following query uses the %TOPMEMBERS function with H1
hierarchy (the only hierarchy in this case), so it retrieves all members of the Decade
SELECT birthd.%TOPMEMBERS ON 1 FROM patients
1 1910s 71
2 1920s 223
3 1930s 572
4 1940s 683
5 1950s 1,030
6 1960s 1,500
7 1970s 1,520
8 1980s 1,400
9 1990s 1,413
10 2000s 1,433
11 2010s 155
© 1997-2019 InterSystems Corporation, Cambridge, MA