MDX FirstChild Function08-08-2019 0 Comment(s)
The MDX FirstChild function will return the First Child member belongs to the specified member. For example, If you know single customer name and if you want to find the Sales of a first customer then you can use this FirstChild function.
SELECT [Measures].[Reseller Sales Amount] ON COLUMNS, [Geography].[Geography].[Country].[France].FIRSTCHILD ON ROWS FROM [Adventure Works];
In the above MDX Query, We used [Reseller Sales amount] on the columns
[Measures].[Reseller Sales Amount] ON COLUMNS
Below line of code will write the first child member of the France from all the State-Provices present in the France country.
No Comments to Show