Data section of dimensions

When you select a dimension in the tree, the data section shows the corresponding relational table from the repository. You use these tables to define the dimension structure of the multidimensional OLAP database.

In the first column you can view the hierarchical element structure and change it by using a drag-and-drop operation.

The data section of dimensions is divided into two sections:

  1. Data input and administration of the structure (on the left)
  2. Option section (on the right) that includes the tabs Parents, Permissions, and Import, and for the dimensions Accounts and Assets the Financial Budget Derivation tab.

You can hide the option section. The number of columns and the column types vary according to the purpose of the dimension. Many tables contain the columns ID, Data Source ID, English, German, and Spanish for the English, German, and Spanish element names.

There are two types of columns:

  1. Input columns: Specify values directly, or open the input dialog per double-click, or press F4.
  2. Option columns: Double-click, or press F4 to open an option dialog.

In option dialogs you select values that have been specified in other tables. To work with cell values, use the commands Cut, Copy, Paste, and Delete on the shortcut menu. Details regarding the contents of the tables and columns of a specific application may be found in the section about the application and on the Help tab of the data section.

When you specify text in the Filter text box, you restrict the view to elements that contain the string in one of their column titles. Use the buttons Collapse All and Expand All to expand the view of the dimension structure or reduce it to the top-level elements. In the data section you also edit the structure of the dimension. Details regarding the contents of the tables and columns of an application may be found in the relevant section and on the Help tab of the data section.