Application Properties

Use Performance Management Architect to create Essbase (ASO) and Essbase (BSO) applications, providing reporting based on the dimensionality of Essbase as well as other applications, such as Planning or Profitability and Cost Management.

The following table describes Essbase (ASO) and Essbase (BSO) application properties in alphabetical order. Unless noted, properties apply to both application types. The Label column contains the labels for each property displayed in the Performance Management Architect Property Grid. Use the name displayed in the Property Name column to modify property values using the Performance Management Architect Batch Client. See the Oracle Hyperion Enterprise Performance Management Batch Client User's Guide.

Note:

Essbase (ASO) is also referred to as Enterprise Analytics. Essbase (BSO) is also referred to as Essbase Analytics.

Table 42. Essbase (ASO) and Essbase (BSO) Application Properties

Label

Description

 Property Name

Allow Duplicates in Outline

Select to allow duplicate member names in an outline.

By default, Essbase outlines require that member names are unique. If you want to allow duplicate member names in an existing unique outline, you can select this option to convert the application to allow duplicate members. Once an application is converted, it cannot be changed back to unique.

By default, all dimensions in a duplicate member name application allow duplicate member names. You can clear the “Allow Duplicates in Dimension” option for one or more dimensions in a duplicate member name outline to require unique member names in the dimension.

Default Value: False

AllowDuplicatesInOutline

Attribute Calculations Avg Name

To avoid duplicating names in an outline, you may need to change the name of the Attribute Calculations dimension or its members.

If desired, specify a new name for the Attribute Calculations dimension or a new name for any of the members. The names specified are used in reports and spreadsheets. The function of the member is not affected by the member name. For example, the second member of the dimension counts, regardless of what the name is.

Optional: Specify a new name for the Attribute Calculations Avg member.

Note:

This option only applies to Essbase (BSO) applications.

Default Value: Avg

AttributeCalculationsAvgName

Attribute Calculations Boolean False Name

Optional: Enter the name for all False members of Boolean attribute dimensions; for example, all members with a False value might be named No.

Default Value: False

AttributeCalculationsBooleanFalseName

Attribute Calculations Boolean True Name

Optional: Enter the name for all True members of Boolean attribute dimensions; for example, all members with a True value might be named Yes.

Default Value: True

AttributeCalculationsBooleanTrueName

Attribute Calculations Count Name

Optional: Specify a new name for the Attribute Calculations Count member.

Note:

This option only applies to Essbase (BSO) applications.

Default Value: Count

AttributeCalculationsCountName

Attribute Calculations Date Name

Select the format for names of members of date attribute dimensions:

  • Month First (mm-dd-yyyy)

  • Day First (dd-mm-yyyy)

Default Value: MonthFirst

AttributeCalculationsDateName

Attribute Calculations Dimension Name

Optional: Specify a new name for the Attribute Calculations dimension.

Default Value: Attribute Calculations

AttributeCalculationsDimensionName

Attribute Calculations Max Name

Optional: Specify a new name for the Attribute Calculations Max member.

Note:

This option only applies to Essbase (BSO) applications.

Default Value: Max

AttributeCalculationsMaxName

Attribute Calculations Min Name

Optional: Specify a new name for the Attribute Calculations Min member.

Note:

This option only applies to Essbase (BSO) applications.

Default Value: Min

AttributeCalculationsMinName

Attribute Calculations Range Name

Specify whether the attribute value is the top or bottom value of a numeric range. For example, if Tops of Ranges is selected, with attributes named 1000, 100000, and 1000000, the ranges are 0-1000, 1001-100000, and 100001-1000000.

Select one of the following options:

  • Bottoms of ranges

  • Tops of ranges

Default Value: Tops of Ranges

AttributeCalculationsRangeName

Attribute Calculations Sum Name

Optional: Specify a new name for the Attribute Calculations dimension.

Default Value: Sum

AttributeCalculationsSumName

Auto Configure

Indicates whether or not Essbase automatically determines whether dimensions have a dense or sparse data configuration.

  • True: Essbase automatically sets each dimension as dense or sparse. You cannot manually change the dimension storage type.

  • False: The dense or sparse data configuration can be manually changed.

Note:

This setting only applies to Essbase (BSO) applications.

Default Value: False

Note:

