Dimensions
Each Dimension contains 4 tabs: Hierarchies, Import, Settings, Properties.
There are some dimensions that have special system meaning
- BusinessProcess
- BusinessRule
1. Hierarchies
- Members can be moved by dragging or dropping in the hierarchy.
- Search a member in the hierarchy by using Search… box.
1.1 Member Properties
-
- Leaf member - Member holds data, can't contain other members
- Parent - Member contains other members (Leafs or Parents)
- Parent leaf - Leaf member for a specific parent (holding data for the parent)
- Group - Parent Group (any Parent ONLY containing leafs)
- Calculated - Values are calculated by formula
- Summarized - Summed aggregations
- Max - Max value when aggregated
- Min - Min value when aggregated
- Average - Average value when aggregated
- Multiplied - Multiplied value when aggregated
- Source - whether it's synchronized with some other data source & where the data is generated.
1.2 Available Members
2. Import
- UPLOAD SOURCE FILE - Select file… button
- MAP COLUMNS TO PROPERTIES
- CONFIGURE IMPORT - Overwrite Description
3. Settings
4. Properties
Display dimension's properties.
Data Type:
- MemberKey : String constant, has to be unique among other dimension members.
- MemberID : Number constant without any decimals, has to be unique among other dimension members, auto generated (can't be set manually).
- BitMap : Integer that represents a set of Boolean values indicating whether the object is picked or not.
- Time follows the ISO-8601 format.
- Format : HH:mm:ss
- Example : 12:00:00
- Date follows the ISO-8601 format.
- Format : yyyy-MM-dd
- Example : 2014-01-01
- DateTime follows the ISO-8601 format and is defined in UTC/GMT time.
- Format : yyyy-MM-ddTHH:mm:ss
- Example : 2014-01-01T12:00:00
- Boolean allows the values “True” or “False”.
- Double : Number with decimals
- Example: 123.4555
- Integer : Positive and negative whole numbers. Specific fields on resources may have additional limitations on the accepted minimum and maximum values. Both examples below are equivalent.
- Minimum value : -2,147,483,648
- Maximum value : 2,147,483,647
- Example : 12345
- Example : 12,345 (results in 12345)
- String : Text as a sequence of characters.