| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XLCubed Options/Version 8.0"
| Line 14: | Line 14: | ||
*'''Use enhanced worksheet objects | *'''Use enhanced worksheet objects | ||
*'''Hold Shift key to disable workbooks while opening | *'''Hold Shift key to disable workbooks while opening | ||
| − | + | ||
| − | [[image: | + | ===Data Option=== |
| − | *''' | + | [[image:options2v8.png|centre|350px]] |
| − | *''' | + | *'''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 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 | *'''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 | + | *'''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) | *'''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 | *'''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 Designer|tabular report designer]] | *'''Disable Tabular columns in Designer:''' sets whether XLCubed automatically attempts to disable unrelated columns for the [[Tabular Designer|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=== | ===Web Publication=== | ||
Revision as of 10:49, 7 May 2015
Contents
[hide]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