In some cases, if you make changes to the “Auto Configure” property in Performance Management Architect it does not overwrite in Essbase. If you set the “Dimension Storage Type” property in Essbase applications, you must set the "Auto configure" property value to False before you deploy or redeploy the application to Essbase.

AutoConfigure

Case Sensitive

Indicates whether or not members are treated as case sensitive.

  • If the check box is selected:

    Member names are case-sensitive; for example, Product is different from product. Members whose names differ only by case are treated as separate members in all member comparison and search operations. This is the default.

  • If the check box is cleared:

    Member names are case-insensitive.

Default Value: True

CaseSensitive

Comment

Optional: Type a descriptive comment for this application.

Comment

Conversion Method

Select the conversion method to be used during the conversion calculation:

  • Multiply: Multiplies local data values in the main database by exchange rates in the currency database.

  • Divide (the default): Divides local data values in the main database by exchange rates in the currency database.

Note:

This setting only applies to Essbase (BSO) applications.

ConversionMethod

Currency Database

Select a currency database to link to for currency conversion calculations. If no currency database is linked to the current database, the currency database is None.

Note:

This setting only applies to Essbase (BSO) applications.

CurrencyDatabase

Database Name

Type the name of the multidimensional database to be created when this application is deployed.

DatabaseName

Date Format

Select a date format:

  • mon dd yyyy

  • month dd yyyy

  • mm/dd/yy

  • mm/dd/yyyy

  • yy.mm.dd

  • dd/mm/yy

  • dd.mm.yy

  • dd-mm-yy

  • dd month yy

  • dd mon yy

  • month dd, yy

  • mon dd, yy

  • mm-dd-yy

  • yy/mm/dd

  • yymmdd

  • dd Month yyyy

  • dd mon yyyy

  • yyyy-mm-dd

  • yyyy/mm/dd

  • Long Format

  • Short Format

Date measures enable members to be associated with date-type values. The ability to process dates in the measures dimension can be useful for types of analysis that are difficult to represent using the Time dimension.

Select the Typed Measure Enabled property for an application, then select a date format, and add a measure defined as type Date.

The date values are stored internally as numeric values, although you deploy them to Essbase as formatted date strings. When queried, date measures are displayed according to the selected date format.

For more information on date format and date measures, see the Oracle Essbase Database Administrator's Guide.

DateFormat

Prefix/Suffix Format

Select the source of the value that Essbase attaches to the names of members of Boolean, date, and numeric attribute dimensions:

  • None: Uses the complete member name with no prefix or suffix attached; for example, 6000000.

  • Dimension: Attaches the name of the attribute dimension as prefix or suffix to the complete member name; for example, Population_6000000.

  • Parent: Attaches the name of the immediate parent as prefix or suffix to the complete member name; for example, Small_6000000.

  • Grandparent: Attaches the name of the grandparent as prefix or suffix to the complete member name; for example, Population_6000000.

  • Ancestors: Attaches the name of all higher-level generations as the prefix or suffix to the complete member name; for example, Population_Small_6000000.

Default Value: None

PrefixSuffixFormat

Prefix/Suffix Separator

Separator: Select one of the following separators to insert between the prefix or suffix and the attribute member name:

  • _ Underscore: For example, Population_Small_6000000.

  • | Pipe: For example, Population|Small|6000000.

  • ^ Caret: For example, Population^Small^6000000.

Default Value: _ (underscore)

PrefixSuffixSeparator

Prefix/Suffix Value

Select prefix or suffix.

  • Prefix: Attaches the specified prefix before the names of members of Boolean, date, and numeric attribute dimensions; for example, Population_6000000. Prefix is the default value.

  • Suffix: Attaches the specified suffix after the names of members of Boolean, date, and numeric attribute dimensions; for example, 6000000_Population.

Default Value: Prefix

PrefixSuffixValue

Typed Measure Enabled

Select to enable the application for typed measures.

In addition to numeric values, measures can also be associated with text- or date-typed values.

See the Oracle Essbase Database Administrator's Guide and Oracle Essbase Administration Services Online Help for more information on typed measures.

TypedMeasureEnabled

Unicode

Select this check box to migrate an application to Unicode mode.

Caution!

Once an application has been deployed, the Unicode mode setting cannot be undone. See the Oracle Essbase Database Administrator's Guide for information on migrating applications to Unicode Mode.

Default Value: False

Unicode