Report Designer

The Report Designer dialog can be accessed either when creating a new report (through the XLCubed > Grid or Formula Report ribbon item), or when editing an existing Grid (via the XLCubed > Design Grid... right-click menu item). When first creating a Grid or formula report, if the workbook has no connections, then XLCubed will first prompt you to create a connection.

General Layout

The Report Designer has four main parts, as shown in the diagram below.

• A: The toolbar allows you to perform various operations and set certain options on the report.

• B: The Available Hierarchies panel contains a tree that allows you to select new hierarchies from the cube. Expand the dimension to view the hierarchies which it contains. Hierarchies can be dragged from this area into Headers, Rows or Columns to be used within the report. The different hierarchy types can be distinguished by their icon:

Icon	Description
	A user-defined standard hierarchy
	A parent-child hierarchy
	An attribute hierarchy

• C: The selected hierarchies panels show you what hierarchies are currently selected for the report. Clicking on a hierarchy shows the current member selection in D.
• D: The member selection panel shows the members selected for a hierarchy, as well as advanced selections such as rankings and member properties. More information can be found here.

Moving Hierarchies

Hierarchies can be easily moved between axes by dragging and dropping. The member selections and options for the hierarchy are preserved for the new position. To remove hierarchies from the report, drag them to the Available Hierarchies panel (B above).

To select more than one hierarchy for moving, either hold down the Ctrl key while clicking, or hold down the Shift key to select a range of hierarchies.

Toolbar

Icon	Description
	Clear all selections and move all dimensions back on to original positions
	Open a previous saved report file
	Save the current report layout as a file
	Save the current report layout as a favourite report
	Select a previously saved favourite report
	Enable writeback on the Grid
	Omit rows with only null values
	Omit columns with only null values
	Use the MDX function Generate to allow dynamic ranking and filtering (note: this option can be slower)

Saving Reports

Saving as a File

Using the Open Report and Save Report toolbar options, you can load and save the current report as .xl3grid files, which can then be shared with other users.

Favourites

You can add the current report as a favourite by using the Add to Favourites toolbar option, and reload a saved one by selecting it from the Favourites dropdown.

Saved favourites can be viewed, edited and deleted in the XLCubed > Utilities > Manage Favourites dialog.

See Also

• Grid Reporting Overview
• Hierarchy Editor
• Ranking, Sorting and Filtering
• Managing Favourites