Difference between revisions of "FluenceXL Options/Version 9.1"
(Created page with "==XLCubed Options== These are the XLCubed installation level defaults which are applied to any new workbooks opened during the Excel session. ===User Interaction=== image:...") |
|||
| Line 3: | Line 3: | ||
===User Interaction=== | ===User Interaction=== | ||
| − | [[image: | + | [[image:XLCUI91.png|centre|600px]] |
*'''Language:''' selects XLCubed's interface language | *'''Language:''' selects XLCubed's interface language | ||
| − | |||
*'''Show right-click menu option at top(restart Excel to apply:''' the XLCubed right click menu option is by default at the bottom | *'''Show right-click menu option at top(restart Excel to apply:''' the XLCubed right click menu option is by default at the bottom | ||
*'''Use task pane for new grids:''' automatically opens Task Pane when new grid is created | *'''Use task pane for new grids:''' automatically opens Task Pane when new grid is created | ||
*'''Automatically apply changes in Task Pane:''' changes are made instantaneously | *'''Automatically apply changes in Task Pane:''' changes are made instantaneously | ||
| + | *'''Disable draggable grid labels:''' force all dimension labels on Grids to be hidden | ||
| + | *'''Case sensitivity:''' selects whether searches should be case sensitive, case insensitive, or should use the cube default | ||
*'''Automatically select Children of first member:''' the children of the first member are applied as a member selection when a hierarchy is selected (e.g. for a [[Dimension Slicers|Slicer]]) | *'''Automatically select Children of first member:''' the children of the first member are applied as a member selection when a hierarchy is selected (e.g. for a [[Dimension Slicers|Slicer]]) | ||
*'''Don't show Small Multiples warning:''' controls whether XLCubed warns when it restricts the number of charts it shows in a Small Multiple chart | *'''Don't show Small Multiples warning:''' controls whether XLCubed warns when it restricts the number of charts it shows in a Small Multiple chart | ||
| Line 14: | Line 15: | ||
*'''Use default credentials for web proxy:''' apply Windows' standard proxy settings when connecting to web services | *'''Use default credentials for web proxy:''' apply Windows' standard proxy settings when connecting to web services | ||
*'''Use Google China for maps:''' whether to use Google China for maps | *'''Use Google China for maps:''' whether to use Google China for maps | ||
| − | |||
| − | |||
===Data Options=== | ===Data Options=== | ||
| − | [[image: | + | [[image:XLCDO91.png|centre|600px]] |
| − | *''' | + | |
| + | *'''Show Cancel Query button after:''' time before long queries are cancelled (in seconds) | ||
| + | *'''Default at level view in member tree:''' sets the default view of hierarchies to be level based, rather than member based | ||
| + | *'''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) | ||
| + | *'''Limit for quick search:''' limits the number of members to search for to the value specified in the user interface | ||
| + | *'''Limit number of members returned in tree to:''' limits to specified value in user interface. See [[Expanding Large Hierarchies]] for details | ||
*'''Sort measures alphabetically:''' rather than the cube-defined order | *'''Sort measures alphabetically:''' rather than the cube-defined order | ||
| − | |||
*'''Show measures groups:''' where applicable, show Measures in their Measure Groups as defined in the cube | *'''Show measures groups:''' where applicable, show Measures in their Measure Groups as defined in the cube | ||
| − | |||
*'''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 | ||
| + | *'''Sort hierarchies alphabetically:''' rather than the cube-defined order | ||
| + | *'''Show dimensions in folders:''' display folders shown at a level above the dimension rather than beneath the dimension | ||
*'''Show named sets in hierarchy editor:''' adds named sets defined in the cube or in the workbook in the hierarchy editor alongside normal members | *'''Show named sets in hierarchy editor:''' adds named sets defined in the cube or in the workbook in the hierarchy editor alongside normal members | ||
*'''Show slicers in hierarchy editor:''' | *'''Show slicers in hierarchy editor:''' | ||
| − | |||
*'''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 | ||
| − | *''' | + | *'''Show sets in folders:''' controls whether XLCubed displays named sets in defined display folders or not |
| − | |||
*'''Formulae move With Members to Where clause:''' controls the MDX generated for formula reports | *'''Formulae move With Members to Where clause:''' controls the MDX generated for formula reports | ||
*'''Formulae maximum Tuple count:''' controls the MDX generated for formula reports | *'''Formulae maximum Tuple count:''' controls the MDX generated for formula reports | ||
| − | *''' | + | *'''Disable Tabular columns in Designer:''' sets whether XLCubed automatically attempts to disable unrelated columns for the [[Tabular Designer|tabular report designer]] |
| − | |||
*'''Pivot View maximum rows to retrieve:'''the maximum number of rows to include in the report (default 100,000) | *'''Pivot View maximum rows to retrieve:'''the maximum number of rows to include in the report (default 100,000) | ||
*'''Pivot View maximum cells in report:''' the maximum number of cells to include in the report (default 10,000,000) | *'''Pivot View maximum cells in report:''' the maximum number of cells to include in the report (default 10,000,000) | ||
| + | *'''Essbase Caption Type:''' chooses from where the Essbase connection retrieves its captions | ||
| + | *'''SAPHanaProtocol:''' the connection protocol used eg OLEDB, ADO.NET | ||
| + | *'''SAPBWProtocol:''' the connection protocol used eg OLEDB, ADO.NET | ||
| + | *'''SAPHanaLogPath:''' the log path for SAPHana connections | ||
===Web Publication=== | ===Web Publication=== | ||
| − | [[image: | + | [[image:XLCWP91.png|centre|600px]] |
| − | + | ||
*'''Maximum number of columns allowed:''' the maximum number of columns allowed per page | *'''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 | *'''Maximum number of rows allowed:''' the maximum number of rows allowed per page | ||
| + | *'''Default Web Address:''' the default web address for publishing. Below that lists recent web servers that have been connected to | ||
*'''Web service send timeout (minutes):''' the send timeout for the publication web service | *'''Web service send timeout (minutes):''' the send timeout for the publication web service | ||
*'''Log Publication Process:''' in the event of a problem, logs additional detail | *'''Log Publication Process:''' in the event of a problem, logs additional detail | ||
| − | + | ||
===Workbook Defaults=== | ===Workbook Defaults=== | ||
Controls the defaults for new workbooks. | Controls the defaults for new workbooks. | ||
| − | [[image: | + | [[image:XLCWD91.png|centre|600px]] |
*'''Format File:''' the default FormatSheet location | *'''Format File:''' the default FormatSheet location | ||
*'''Hide format sheet:''' sets whether the format worksheet is hidden when created in new workbooks | *'''Hide format sheet:''' sets whether the format worksheet is hidden when created in new workbooks | ||
*'''Default grid title:''' the default title of the grid | *'''Default grid title:''' the default title of the grid | ||
| + | *'''Default comments web server:''' the default web server for commentary | ||
*'''Available Actions - Ignore multiple filter members:''' if multiple members are selected on filters, these are ignored when determining which Actions to display | *'''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 {{Menu|Replace null values with}} text field | *'''Replace null values:''' replaces null values with the contents of the {{Menu|Replace null values with}} text field | ||
| + | *'''Validate members:''' when parsing a member, the formula will check that a valid member has been selected | ||
| + | *'''Remove drill indicators:''' do not display indicator showing that row/column can be drilled | ||
*'''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 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. | *'''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. | ||
Revision as of 11:22, 18 January 2018
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
- Language: selects XLCubed's interface language
- Show right-click menu option at top(restart Excel to apply: the XLCubed right click menu option is by default at the bottom
- Use task pane for new grids: automatically opens Task Pane when new grid is created
- Automatically apply changes in Task Pane: changes are made instantaneously
- Disable draggable grid labels: force all dimension labels on Grids to be hidden
- Case sensitivity: selects whether searches should be case sensitive, case insensitive, or should use the cube default
- Automatically select Children of first member: the children of the first member are applied as a member selection when a hierarchy is selected (e.g. for a Slicer)
- Don't show Small Multiples warning: controls whether XLCubed warns when it restricts the number of charts it shows in a Small Multiple chart
- Display Conversion Options: shows the Convert from V5 options in the XLCubed ribbon
- Use default credentials for web proxy: apply Windows' standard proxy settings when connecting to web services
- Use Google China for maps: whether to use Google China for maps
Data Options
- Show Cancel Query button after: time before long queries are cancelled (in seconds)
- Default at level view in member tree: sets the default view of hierarchies to be level based, rather than member based
- 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)
- Limit for quick search: limits the number of members to search for to the value specified in the user interface
- Limit number of members returned in tree to: limits to specified value in user interface. See Expanding Large Hierarchies for details
- Sort measures alphabetically: rather than the cube-defined order
- Show measures groups: where applicable, show Measures in their Measure Groups as defined in the cube
- Default at level view in measure tree: sets the default view of the measures hierarchy to be level based, rather than member based
- Sort hierarchies alphabetically: rather than the cube-defined order
- Show dimensions in folders: display folders shown at a level above the dimension rather than beneath the dimension
- Show named sets in hierarchy editor: adds named sets defined in the cube or in the workbook in the hierarchy editor alongside normal members
- Show slicers in hierarchy editor:
- Display Dimension Name with Hierarchy Name: prefixes the hierarchy name with the dimension name
- Show sets in folders: controls whether XLCubed displays named sets in defined display folders or not
- Formulae move With Members to Where clause: controls the MDX generated for formula reports
- Formulae maximum Tuple count: controls the MDX generated for formula reports
- Disable Tabular columns in Designer: sets whether XLCubed automatically attempts to disable unrelated columns for the tabular report designer
- Pivot View maximum rows to retrieve:the maximum number of rows to include in the report (default 100,000)
- Pivot View maximum cells in report: the maximum number of cells to include in the report (default 10,000,000)
- Essbase Caption Type: chooses from where the Essbase connection retrieves its captions
- SAPHanaProtocol: the connection protocol used eg OLEDB, ADO.NET
- SAPBWProtocol: the connection protocol used eg OLEDB, ADO.NET
- SAPHanaLogPath: the log path for SAPHana connections
Web Publication
- 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
- Default Web Address: the default web address for publishing. Below that lists recent web servers that have been connected to
- Web service send timeout (minutes): the send timeout for the publication web service
- Log Publication Process: in the event of a problem, logs additional detail
Workbook Defaults
Controls the defaults for new workbooks.
- Format File: the default FormatSheet location
- Hide format sheet: sets whether the format worksheet is hidden when created in new workbooks
- Default grid title: the default title of the grid
- Default comments web server: the default web server for commentary
- 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
- Validate members: when parsing a member, the formula will check that a valid member has been selected
- Remove drill indicators: do not display indicator showing that row/column can be drilled
- 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
- Lighten background colour on drill: when the user drills on a member a slightly lighter version of its background colour will be used for the new members
