In this article:
Editing Data
When working with table datasets, one can edit records of the following objects:
ODBC data source. It is available only in the desktop application.
NOTE. If there is no primary key set for the table, on the first attempt to edit data the following message is displayed: Editing table without primary key or unique indexes may lead to data loss. To continue editing of table data, click the Yes button. To open the table in the view mode, click the No button.
Operations with data:
Data import. It is available only in the desktop application.
Adding a Record
To add a record as a new table row:
In the web application click the
Add Row button in the toolbar.In the desktop application:
Click the
Insert Record to the Current Position button or 
Insert Record to the End of the Table button the toolbar.Select the Table main menu item and select the variant of adding record to the table:
- Insert Record to the Current Position.
- Insert Record to the End of the Table.
After executing one of the operations, a row is added to the table. Fill empty cells with data.
Data Import
NOTE. It is available only in the desktop application.
To import data to cube, select the Tools > Data Import main menu item.
Changing Record Value
To change entire record value, select the table cell and set a new value using the keyboard.
To change part of record value, open the cell for edit:
In the web application double-click the cell.
In the desktop application click the selected cell.
After executing one of the operations the cell is opened for edit. Change record value.
Navigating by Records
To navigate by records in a table:
In the web application use the mouse or cursor keys on the keyboard.
In the desktop application:
Use the mouse or cursor keys on the keyboard.
To navigate to the first record:
Click the
Move to the First Record button on the toolbar.Select the Table > First Record main menu item.
To navigate to the previous record:
Click the
Move to the Previous Record button on the toolbar.Select the Table > Previous Record main menu item.
To navigate to the next record:
Click the
Move to the Next Record button on the toolbar.Select the Table > Next Record main menu item.
To navigate to the last record:
Click the
Move to the Last Record button on the toolbar.Select the Table > Last Record main menu item.
Refreshing Table Contents
To refresh table contents:
In the web application click the
Refresh Table Contents button on the toolbar.In the desktop application:
Click the
Refresh Table Contents button on the toolbar.Select the Table > Refresh main menu item.
Press F5.
After executing one of the operations table contents is refreshed. Data filtering on refreshing table contents is reset.
Deleting the Current Record
To delete the current selected record:
In the web application click the
Delete Current Record button on the toolbar.In the desktop application:
Click the
Delete Current Record button on the toolbar.Select the Table > Delete Current Record main menu item.
After executing one of the operations the selected record is deleted without operation confirmation.
Clearing Table
To clear a table and delete all records:
In the web application click the
Clear Table button on the toolbar.In the desktop application:
Click the
Clear Table button on the toolbar.Select the Table > Clear Table main menu item.
After executing one of the operations the operation confirmation dialog box opens. If the answer is positive, the table is cleared.