The Cascade Information page specifies the members on which cascade is to be based.
Member Information—Displays the members that serve as the basis for the cascade operation. The cascade level to be performed is also indicated next to the member name.
Next Level—Select to create a worksheet for the children of each cascade member. This is the default cascade option.
All Levels—Select to create a worksheet for the descendants of each cascade member.
Bottom Level—Select to create a worksheet for all bottom-level members of each cascade member.
Sibling Level—Select to create a worksheet for the siblings of each cascade member.
Same Level—Select to create a worksheet for all members at the same level as each cascade member.
Same Generation—Select to create a worksheet for all members of the same generation as each cascade member.
Formulas—Select to create a worksheet for all members in the formula of the cascade member.
Destination Options Page (Essbase Cascade Options Dialog Box)