Views

CaptionBeforeBuild is the text that appears on the view tab or title bar when a user opens the view and before the view builds for the first time. If no value is specified, the view name is used as the caption.

CaptionAfterBuild is the text that appears on the view tab or title bar after the view builds or refreshes. If no value is specified, the CaptionBeforeBulid displays. If no CaptionBeforeBuild is specified the view name displays.

The AllowLROs setting defines whether the Linked Objects Browser dialog appears when a user double-clicks the left mouse button in a data cell. A linked reporting object (LRO) is an object that you associate with a specific data cell in an Analytic Services database; for example, a graphic file that more fully explains a cell value. LROs provide improved support for planning and reporting applications and can enhance data analysis capabilities by providing supplemental information about data. LROs can be linked files, brief cell notes, or URLs. AllowedLROTypes controls the LRO types available in the Linked Objects Browser dialog.

AllowPivot controls whether the user is allowed to initiate an Essbase operation. If True, a user can initiate a pivot operation by pressing the right mouse button in a member cell and the holding and dragging the mouse to the destination cell. The Pivot button tool can also be used to pivot a member. The tool is enabled when the AllowPivot setting is True.

AllowEssbaseOperationsOnRetrieveRange controls whether the user can perform Essbase operations, including Zoom Out, Remove Only, Keep Only, and Pivot on the data that is contained within the retrieve range.

AllowSave controls whether a user can save a view. If True, the Save View and Open Saved View buttons are enabled. AllowSend controls whether the user is allowed to update Essbase data by posting changes to the database. If True the Save View and Open Saved View tool buttons are enabled.

AllowLROsOnDrillThroughSheet controls whether the Linked Objects Browser dialog appears when a user double-clicks the left mouse button in a data cell on a drillthrough.

AllowedLROTypesOnDrillThroughSheet controls the LRO types available in the Linked Object Browser dialog for a drillthrough sheet. This option is only applicable when AllowLROsOnDrillThroughSheet is True.

SelectorsVisibleOnDrillThroughSheet controls whether the selectors are visible when a drillthrough sheet is the active sheet. AllowSendOnDrillThroughSheet controls whether the user is allowed to update Essbase data by posting changes to the database with the data from the active drillthrough.

CascadeDoCascade controls whether the view is cascaded when built. When the view is cascaded, the list each cascade source defines is obtained or generated. The Cartesian product of the lists is generated and a copy of the cascade template sheet is created for each ordered combination of members. The cascade template sheet is deleted.

The RetrievePolicy should be set to AllSheets if the cascade template does not contain a named retrieve range. The RetrievePolicy should be set to RetrieveRanges if the cascade template does contain a named retrieve range.

A source, with reference to a cascade, is either a selector, which allows the user to select the items of the cascade list or a script which is used to generate the list. CascadeSources defines the source for the views cascade list. Clicking on the ellipses on the CascadeSorces row displays the Cascade Sources Dialog showing Source Type and a list of sources.

CascadeSheetnamedPattern specifies the tokenized string used to build the name of each cascade sheet and is only applicable when the CascadeDoCascade setting is True. By default, the sheet name contains each of the member names represented by the sheet. For example, if the cascade sources are the selectors for Product, Market and Scenario, and the members represented by the sheet are Cola, New York and Actual, the default sheet name is Cola-New York-Actual.

The CascadeTemplateSheetNumber property specifies the 0-based index of the sheet in the Excel template that is used as the cascade template sheet.  CascadeTemplateSheetNumber is only applicable when the CascadeDoCascade setting is True.

SummarySheetAdd controls whether a cascade summary sheet is added to the view. If a summary sheet is added, [T.SummarySheetList] and [T.SummarySheetsRange] will be added to the view’s tokens.

ChartRetrieveRangeInfo relates each chart control in the view user-interface to the retrieve range that contains the data represented by that chart.

Clicking on the ellipses after selecting the ChartRetrieveRangeInfo property displays a dialog box.

In the dialog, the ChartName is the name of the chart control. The value is used to locate the chart control to fill with the retrieve range data. The value must match the name of an existing chart control. The Caption is the text displayed on the chart control pane title bar and tab. This value can contain tokens. The RetrieveRangeName is the name of the retrieve range that contains the data the chart will represent.

