Excel Integration - Formula to show leaf nodes of a parent

stuart-barby

Hi All,

Looking for some guidance if there is a formula method in Excel Integration to pull back all leaf nodes of all particular parent unit? 

Any guidance greatly appreciated!

Thanks,

Stuart

Martin Reischl

Hi Stuart,

you can use the INFOR.GET.ELEMENTS formula with a DESCENDANTS MDX statement, e.g.:

=INFOR.GET.ELEMENTS(FALSE,"CUSTOM_MIS_CUSTOM_MIS","TREPORTING","MEMBER_UNIQUE_NAME","[DPSEGM]",,," ",1,"Descendants([DPSEGM].[Total],LEAVES)")

You will find more information on the Get.Elements formula here:

https://docs.infor.com/depm/2025.x/en-us/depmolh_cloud/default.html?helpcontent=excel_integration_cloud/ode1593182505449.html

And all the components of the MDX Descendants function here:

https://learn.microsoft.com/en-us/sql/mdx/descendants-mdx?view=sql-server-ver

Best Regards

Martin

Wichtige Lösungen in der Wissensdatenbank Februar 2012.pdf