When you replicate worksheets, you must specify where you want the worksheets to be created.
If you do not specify a directory, Essbase places the worksheets in the local root directory.
Copying Formats into Multiple Worksheets
Creating a Table of Contents for Multiple Worksheets
Specifying Multiple Worksheet Names
Specifying the Worksheet Detail Level