This table describes the dimension and member properties for Essbase (ASO) and Essbase (BSO) dimensions and members. Unless noted properties apply to both types of dimensions and members.
Table 43. Essbase (ASO) and Essbase (BSO) Dimension and Member Properties
Label |
Description |
Name |
---|---|---|
Alias |
Enter the alias in the text box. Displays all alias tables defined for the database and all aliases defined for the current member.
|
Alias |
Allow Duplicates In Dimension |
In an outline that allows duplicate member names, select one of the following options to specify member name uniqueness at a granular level:
Note: This setting does not apply to outlines that require unique member names. |
AllowDuplicatesInDimension |
Attribute Type |
Associate an attribute type with the selected member. Create attribute values for attributes assigned to dimension members that you can use to query on and to filter members. Attribute types are:
For example, the attribute type for “Caffeinated” would be Boolean; data values would be True or False. |
AttributeType |
Comment |
Enter a comment for the dimension or member. Comments can contain up to 255 characters. By default, this text box displays the current comment, if one exists. You cannot assign a comment to an attribute dimension or member. |
Comment |
Compression |
Create the selected dimension as the compression dimension. Oracle recommends optimizing aggregate storage databases by compressing the accounts dimension.
Note: This setting only applies to Essbase (ASO) applications. |
Compression |
Consolidation |
Member consolidation properties determine how children roll up into their parents. If the current member is not a dimension or an attribute, select the consolidation operator to assign to the member:
Default Value: + (addition) See also “Calculating Attribute Data” in the Essbase Administration Services Online Help. Note: There are some restrictions with use of consolidation operators in aggregate storage outlines. |
Consolidation |
Currency |
Shown if the selected item is a dimension, and if the dimension is tagged as country. Enter the currency name, for example USD (for US dollars). When preparing a main database outline for currency conversion, you need to assign currency names to the country dimension and its members (for example, assigning dollars to the U.S., Euro to Germany, and so forth). Note: This setting only applies to Essbase (BSO) applications. |
Currency |
Currency Conversion |
If the current member is a member of the accounts dimension and within a currency application, complete the following options. Note: This setting only applies to Essbase (BSO) applications. Currency conversion drop-down list box. Select one of the following currency conversion options to define categories of currency exchange rates.
See “Preparing the Main Database Outline for Currency Conversion” in the Essbase Administration Services Online Help. |
CurrencyConversion |
Currency Category |
If the current member is a member of the accounts dimension and the member requires currency conversion, enter the type of currency conversion required. Currency category types are the names of members of the accounts dimension of the currency database. See also “Assigning Currency Categories to Accounts Members” in the Essbase Administration Services Online Help. Note: This setting only applies to Essbase (BSO) applications. |
CurrencyCategory |
Data Storage |
Select one of the following storage options:
Default Value: NeverShare Note: You cannot use Performance Management Architect to create Hybrid Analysis or Advanced Relational Access cubes. |
DataStorage |
Dimension Solve Order |
Select one of the following solve order options:
You can also specify solve order at the member level. Members that do not have a solve order inherit the solve order of their dimension. For complete information about solve order, see “Calculation Order” in the Essbase Database Administrator's Guide. Note: These settings only apply to Essbase (ASO) applications. |
DimensionSolveOrder |
Dimension Sort Order |
Enter a numeric value that indicates where the dimension should be placed in the Essbase outline. For example, if a dimension should be fourth in the outline, enter: 4 |
DimensionSortOrder |
Expense Reporting |
For an accounts member that is assigned a formula that includes the @VAR or @VARPER function, you can specify Expense or NonExpense to determine how Essbase calculates the difference between actual and budget data. Note: These settings only apply to Essbase (BSO) applications. |
ExpenseReporting |
Format String |
Use format strings, to format the values (cell contents) of Essbase database members in numeric type measures so that they appear, for query purposes, as text, dates, or other types of predefined values. The resultant display value is the cell’s formatted value (FORMATTED_VALUE property in MDX). To use this property, the Typed Measure Enabled property must be selected. This property is applicable to these dimensions and their members: Account, Time, Generic, Currency, Country, and Attribute. Use MDX language to write the format string expression. This is the format: MdxFormat( string_value_expression ) For example, the following format string displays negative cell values as positive values enclosed in parentheses. This expression refers to the MDX function, CellValue(), to access the cell value being formatted. /* Enclose negative values in “(“, “)” */ IIF(CellValue() < 0, Concat(Concat(“(“, numtostr(-CellValue())), “)” numtostr(CellValue())) See the Oracle Essbase Data Administrator's Guide and Oracle Essbase Technical Reference for more information on format strings. |
FormatStringDuplicate (for dimension) FormatString (for members) |
Fully Qualified Shared Member |
In outlines enabled for duplicate member names, displays the qualified name for members with duplicate (non-unique) names. A qualified member name is constructed by prefixing ancestor names to the member name, up to the ancestor that makes the name unique. For example, if the outline has two members named New York, one under State and one under City, the qualified member names include the first ancestor name that differentiates the members from each other: [State].[New York] [City].[New York] |
FullyQualifiedSharedMember |
Hierarchy Type |
For any dimension and parent members of an aggregate storage database, select an option to define a hierarchy type:
Default Value: Stored Note: These settings only apply to Essbase (ASO) applications. For important information about restrictions with using dynamic and stored hierarchies, see “Hierarchies” in the Essbase Administration Services Online Help. |
HierarchyType |
Member Formula ASO |
Enter a formula to associate with the member. Formulas for ASO (aggregate storage) must be in MDX format. For information and other guidelines on developing formulas in MDX, see the Oracle Essbase Technical Reference. Note: The MemberFormula property is deprecated. Importing values for it will result in a warning and the values will be ignored. The ASOMemberFormula property should be used instead for Essbase ASO applications. |
ASOMemberFormula |
Member Formula BSO |
Enter a formula to associate with the member. Formulas for BSO (block storage) must be in the standard Essbase calculation script format. Note that if member names in a formula are surrounded by quotation marks, for example, "Root Beer"+"Cream Soda";, then surround the entire formula with quotations marks ("..."). Failure to do this results in Essbase stripping out the opening and closing quotation marks, for example, Root Beer"+"Cream Soda, making the formula invalid. The correct syntax is: ""Root Beer"+"Cream Soda"" For information and other guidelines on developing formulas in calculation script format, see the Oracle Essbase Database Administrator’s Guide. Note: The MemberFormula property is deprecated. Importing values for it will result in a warning and the values will be ignored. The BSOMemberFormula property should be used instead for Essbase BSO applications. |
BSOMemberFormula |
Member Solve Order |
Specify a number to represent the priority with which Essbase calculates the formulas. The formula on the member that has the highest solve order takes precedence. You can specify a solve order between 0 and 127. Values less than 0 or greater than 127 are reset to 0 and 127 respectively. No warning message is displayed. Default Value: 0 Members that have a solve order of 0 inherit the solve order of their dimension. Members with the same solve order are evaluated in the order in which their dimensions appear in the database outline, unless otherwise specified by the dimension sort order property. Members with no solve order are evaluated after members with a solve order. Note: These settings only apply to Essbase (ASO) applications. For more information, see “Calculation Order” in the Oracle Essbase Administration Services Online Help. |
MemberSolveOrder |
Named Level |
Specify a unique name for a level that can be applied to all logically-related named generations. For example, a named level called Product can apply to all levels containing products. See Working with Named Levels (Essbase (ASO) and Essbase (BSO) Only). |
NamedLevel |
Named Generation |
Specify a unique name to associate related members. For example, a generation called Regional Revenue contains the revenue figures produced in each region. See Working with Named Generations (Essbase (ASO) and Essbase (BSO) Only). |
NamedGeneration |
Period Type |
Specify the kind of time period, such as Base Time Period or Year Time Period |
PeriodType |
Level Usage for Aggregation (For base dimensions.) |
Restricts the levels for base dimensions which can be selected by the view selection engine during aggregation operations. Select one of the following options:
Note: These settings only apply to Essbase (ASO) applications. |
PrimaryLevelWeighting |
Level Usage for Aggregation (For attribute dimensions.) |
Restricts the levels for attributes which can be selected by the view selection engine during aggregation operation. Select one of the following options:
Note: These settings only apply to Essbase (ASO) applications. |
SecondaryLevelWeighting |
Skip Value |
Select an option to determine what Essbase skips, or ignores, during a time balance calculation. You can only specify skip settings if you set the time balance properties as first, last, or average.
Default Value: None |
SkipValue |
Smart List |
Specify a unique name containing alphanumeric and underscore characters, and no special characters or spaces.
When you specify a measure “Type” as text, use a Smart List to map text-based content to measures. Storage and analysis of textual content can be useful when a cell needs to have one of a finite list of textual values; for example, a product may be sold in five different colors. The color is a text measure whose value must be one of the five colors. The colors are a set of text strings mapped to corresponding numeric IDs. These mappings are contained in dimension-level Smart List objects that you create. See Creating Smart Lists and Modifying Smart List Dimension Properties. |
SmartList |
Time Balance |
Select an option to set time balance properties on the accounts dimension.
Note: When you define the value for this property at the parent level, all children automatically inherit the value. Note: These options do not apply to Essbase applications: Fill, Flow, Balance, Weighted Average - Actual Average, Weighted Average, Actual 365. For Essbase application deployments: If Time Balance is set to Balance, the property is sent to Essbase as Last; If Time Balance is set to Flow, it is sent to Essbase as None. Default Value: Existing definition or none |
TimeBalance |
Two Pass Calculation |
Select this check box to calculate a dimension on the second pass through the outline. Note: These settings only apply to Essbase (BSO) applications. |
TwoPassCalc |
Type |
Select an option:
If the type is Text, you must associate this member with a Smart List. If the type is Date, you must associate a date format with this member. Default Value: Numeric |
Type |
UDA |
Enter the UDA name for the selected member. Multiple UDAs must be comma separated; for example: Small Market,New Market. |
UDA |
Variance Reporting |
Select one of the following options to determine how to calculate the difference between actual and budget data. Note: When you define the value for this property at the parent level, all children automatically inherit the value.
Default Value: NonExpense Note: These settings only apply to Essbase (BSO) applications. |
VarianceReporting |