You can view all levels of the selected dimension with one mouse click; however, if you expand a dimension containing many members, it may take a long time to display all members.
To view all levels of the selected dimension, click Clearing All Member Selections
Reordering Member Display in Worksheets
Selecting Members Using Attributes
Selecting Members to Add to Worksheets
Specifying Latest Period To-Date