Dimensions Section

The Dimensions section defines the dimensions to be imported. Dimensions defined in this section that do not already exist in the Shared Library or target application are created during import execution. Dimensions that exist in the Shared Library or target application have the property values defined in this section updated during import execution. In this section, you can define a subset or a full set of all the dimension level properties supported in Performance Management Architect. The property names used in the column header line need not precisely match the dimension property names in Performance Management Architect. You can map the property names in the file to their corresponding Performance Management Architect property names in the import profile.

Note:

This section is required and must always be present in a flat file.

Dimension properties are defined in product-specific chapters:

Syntax

!Section=Dimensions

'Name;DimensionClass;Dimension_Property1;... ;Dimension_PropertyN

Parameter

Description

Name

A dimension name, for example, Currency. This parameter is required.

Note:

Dimension names cannot begin with an exclamation point (!).

DimensionClass

The dimension type. For example, Generic. This parameter is required for new dimensions.

Dimension_PropertyX

Dimension level property name.

Example

!Section=Dimensions
'Name;DimensionClass;DimensionAlias
MyCurrency;Currency;Currencies
MyScenario;Scenario;Scenarios
MyEntity;Entity;Entities
MyAccount;Account;Accounts

Example (Importing Dimension Readers and Dimension Writers Properties)

You can use the underscore character (_) to add line breaks when loading dimension writer and dimension reader properties, since the lines can be extremely long. Example of dimension reader properties:

Group1@Native Directory_
PowerUsers@Native Directory_
JSmith@EdenCorp

Note:

Dimension names should follow standard naming practices. See Dimension Naming Restrictions and Naming Restrictions for Dimensions, Members, and Aliases. In addition, Smart List dimension names cannot include special characters, hyphens, or spaces.