Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Data Tables

The data tables are used for storing object and fact data that need to be configured by a System Administrator. It resembles a typical SQL Server database table, featuring rows and columns. This is done in the Systems menu. When designing the data tables and link that to specific data containers, the designer then synchronize the setup to the database and actually create physical database tables with the defined setup.

Access Data Tables by selecting System > Data Services > Data Tables:

The Data Tables page displays the list of data tables, as shown below:

Expand the Data Tables to view the linked data containers along with their respective IDs and descriptions.

You can link/unlink the data containers from the data tables grid using the Linked checkbox.

Click Add/Edit data containers to add or edit the linked data containers to the data table.

To create a new Data Table, click Add at the top of the page.

Below is a list of available fields:

Field 

Description

Data Table ID

The unique ID for the Data Table.

For example, dt001

Description

The description of the Data Table.

For example, Financial Data - Actuals

Usage Type

  • Actual Data : This refers to the real, historical data that is collected and stored. It represents the actual performance or results that are achieved.

  • Planning data: This data is used for planning and forecasting. It includes projections, budgets, and other forward-looking information.

  • Custom: This allows for user-defined data types that can be tailored to specific needs or requirements not covered by the standard categories.
Storage Mode

  • Row Store: In this storage mode, data is stored row by row.

  • Column Store: In this storage mode, data is stored column by column.

Storage Location

  • Disk: Data is stored on physical disk drives.

  • Memory: Data is stored in RAM (Random Access Memory).

Published:

Data Tables

The data tables are used for storing object and fact data that need to be configured by a System Administrator. It resembles a typical SQL Server database table, featuring rows and columns. This is done in the Systems menu. When designing the data tables and link that to specific data containers, the designer then synchronize the setup to the database and actually create physical database tables with the defined setup.

Access Data Tables by selecting System > Data Services > Data Tables:

The Data Tables page displays the list of data tables, as shown below:

Expand the Data Tables to view the linked data containers along with their respective IDs and descriptions.

You can link/unlink the data containers from the data tables grid using the Linked checkbox.

Click Add/Edit data containers to add or edit the linked data containers to the data table.

To create a new Data Table, click Add at the top of the page.

Below is a list of available fields:

Field 

Description

Data Table ID

The unique ID for the Data Table.

For example, dt001

Description

The description of the Data Table.

For example, Financial Data - Actuals

Usage Type

  • Actual Data : This refers to the real, historical data that is collected and stored. It represents the actual performance or results that are achieved.

  • Planning data: This data is used for planning and forecasting. It includes projections, budgets, and other forward-looking information.

  • Custom: This allows for user-defined data types that can be tailored to specific needs or requirements not covered by the standard categories.
Storage Mode

  • Row Store: In this storage mode, data is stored row by row.

  • Column Store: In this storage mode, data is stored column by column.

Storage Location

  • Disk: Data is stored on physical disk drives.

  • Memory: Data is stored in RAM (Random Access Memory).

For an optimal Community experience, Please view on Desktop
Powered by Zendesk