Table Views Spreadsheet Control

Table Views is a Onestream Windows Application only spreadsheet control.  The primary purpose of Table Views is to provide an easier method to creating Dashboards where relational data is required. The use of Table Views in Spreadsheet enables the designer to work in a more flexible environment to design a form or data collection tool. 

Accessed via the OneStream Windows Application Spreadsheet, the Table Views provide a client-based tool to support Dashboard forms. Table Views are not intended as an alternative to other tools, such as the SQL Table Editor or Grid Viewer, Dashboard Components.

Key Use

• Tool kit item for advanced Marketplace or dashboard designers

• Designed to collect records from relational tables, or other sources

• Present the information in the Spreadsheet format

• Utilize client-side functionality, found in the Spreadsheet tool, such as calculations and pick-list validation lists

• Update table records only

Design Considerations

• The current functionality is designed to update records in target tables

• Does not perform inserts, to create new records

• Controlling elements must be designed into the Table View Business Rule by the creator to ensure data integrity, security and performance

Table View Size Considerations

• Spreadsheet support of Table Views depends upon the number of rows and row content

• The Spreadsheet Control does not support paging, therefore all rows and content must be returned

• Performance testing and design expectations is to support approximately 8000 KB of data per Table View.