AllowCommentsExplorer controls whether to allow the comments explorer functions.

CommentsExplorereDisplayMode controls whether the comments editor displays in a docked pane or a modal dialog.

CommentsExplorerDockedControlLocation is the initial docked location for a dockable comments editor. The setting is only applicable when the *CommentsExplorereDisplayMode * is set to DockedControl or LockedDockedControl.

CommentRanges controls the behavior or comments within each specified comment range. Clicking on the CommentRanges ellipses opens the Comment Range Configuration Editor.

This configurations editor,  like the other metadata editors, has required property settings.

DataCellDoubleClickPolicy controls what happens when the user double-clicks an Essbase data cell with the left mouse button.

DataCellDoubleClickMemberFilters controls whether the action the DataCellDoubleClickPolicy defines is performed based on the level number, level name, member name or UDS of the contributing members.

DataDrillthroughSheetName indicates the base name used for a drillthrough sheet. A drillthroughsheet is added when the DataCellDoubleClickPolicy is AddSheetForDrillThrough and the user double-clicks a data cell with the left mouse button. When a drillthrough sheet is added, the sheet name is constructed using the DataDrillthroughSheetName. If other drillthrough sheets exist, the name is appended with a number of the copy in parenthesis. This is the same naming convention used by Microsoft Excel when a sheet is copied. The DataDrillThroughSheetName can be tokenized. By default, this setting is empty. When the setting is empty, the name of a drillthrough sheet is a concatenated list (delimited by dashes) of the members that intersect the data cell. Example: East – Actual – Qtr 1- Sales – Cola.DataDrillthroughSheetName is only applicable when the DataCellDoubleClickPolicy is AddSheetForDrillthrough.

DataDrillthroughSheetNameMaxLength controls the maximum length of a drillthrough sheet name. The default setting is 31, which is the maximum number of characters allowed by Microsoft Excel for a sheet name. When the view is to be saved to Microsoft Excel, use the default setting. DataDrillthroughSheetNameMaxLength is only applicable when the DataCellDoubleClickPolicy is AddSheetForDrillthrough.

DataDrillthroughViewID indicates the ID of the view that is open when the DataCellDoubleClickPolicy is OpenViewForDrillthrough and the user double-clicks a data cell with the left mouse button.

Every Token that a selector defines for a dimension whose member contributes to the data cell is passed as a view token to the drillthrough view using the ViewTokens. Since ViewTokens is used to set the default selections for the drillthrough view, both views can represent the same Essbase data (as appropriate).  DataDrillthroughViewID is only applicable when the  DataCellDoubleClickPolicy is OpenViewForDrillthrough.

When the  DataCellDoubleClickPolicy is OpenViewForDrillthrough, EnforceEssbaseFilterOnOpenViewForDrillthrough controls whether the view is opened when an Essbase filter prevents the user from accessing the data cell. If the setting is True, the view is not opened when the user has no access to the data cell. If the setting is False, the view is opened whether or not the user has access to the data cell.

EssbaseConectionID is the Essbase connection ID used to look up the connection metadata that defines the Essbase connection setting for the view. The EssbaseLoginServiceObjectTypeID is the object type ID of the login service that obtains the credentials necessary to sign on to the Dodeca Essbase service.

AllowUserEssbaseOptions controls whether a user’s Essbase options settings are used instead of the Essbase option settings that are defined for this view, which are represented by the EssProperty settings. When used in conjunction with the AllowedUserEssbaseOptions setting, an administrator can control which Essbase options a user is allowed to set. AllowedUserEssbaseOptions controls the Essbase options that a user is allowed to set.

RetrainOnRetrieval controls whether formulas within the retrieve range are retained when building or refreshing the view and during a retrieve operation.

UserEssbaseOptionsContext controls the caching of the user’s Essbase Options settings. The cache is used to initialize the settings when a view is opened.

This field contains the ID and version number of the Binary artifact that contains the Microsoft Excel template associated with the view. Clicking the ellipses displays the Select Excel Template Binary Artifact dialog containing a list of available Binary Artifacts.

When the user exports the view to Microsoft Excel, each protected worksheet is password protected with the ExportToExcelProtectedWorksheetPassword value in order to prevent a user from unprotecting a worksheet in the Microsoft Excel file.

GridLinesVisible controls whether the grid lines are visible or hidden for template and cascade sheets.

