Select Source Sheets for Merged Cube Sheets
- Create the source sheets.
- Security:Model includes: sheets, accounts, dimensions, and formulaspermission.
Merged cube sheets require source sheets. Merged cube sheets combine the dimensions and use the data of up to 3 other cube or modeled sheets.
- From the sheet summary, clickDimensions, Attributes, and Levels.
- From the toolbar, click the gear icon.
- Click theSettingstab.
- Click the check boxes next to the modeled sheets and cube sheets you want to use as sources.You can select up to 3 sheets total.
Add the common dimensions of the source sheets to the merged cube sheet. See Add Dimensions and Attributes to Cube Sheets.