Properties of the tables

To edit a table, select it in the tree and specify the properties in the Properties section. Assign the table type. This determines the category of the table, its purpose. You can select these table types:

Property	Description
FACTTABLE	Specifies the table as a fact table. Fact tables contain values that are stored in a cube. Fact tables must contain the ID fields of the dimensions and the references to the dimensions.
CHARTOFACCOUNTS	Specifies the table as a chart of accounts dimension. The chart of accounts contains the available accounts.
PERIOD	Specifies the table as a period dimension.
CURRENCYCODE	Specifies the table as the dimension of the currency codes.
CURRENCYRATE	Specifies the table as the fact table of the currency rates.
ANALYTIC	Specifies the table as a common dimension. A common dimension is not further categorized.
YEARPART	Specifies the table as the dimension of the years.
PERIODPART	Specifies the table, that contains the parts of the periods definition (days, weeks, months, quarters).
UNCLASSIFIED	Tables that are not categorized. To bring these tables into further use, the type FACTTABLE or ANALYTIC must be assigned to them.
LOOKUP	This type is automatically assigned to dimensions that are created on basis of the list of known entries of a field.