Скачать или смотреть Excel: The CUBESET Function - What is the Difference Between Children and Members?

I recorded this video in response to a viewer's question about the CUBESET function in Excel. In the video, I use real-world examples to break down how CUBESET works and when to use .MEMBERS to retrieve all items in a hierarchy level versus .CHILDREN to access direct descendants in your data model.

🗒 Notes and Resources
Download a copy of the file(s) used in this video: https://share.zight.com/7KuNOoLY

Recording of my CUBE Functions presentation:    • Cube Functions in Excel | Mike Thomas - Va...  

The formulas that I used in the demos:
=CUBESET("ThisWorkbookDataModel","[SalesYTD].[CountrySoldTo].members","Items")

=CUBESETCOUNT(A1)

=CUBERANKEDMEMBER("ThisWorkbookDataModel",$A$1,SEQUENCE(A2))

=CUBESET("ThisWorkbookDataModel","[SalesYTD].[CountrySoldTo].children","Items")

=CUBESET("ThisWorkbookDataModel","[SalesYTD].[Location].[Region].[EMEA].children",”Items”)

=CUBESET("ThisWorkbookDataModel","[SalesYTD].[Location].[CountrySoldTo].[USA].children",”Items”)

=CUBESET("ThisWorkbookDataModel","[SalesYTD].[Location].[Region].[CountrySoldTo].[USA].children",”Items”)

=CUBESET("ThisWorkbookDataModel","[SalesYTD].[Location].[CountrySoldTo].[USA].members","Items")

✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk

🙋‍♂️ Let's connect on social
Twitter:   / theexceltrainer  
Facebook:   / theexceltrainer  
LinkedIn:   / thomasmik  

#excel #datamodel #cube