The cascade feature enables you to create multiple worksheets from one database view. This feature is useful when you want to distribute various worksheets across your organization. You can specify at what level of detail you want to replicate worksheets to tailor the information to the needs of each recipient.
To select the level of detail to replicate worksheets:
Select a member from the source worksheet to perform a cascade.
Next Level—Replicates worksheets using children of each cascade member.
All Levels—Replicates worksheets using descendants of each cascade member.
Bottom Level—Replicates worksheets using bottom levels of each cascade member.
Sibling Level—Replicates worksheets using siblings of each cascade member.
Same Level—Replicates worksheets using same levels of each cascade member.
Same Generation—Replicates worksheets using the same generation as each cascade member.
Formulas—Replicates worksheets using all members in the formula of each cascade member.
Copying Formats into Multiple Worksheets
Creating a Table of Contents for Multiple Worksheets
Specifying Multiple Worksheet Names
Specifying the Destination Directory of Multiple Worksheets