Export to Excel
You can export a cube view as a Microsoft Excel spreadsheet.
About this task
- Maximum number of rows
- Maximum number of columns
- Maximum number of cells
- 8 million
- Maximum number of view instances
The total number of instances is determined by multiplying the number next to each option. If the number of instances is greater than 100, try changing your selection.
Export to Excel is not available from an iPAD.
- Click the cube view that contains the data that you want to export, then click to open the shortcut bar and click on the shortcut bar.
- Optional: Select which parts of the view that you want to export, based on
hierarchy. Click next to Optionally burst based on the following
hierarchies. An option is shown for each dimension hierarchy that appears in the Context bar. If you select nothing, then the selection of data that is shown in the view is exported.
- Choose whether you want to export all sheets to a single file, or to multiple files. If you didn't choose to burst based on a hierarchy, only one sheet can be exported.
- Click OK to begin the export process.
Take as an example a view that shows models on the rows, and regions on the columns. On the context bar, Variance is selected in the actvsbud tile and Units is selected in the account1 tile. If you don't select a hierarchy to burst to, the view is exported as selected, with no additional sheets. But if you select a hierarchy, all possible combinations of views are exported.
For example, the actvsbud hierarchy has the following three items:
If you select actvsbud hierarchy, data is exported to three sheets: Variance, Actual, and Budget.
The account1 hierarchy has three items at the same level:
- Variable costs
If you select account1 hierarchy, data is exported to nine sheets:
- Variance_Variable costs
- Actual_Variable costs
- Budget_Variable costs