GridLinesVisibleOnDrillthroughSheet controls whether the grid lines are visible on a drillthrough sheet.

RowAndColumnHeadersVisible controls whether row and column headers are are visible or hidden for template and cascade sheets.

RowAndColumnHeadersVisibleOnDrillthroughSheet controls whether row and column headers are visible on a drillthrough sheet.

TabsVisible controls whether sheet tabs are are visible or hidden for template and cascade sheets.

MemberCellDoubleClickAllowedDimensions controls whether the action the MemberDoubleClickPolicy defines is performed only for members that belong to a particular dimension or any dimension. If one or more dimensions are specified, each selected member must belong to a specified dimension for the action to be performed.

Clicking the left mouse on the MemberCellDoubleClickAllowedDimensions ellipses opens an Essbase Login dialog.

Enter a valid user name and password to access the MemberCellDoubleClickAllowedDimensions dialog.

After choosing an Essbase Connection ID, the administrator can choose allowed dimensions from the list.

Example: If the MemberCellDoubleClickPolicy is Zoom and the MemberCellDoubleClickAllowedDimensions is Product;Market, then a Zoom In or Zoom Out operation is performed only when the user double-clicks a member(s) that belong to the Product or Market Dimension.

By default, the value is empty, which indicates that the MemberCellDoubleClickPolicy is performed on members belonging in any dimension.

MemberCellDoubleClickAllowedOrientations controls whether the action defined by the MemberCellDoubleClickPolicy applies to page, column and/or row members.

Example: If the MemberCellDoubleClickPolicy is Zoom and the MemberCellDoubleClickAllowedOrientations is Row, then a Zoom In or Zoo Out operation is performed only when the user double-clicks a row member(s), but not when the user double-clicks a page or column member. By default, the value is ALL, which indicates that the MemberCellDoubleClickPolicy is performed for page, row and column members.

Both the MemberCellDoubleClickAllowedOrientations and MemberCellDoubleClickAllowedDimensions settings are used to control whether the action is performed when the user double-clicks a member cell(s).

MemberCellDoubleClickPolicy controls what happens when the user double-clicks an Essbase member cell with the mouse button.

SelectorConfiguration configures the selectors for the view, including the order the selectors display in the tool bar. Clicking on the ellipses at the SelectorConfiguration row display a Configure Selectors dialog.

In the dialog there are a number of configurable settings for each selector.

The SelectorControlDisplayMode controls whether a docked pane or a modal dialog contains the user-interface control that displays the selectable items. The setting is only applicable to selectors that display the items in a user-interface control, such as a treeview or listbox, when the user clicks the Show button on the selector tool.

The SelectorDockedControlGroupStyle is the layout of the group of dockable selector user interface controls. The setting is only applicable when the SelectorControlDisplayMode is set to DockedControl.

The SelectorDockedLocation is the initial docked location for dockable selector user interface controls. The setting is only applicable when the SelectorControlDisplayMode is set to DockedControl.

SelectorLastUsedItemContext controls the caching of the items selected when the view is built or refreshed. The cache determines the default selected item for the selectors that are assigned a selector list with a DefaultSelectionPolicy of LastUsedItem.

ViewTokens represents the token definitions assigned to the view. Clicking on the ellipses display the Token Editor dialog that allows you to add, remove and edit the available tokens.

The GridContextMenuID is the key to the PopupMenuTool to use as the context menu for the grid control. The GridContextMenuForDrillthroughSheet is the key of the PopupMenuTool to use as the context menu for the grid control when the active worksheet is a drillthrough sheet. Any popup menu that is defined in the toolbars configuration assigned to the ViewToolbarsConfigurationID can be used as the grid context menu.

MergableToolbarsConfigurationID is the ID of the toolbar configuration that defines the view-specific menus and tools. At run-time, the menus and tools are merged with the application menus and tools providing the view with the look of a single set of tools and menus.

ViewToolbarsConfigurationID is the ID of the toolbar configuration that defines the view-specific menus and tools displayed within the view window.

WindowsViewUIObjectTypeID is the object type ID of the Microsoft Windows form that contains the user interface controls used to display the view data. This is a required setting.

For a good step by step example of adding a view, go back and review; Creating a New Essbase Ad Hoc View Definition.