Using Table Data Manager

Table Data Manager has several features to help you create, read, update, delete, tables and views within OneStream Software.

Identifier	Description
Define	Select a database where your XFC table or XFC view will reside. You can define the metadata for an XFC table or XFC view from this button.
Schema	Select any table or view to see its metadata. For example, you can see the column name, data type, length, and other aspects of the table.
Upload	Select a database. Select the download file containing the metadata for your XFC table or XFC view. The file will be used to create a copy in the SQL Database and the Definitions grid.
Download	Select an XFC table or XFC View to download its metadata to a file. This file can be used during the upload process.
Data	Select any table or view to look at the data.
Import	Select an XFC table to import the data from the export file
Export	Select an XFC table to export the selected data to a file.
Remove	Removes data from the selected XFC table.
Activity	Select database and click Activity to view Active and Blocked transactions.
Statistics	Select a database, table or view group or individual table or view and click Statistics to view the table and view record counts, or specific BI Blend table information.
Create	Select an XFC table or XFC view and click Create to add its definition into the database.
Alter	Select an XFC table or XFC view and click Alter to change its definition into the database.
Drop	Select an XFC table or XFC view and click Drop to remove its definition from the database.
Revive	Select an XFC table and click Revive to restore its definitions from the database.
Copy	Select any table and click Copy to create a mirrored XFC table including data records into table definitions and the database. XFC will be automatically appended as the table name prefix.