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.