Property Array Section

This section can be used to define multi-value and single value properties for members of a dimension.

For information on product-specific member level properties, see Working with Financial Management Dimensions, Working with Planning Dimensions, Dimension and Member Properties, and Working with Essbase Properties.

Note:

This section is optional.

Syntax

!PropertyArray=Dimension_Name

'Property;Name;Key;Value;

Parameter	Description
Dimension_Name	Name of dimension whose members are being defined.
Property	Name of the property that will be modified. This is a required column.
Name	Name of the member whose property will be modified. This is a required column.
Key	If Property is: UDA—A UDA value. To clear UDA values, leave this field blank and enable the “Clear Before Importing” option for UDA in the profile. Alias—The alias table name or description name. Other—Should always be blank.
Value	If Property is: UDA—Should always be blank. Alias—The alias or description corresponding to the value specified in Key. To clear the Alias value for this member and Key, leave this blank and specify the “Clear Before Importing” option for Alias in the import profile. Other—Property value.

Examples

Defining Alias Property Values

!PropertyArray=Currency
'Property;Name;Key;Value
Alias;EURO;English;European Euro
Alias;EURO;French;
Alias;EURO;German;
Alias;EURO;Italian;
Alias;EURO;Japanese;
Alias;GBR;English;Great Britain Pounds
Alias;GBR;French;
Alias;GBR;German;
Alias;GBR;Italian;
Alias;GBR;Japanese;
Alias;USD;English;United Stated Dollars
Alias;USD;French;
Alias;USD;German;
Alias;USD;Italian;
Alias;USD;Japanese;

Deleting an Alias Value (Value is left blank)

!PropertyArray=Currency
'Property;Name;Key;Value
Alias;EURO;English;

Deleting all Alias Values for a Member (Key and Value are left blank)

!PropertyArray=Currency
'Property;Name;Key;Value
Alias;EURO;;

Defining UDA Property Values

!PropertyArray=Account
'Property;Name;Key;Value
UDA;ExchangeRates;UDA1;
UDA;ExchangeRates;UDA2;

UDA;Plug;UDA1;
UDA;Plug;UDA2;

Deleting all UDA values for a member (Key and Value are left blank)

!PropertyArray=Account
'Property;Name;Key;Value
UDA;ExchangeRates;;

Defining Single-Value Property Values

!PropertyArray=Account
'Property|Name|Key|Value
ACCOUNTTYPE|MemberRev||Revenue
ACCOUNTTYPE|MemberExp||Expense

Performance Management Architect supports single value member properties for dimension imports. It allows a member, property, and value to be entered without a key in either the flat file !PropertyArray section or any of the Property Array interface tables and it is treated as a single-value member property assignment as opposed to an array property. In the interface table, the data would look like:

Load ID	Property	Name	Key	Value
1	ACCOUNTTYPE	MemberRev		Revenue
2	ACCOUNTTYPE	MemberExp		Expense

In the flat file, the !PropertyArray section would look like:

!PropertyArray=Account
'Property|Name|Key|Value
ACCOUNTTYPE|MemberRev||Revenue
ACCOUNTTYPE|MemberExp||Expense

The benefit is that if the ACCOUNTTYPE property was not currently part of your imported data, and you want to start assigning it, is not necessary to add an ACCOUNTTYPE column to your HS_*Member or HS_*Hierarchy tables. In the case of flat file imports, it is not necessary to add an ACCOUNTTYPE column to your generated !Members and !Hierarchies sections.