Dimensions
Dimensions are entities that are analyzed in queries. They are the star points in Star Schema. You can create the number of dimensions you want, always avoiding repeating dimensions in the same data warehouse. Remember you need to save space in disk.
Creating dimensions:
Click the menu Definitions and, then, the submenu Dimensions.
After that, click New and enter:
| • | Name: name for dimension. |
| • | Description: description for dimension. |
| • | Notify: it notifies the import of this dimension data to e-mails configured for this function. |
| • | Automatic Update: By selecting this option, if table-fact refers to some record that does not exist in the dimension, a record with attributes with the description Empty is created in this table. |
1. Click Next to start the creation process of dimension that follows all stages of a dimension creation.
Then, the creation process of dimension goes to the page of attribute creation.