Difference between revisions of "XLCubed 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:options1v9.png|centre|350px]]
+
[[image:XLCUI91.png|centre|600px]]
 
*'''Language:''' selects XLCubed's interface language
 
*'''Language:''' selects XLCubed's interface language
*'''Case sensitivity:''' selects whether searches should be case sensitive, case insensitive, or should use the cube default
 
 
*'''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
*'''Use enhanced worksheet objects:''' recommended setting for Slicers, etc.
 
*'''Disable draggable grid labels:''' force all dimension labels on Grids to be hidden
 
  
 
===Data Options===  
 
===Data Options===  
[[image:options-2v9.png|centre|350px]]
+
[[image:XLCDO91.png|centre|600px]]
*'''Sort hierarchies alphabetically:''' rather than the cube-defined order
+
 
 +
*'''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 dimensions in folders:''' display folders shown at a level above the dimension rather than beneath the dimension
 
 
*'''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 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
 +
*'''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:'''  
*'''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]]
+
*'''Show sets in folders:''' controls whether XLCubed displays named sets in defined display folders or not
*'''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:''' 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
*'''Limit for quick search:''' limits the number of members to search for to the value specified in the user interface
+
*'''Disable Tabular columns in Designer:''' sets whether XLCubed automatically attempts to disable unrelated columns for the [[Tabular Designer|tabular report designer]]
*'''Query cancel timeout:''' time before long queries are cancelled (in seconds)
 
 
*'''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:options3v9.png|centre|400px]]
+
[[image:XLCWP91.png|centre|600px]]
*'''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 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
*'''Web server history:''' List of recent Web servers that have been connected to
+
 
  
 
===Workbook Defaults===
 
===Workbook Defaults===
 
Controls the defaults for new workbooks.
 
Controls the defaults for new workbooks.
[[image:options4v9.png|centre|400px]]
+
[[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.

Latest revision as of 11:22, 18 January 2018

XLCubed Options

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

User Interaction

XLCUI91.png
  • 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

XLCDO91.png
  • 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

XLCWP91.png
  • 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.

XLCWD91.png
  • 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