Ad-hoc reports
Creating and designing Ad-hoc reports are separate processes. An Ad-hoc report is a view of the data in a cube. You create an Ad-hoc report and then design it by specifying which dimensions, hierarchies, and elements will form the view of the data.
In Ad-hoc reports you can drag and drop dimensions to create different views of the data. For example, exchange the row dimension with the column dimension, or exchange row and column dimensions with slice dimensions. You use the List Designer to specify which elements of the row and column dimensions are shown in the report (for example, to specify that the report only shows data for particular financial years, or products). Use the Select Elements dialog to select elements for the slice-dimensions.
SeeChoosing slice elements in Formula and Ad-hoc reports.
There are four ways in which to create an Ad-hoc report:
- Click on the ribbon
- Double-click a cube in the Database Structure
- Right-click a cube in the Database Structure and select
- Click in the toolbar of the Database Structure.
Of these methods, the first enables you to partially specify the design of the report during its creation. The remaining methods offer no design options and create a default view of the data.
The number of columns and rows which reports can contain depends on the version of Microsoft Excel which you use.