Excel Member Set

Creating a member set in Excel allows you to define the members returned on an Axis based on cell contents.

This can offer more flexibility that defining the members for a hierarchy in Excel, as it allows you to chose which combinations of members are displayed instead of the grid doing a crossjoin which is the standard behaviour.

You can leave a cell blank to get the default member of a hierarchy.

You must define the hierachies as well as the members, and this allows formulae to update the grids layout if required.