Children (MDX)
Returns the set of children of a specified member.
Syntax
Member_Expression.Children
Arguments
Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.
Remarks
The Children function returns a naturally ordered set that contains the children of a specified member. If the specified member has no children, this function returns an empty set.
Example
The following example returns the children of the United States member of the Geography hierarchy in the Geography dimension.
SELECT [Geography].[Geography].[Country].&[United States].Children ON 0
FROM [Adventure Works];
The following example returns all members in the Measures dimension on the column axis, this includes all calculated members, and the set of all children of the [Product].[Model Name]
attribute hierarchy on the row axis from the Adventure Works cube.
SELECT
Measures.AllMembers ON COLUMNS,
[Product].[Model Name].Children ON ROWS
FROM
[Adventure Works]
Next steps
Váš názor
https://aka.ms/ContentUserFeedback.
Připravujeme: V průběhu roku 2024 budeme postupně vyřazovat problémy z GitHub coby mechanismus zpětné vazby pro obsah a nahrazovat ho novým systémem zpětné vazby. Další informace naleznete v tématu:Odeslat a zobrazit názory pro