Table is a repository object, which gives access to physical table on the server. Repository table structure corresponds to the server table structure. Editing repository table data changes respective data stored in the server table.
Depending on the purpose, all tables can be grouped into two main categories:
Dictionary Tables. A dictionary table is the most basic element of a database; it may store values of a single or multiple dimension levels.
Data Storing Tables. The structure of information tables must satisfy certain conditions:
The first N fields for forming cube axes. In these fields, dictionary elements are stored, from which dimensions will be created. Together these fields must provide a unique definition for a table row, which will enables the user further to define data cell in a cube.
The remaining fields for storing cube indicator values. Creation of a separate index speeds up the data processing.
To create a table in the object navigator:
In the web application click the Create button in the main menu and select the object type on the New Object side panel.
In the desktop application:
Execute one of the operations:
Select the Create > Table context menu item.
Click the New Object button in the Create group on the Home ribbon tab and select the Table item.
Select a type of object to be created on the Object Type page.
After executing the operations determine settings on the pages of the table creation wizard:
Basic Settings/Basic Properties. It is used to set object name, identifier and comment.
Properties. A database, in which a table is created, and physical table name are specified.
Parameters. A list of object parameters is created.
Fields. Main table field structure is created.
Indexes. A list of indexes, which will be further used to check data uniqueness, is created.
Constraints. A list of restrictions is created, which will be used to automatically control entered data.
Triggers. A list of triggers is created, which execute certain operations upon specified events.
See also:
Creating Table Data Sets | ITable | Working with Table Data Set