Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs
    • SQL FAQ’s

MDX Children Function

by suresh

How to write Children function with examples?. The MDX Children function will return the associate Child member that belongs to the specified member. 

For instance, If you are an Amazon developer and If one of your customers is looking for iPod in Amazon.com. As a developer, you must display all the Apple products at the bottom of the page. So that user can browse other products and sometimes he may buy? In these situations, you can use the MDX Children function by writing something like [Product].[Apple].[iPod].Parent.Children.

MDX Children Function Syntax

The basic syntax of the Children Function in Multidimensional Expression is as shown below:

Member_Expression.CHILDREN

Member_Expression: Any Multidimensional Expression that returns valid Member.

MDX Children Function Example

In this example, we are going to find the [Reseller Sales amount] of all the states present in France.

SELECT 
  [Measures].[Reseller Sales Amount] ON COLUMNS,
  [Geography].[Geography].[Country].[France].CHILDREN ON ROWS
FROM [Adventure Works];

OUTPUT

MDX CHILDREN FUNCTION 1

From the above MDX screenshot, you can observe that It is displaying all the states present in France.

Children Function Example 2

In this example, we are going to find the [Reseller Sales amount] of all the countries present in the Geography attribute.

SELECT 
  [Measures].[Reseller Sales Amount] ON COLUMNS,
  [Geography].[Geography].CHILDREN ON ROWS
FROM [Adventure Works];

OUTPUT

MDX CHILDREN FUNCTION

Placed Under: MDX

  • MDX Ascendants Function
  • MDX AVG Function
  • MDX BottomCount Function
  • MDX BottomPercent Function
  • MDX BottomSum Function
  • MDX Children Function
  • MDX ClosingPeriod Function
  • MDX COUSIN FUNCTION
  • MDX FirstChild Function
  • MDX FirstSibling Function
  • MDX Head Function
  • MDX LastChild Function
  • MDX LastSibling Function
  • MDX LastPeriods Function
  • MDX LAG Function
  • MDX LEAD Function
  • MDX NextMember Function
  • MDX NONEMPTY Function
  • MDX NON EMPTY
  • MDX OpeningPeriod Function
  • MDX ParallelPeriod Function
  • MDX PeriodsToDate Function
  • MDX PrevMember Function
  • MDX Parent Function
  • MDX Siblings Function
  • MDX Tail Function
  • MDX TOPSUM Function
  • MDX TopPercent Function
  • MDX TopCount Function
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy