You use the Information tab to view or modify basic dimension or member information (such as consolidation properties, storage properties, and comments) and to work with alias tables.
The items available on the tab vary, depending on dimension or member type and outline type (block storage, aggregate storage, or currency).
The tab displays multiple nodes. All nodes provide information about the selected dimension or member. Some nodes are read only; some nodes accept entries; some nodes apply to all situations; and some nodes apply to specific situations.
Member information—Dimension and member properties
Qualified member name—Only in Outline Viewer and only for duplicate member name outlines
Qualified member shared name—Only in Outline Viewer, only for duplicate member name outlines, and only for shared members that are associated with base members that have non-unique names
Hybrid Analysis—Only for outlines enabled for Hybrid Analysis
You can select Enabled or Disabled, to enable or disable Hybrid Analysis for the selected member.
To modify a value, select it and, depending upon which of the following boxes is displayed, enter or select a different value.
Name—Enter a dimension or member name. (For details about naming rules, see the Oracle Essbase Database Administrator's Guide.
Comment—For a standard dimension or member, enter a comment. Comments can contain up to 255 characters.
Dimension type—For a dimension within a block storage outline, select None, Accounts, Time, Country, Currency Partition, Currency Type, or Attribute. For a dimension within an aggregate storage outline, select None, Accounts, Time, Date-time, or Attribute.
Attribute type—For an attribute dimension select Text, Numeric, Boolean, or Date.
Associate Format String—If typed measures are enabled in the outline properties, optionally select to create an MDX format string.
Format strings enable you to display more meaningful values in place of raw numeric values. For example, using a text based format string, you might display data cells as “High,” “Medium,” and “Low.”
To associate a format string, use the following syntax:
MdxFormat(string_value_expression)where string_value_expression is a valid MDX string value expression as documented in the Oracle Essbase Technical Reference. For more information about format strings, see “Working with Typed Measures” in the Oracle Essbase Database Administrator's Guide.
Dimension solve order—For a dimension, specify a number (0–127) to represent the priority with which Essbase calculates formulas assigned to the dimension.
Attachment to Base Dimension Level—For a linked attribute dimension, define the member level of the date-time dimension with which the attribute dimension is associated.
Consolidation—For a member that is not a dimension or an attribute, select one of the following consolidation operators: +, –, *, /, %, ~ (ignore), or ^ (non-consoidating) . Addition (+) is the default.
For aggregate storage outlines, restrictions may apply. See “Comparison of Aggregate and Block Storage” in the Oracle Essbase Database Administrator's Guide.
Two-Pass—For a standard member of a block storage outline, select “true” to calculate the member during a second pass through the outline and “false” not to calculate the member during a second pass through the outline.
Compression—For a non-compression dimension, select True to set the dimension as the compression dimension and change the dimension hierarchy to Dynamic (if it was previously stored). All other dimensions are set to False. For the compression dimension, clear the setting to remove the compression attribute from the dimension.
Data storage—Select one of the following options to determine how Essbase stores data values for the current dimension or member: Store Data, Dynamic Calc and Store, or Dynamic Calc. Never Share, Label Only, or Shared Member.
The Dynamic Calc and Store and Dynamic Calc options do not apply to aggregate storage outlines.
Hierarchy—For a dimension or a generation 2 member within an aggregate storage outline, specify the Stored option (the default) or the Dynamic option or, for a dimension within an aggregate storage outline, select the “Hierarchies Enabled” option (which equates to selecting both Stored and Dynamic). The storage option that you select is applied to the hierarchy headed by the dimension or generation 2 member.
The accounts dimension must be dynamic. For information about restrictions associated with dynamic and stored hierarchies, see the Oracle Essbase Database Administrator's Guide.
Variance reporting expense—For an accounts member that is assigned a formula that includes the @VAR or @VARPER function and that is within a block storage outline, you can specify how Essbase calculates the difference between actual and budget data. You select the “false” option to tag the member as non-expense (the default) or “true” to tag the member as expense.