BLOG

MDX FirstChild Function

08-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.

[Geography].[Geography].[Country].[France].FIRSTCHILD

Comment Here

Comments

No Comments to Show

WE ALWAYS WORK WITH :