Add dimension to the cube.

When you press the Add Dim or Edit  button in section  Dimension and level cube definition , we get to the following dialog:

This dialogo is used to add a dimension to the cube. There are two types of dimension: time dimensions that are related to a database field and regular dimension, which you can add several levels to them.

The options you can fill are:

• Name : This is the dimension in the cube. It must be a unique name between the dimensions.
• Time : Choose this options if this dimension is a time dimension. The time options will be enabled in the lower part of the dialog. To define a time dimension, you need to have database fields of date datatype. If you have date fields and don't want to define a time dimension, you can define functions that normally are in every database like year(date), month(date) or day(date) and use then as regular dimension's levels.
• Grand total level: Choose this option if you want your dimension to have a great total level or not. If you choose this option, the Label field will be enable, whose value will be the value of this level in the cube.
• Grand total label: Name of grand total value in the dimension.
• Database field: If you are defining a time dimension, you must choose a date field to relate it. Use the Choose button to appear the Select field dialogo and choose one. Only date fields will appear. 
• Date parts: You can choose which date parts will be in the time dimension. Only mark the desired parts. By default, parts Year, Month and Day parts are marked.
• Options: This button will show a dialog that will let you choose global options for this dimension:

  

  You can choose either to make this dimension hidden or any one of the options below it:
  • Unique name: The dimension is created with option UNIQUE_NAME
  • Unique key: The dimension is created with option UNIQUE_KEY
  • Not related to fact table : The dimension is created with option NOTRELATEDTOFACTTABLE
  • Allow siblings with same name: The dimension is created with option ALLOWSIBLINGSWITHSAMENAME

Press the OK button to create or update the dimension or Cancel  to exit the dialog without taking any action.