v2:admin:wftreedimension

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.
  • v2/admin/wftreedimension.txt
  • Last modified: 2020/11/26 07:55
  • by pcevli