Add a level to a cube dimension.

When you press the Add Level or Edit button in section  Dimension and level cube definition , the following dialog is shown:

This dialog is used to add a level to a cube dimension. Each level is composed of the values of its data field.

You must fille the following options:

• Name : This the level name, which must be unique within its dimension.
• Key DB field: Specifies the database field whose values will make this dimension. This field can be used only once in this dimension. Press the Choose Button to show the Select field dialog and choose one.
• Options: Lets you choose global options for this level. See below.
• Add, Edit, Delete: Lets you add properties for this dimension. See below.

Press the OK button to define the level in the dimension or the Cancel button to exit this dialog without defining it.

Level global options

Pressing the Options button will show the level options dialog.

To set global options for this level, you can choose from the following:

• Order: By default, this level members are sorted alphabetically, but you can choose to order them by name, by key or by one of its property values. See below.
• Field: Either you choose by key or by name, you can specify here the database field to use as sorting field.
• Options: These are options that are set to create this level:
  • Unique: The UNIQUE option is used to create this level.
  • Unique Name: The UNIQUE_NAME option is used to create this level.
  • Unique key: The UNIQUE_KEY option is used to create this level.
  • Not related to fact table: The NOTRELATEDTOFACTTABLE option is used to create this level.
• Hide: Makes this level hidden.
• only if: Sets the condition for a member of this level to be hidden:
  • Never : No member is hidden.
  • Only child and blank name: The level is created with the option HIDE_MEMBER_IF ONLY_CHILD_AND_BLANK_NAME
  • Only child and parent name: The level is created with the option HIDE_MEMBER_IF ONLY_CHILD_AND_PARENT_NAME
  • Blank name: The level is created with the option HIDE_MEMBER_IF BLANK_NAME
  • Parent name: The level is created with the option HIDE_MEMBER_IF PARENT_NAME
• Root if: A member of this level is promoted to a root level if:
  • Ignore this option: This level member is never promoted to a root level
  • If parent is blank: The level is created with the option ROOT_MEMBER_IF ROOT_IF_PARENT_IS_BLANK
  • If parent is missing: The level is created with the option ROOT_MEMBER_IF ROOT_IF_PARENT_IS_MISSING
  • If parent is self: The level is created with the option ROOT_MEMBER_IF ROOT_IF_PARENT_IS_SELF
  • Anyone above: The level is created with the option ROOT_MEMBER_IF ROOT_IF_PARENT_IS_BLANK_OR_SELF_OR_MISSING
• Use Ok to set these options, Cancel to close this dialog without changing actual options.

You can add as many specific properties to this level. Each property is set with the following dialog:

• Name: Property name or identifier
• Field DB: Database field whose values are used to create this property.
• Type: Property type. It can be one of the following: REGULAR, ID, RELATION_TO_PARENT  , ORG_TITLE, CAPTION, CAPTION_SHORT , CAPTION_DESCRIPTION, CAPTION_ABREVIATION , WEB_URL, WEB_HTML, WEB_XML_OR_XSL , WEB_MAIL_ALIAS, ADDRESS, ADDRESS_STREET, ADDRESS_HOUSE, ADDRESS_CITY , ADDRESS_STATE_OR_PROVINCE, ADDRESS_ZIP , ADDRESS_QUARTER, ADDRESS_COUNTRY , ADDRESS_BUILDING, ADDRESS_ROOM, ADDRESS_FLOOR, ADDRESS_FAX, ADDRESS_PHONE , GEO_CENTROID_X, GEO_CENTROID_Y, GEO_CENTROID_Z, GEO_BOUNDARY_TOP, GEO_BOUNDARY_LEFT, GEO_BOUNDARY_BOTTOM, GEO_BOUNDARY_RIGHT, GEO_BOUNDARY_FRONT, GEO_BOUNDARY_REAR, GEO_BOUNDARY_POLYGON, PHYSICAL_SIZE, PHYSICAL_COLOR, PHYSICAL_WEIGHT , PHYSICAL_HEIGHT, PHYSICAL_WIDTH, PHYSICAL_DEPTH, PHYSICAL_VOLUME, PHYSICAL_DENSITY, PERSON_FULL_NAME, PERSON_FIRST_NAME, PERSON_LAST_NAME, PERSON_MIDDLE_NAME, PERSON_DEMOGRAPHIC, PERSON_CONTACT, QTY_RANGE_LOW, QTY_RANGE_HIGH , FORMATTING_COLOR, FORMATTING_ORDER, FORMATTING_FONT, FORMATTING_FONT_EFFECTS, FORMATTING_FONT_SIZE, FORMATTING_SUB_TOTAL, DATE , DATE_START, DATE_ENDED, DATE_CANCELED, DATE_MODIFIED, DATE_DURATION , VERSION
• Caption: Title that will appear to the cube users.
• Do you wish to hide this property?: Makes this property level hidden.
• Do you wish to order the level by this property? : If you choose this option, the level members will be sorted by this database field values.
• Use OK to set this property or Cancel to don't apply these values.