About Flat File Properties
Table 6-3 describes the format of each property in a dimension flat file. For an example of a flat file, see Flat File Sample.
You can include the Essbase Member Solve Order property for a member, but you must add it to the first line of the flat file to show its position.
Note:
The dimension name is given in the first row after any comment rows.
Table 6-3 Properties Defined in a Dimension Flat File
| Property Name | Property Type | Dimension Types | Default Value | Description |
|---|---|---|---|---|
|
Dimension Type |
Dimension |
All |
Regular |
Identifies the dimension type. Valid examples are: Account, Period, Year, Version, Scenario, POV1, POV2, POV3, POV4, Dimension, Attribute, Rule. If there is no property name from this list the default will be "Regular". This position represents the Dimension Name (if Gen1 row) or Member Name. POV orders are as follows: Year/POV1 = 1, Period/POV2 = 2, Scenario/POV3 = 3, Version/POV4 = 4 |
|
Storage Type |
Dimension |
Regular, Account, Entity, POV |
Sparse |
Sparse and Dense |
|
Dimension Name (as Attribute) |
Dimension, Member |
Regular |
none |
When you provide an Attribute Dimension Name in the header, that position represents an associated attribute dimension for the dimension being loaded. Any String in that position is treated as an "attribute member". For example, suppose you specify "My Attribute Dimension" in the header. In the data rows of that file, a String in the same position is assumed to be a member of that attribute dimension. So, you could specify "My Attribute Member1" on the data row for "All Products" and the loader would assign that member to "All Products" as an attribute association. |
|
Comment |
Dimension, Member |
Regular, Account, Entity, Country, POV |
none |
|
|
Hierarchy Type |
Dimension, Member |
Regular, Account, Entity, Country, POV |
Stored |
Enabled, Stored, Dynamic, Disabled |
|
BSO Data Storage |
Dimension, Member |
Regular, Account, Entity, Country, POV |
Never Share |
Label Only, Store, Never Share, Shared, Dynamic Calc And Store, Dynamic Calc |
|
ASO Data Storage |
Dimension, Member |
Regular, Account, Entity, Country, POV |
Never Share |
Label Only, Store, Never Share, Shared |
|
Two Pass Calculation |
Dimension, Member |
Regular, Account, Entity, Country, POV |
N |
True or False are acceptable values (N or Y). |
|
ASO Dimension Formula |
Dimension, Member |
Regular, Account, Entity, Country, POV |
none |
|
|
Member Solve Order |
Member |
Regular, Account, Entity, Country, POV |
none |
In Oracle Essbase, the solve order number determines the order by which members are evaluated in the dimension. You can enter a number between 1 and 120. The member with the highest solve order number is evaluated first (for example, a formula with a solve order number of 20 is evaluated before a formula with a solve order number of 5). Members with the same solve order number are evaluated in the order in which their dimensions appear in the database outline. Members with no solve order number are evaluated after all members with solve order members. |
|
Consolidation Type |
Member |
Regular, Account, Entity, Country |
Not Used |
Add, Subtract, Multiply, Divide, Percent, Ignore, Not Used |
|
UDA |
Dimension, Member |
Regular, Account, Entity, Country |
none |
Single text value or a list of text values (enclosed by comma). When Dimension, the value is a Dimension Name of Type = UDA. When Member, it is a Member of the specified UDA dimension. For example: |
|
Parent |
Member |
Regular, Account, Entity, Country, POV, Attribute |
Identifies the parent member name. If null it means the member is Generation 2. Order matters; a referenced parent must be defined previously. |
|
|
Alias:Alias table |
Dimension, Member |
All |
Examples: "Alias: Default", "Alias: T1" |
|
|
Description |
Dimension, Member |
All |
Optional – no default. |