Dimensions

Each Dimension contains 4 tabs: Hierarchies, Import, Settings, Properties.

• Members can be moved by dragging or dropping in the hierarchy.
• Search a member in the hierarchy by using Search… box.
• Click on Edit button to edit dimension's hierarchy.
  
• Click on Add Levels button to manage hierarchy levels.
  
• You need to choose from which Process & DataClass you want to do modification on dimension.
  

• Select one member to view this member's property.
  Different members have different property settings.
  
• NodeType
  
  • 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.

Can display MemberID & Level by clicking on button.

• UPLOAD SOURCE FILE - Select file… button
• MAP COLUMNS TO PROPERTIES
• CONFIGURE IMPORT - Overwrite Description
• VALIDATE AND IMPORT - Validate & Import buttons
  

Display dimension's info. here.

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.