This function enables you to create a separate worksheet in your workbook for each instance of the selected characteristic. A copy of the current worksheet is created for each member of the characteristic. The worksheets are fully independent from one another with respect to navigation.
Each design item used in the current worksheet is copied to the new worksheet created. Each data provider used is also copied and the relevant copied data provider is assigned to each copied design item. In the formulas for the current worksheet, the names of the data providers in the copied worksheet are replaced with the names of the copied data providers.
Note that this function is only available in the context menu of a characteristic in the navigation pane if:
Note: When the system gets members, if the dynamic filter contains single values only, only these members are used; otherwise the first 200 members after sorting are used. The former of these two options is recommended when using this function.
You call the function in the context menu as follows:
The context menu that provides access to navigational functions for the selected cell appears, if available.
You want to display the net sales for each quarter. Using this function, you generate a view of the data for the query; in this view, the net sales for each quarter are displayed on separate worksheets.