XLCubed Options/Version 8.0

XLCubed Options

These are the XLCubed installation level defaults which are applied to any new workbooks opened during the Excel session.

User Interaction

• Show right-click menu option at top
• Use task pane for new grids
• Automatically apply changes in Task Pane
• Automatically select Children of first member
• Don't show Small Multiples warning
• Display Conversion Options
• Use default credentials for web proxy
• Unicode Compatibility (Excel 2003)
• Use enhanced worksheet objects
• Hold Shift key to disable workbooks while opening

Data Option

• Sort hierarchies alphabetically: rather than the cube defined order
• Sort measures alphabetically:
• Show dimensions in folders: display folders shown at a level above the dimension rather than beneath the dimension
• Show measures groups:
• Default at level view in member tree: sets the default view of hierarchies to be level based, rather than member based
• Default at level view in measure tree: sets the default view of the measures hierarchy to be level based, rather than member based
• Show named sets in hierarchy editor:
• Show slicers in hierarchy editor:
• Use single members on filters: implements 'select and replace' on hierarchies in the filter area of grids (selecting a member replaces any existing selected member)
• Display Dimension Name with Hierarchy Name: prefixes the hierarchy name with the dimension name
• Disable Tabular columns in Designer: sets whether XLCubed automatically attempts to disable unrelated columns for the tabular report designer
• Limit number of members returned in tree to: limits to specified value in user interface. See Expanding Large Hierarchies for details
• Formulae move with members to Where clause:
• Formulae maximum Tuple count:
• Limit for quick search:
• Query cancel timeout:

Web Publication

• Default Web Address: the default web address for publishing
• Maximum number of columns allowed: the maximum number of columns allowed per page
• Maximum number of rows allowed: the maximum number of rows allowed per page
• Log Publication Process: in the event of a problem, logs additional detail
• Check Web Compatibility:checks the workbook pre-publication for any known compatibility issues.

Workbook Defaults

Controls the defaults for new workbooks.

• Available Actions - Ignore multiple filter members: if multiple members are selected on filters, these are ignored when determining which Actions to display
• Replace null values: replaces null values with the contents of the Replace null values with text field
• Remove nulls when drilling: if there are any null rows/columns when drilling down on a member, they will be removed so that there are no fully empty rows/columns in the report.
• Remove 0 values when drilling: if there are any rows/columns when drilling down on a member that only contain zeros, they will be removed so that there are no zero rows/columns in the report.
• Resize Columns after drilling: this allows a column to resize itself when drilled
• Indent drilled members: when the user drills down on a member, they will be displayed indented