Flexible visual document-based metadata model can be used to represent complex dimension member relations.
Support for multiple cubes with a possibility to transfer data between cubes using cube mappings and formulas. Cells can store decimal, date/time and dropdown selection values. The system can efficiently store large amounts (1×10⁹ values) of data.
High performance computation engine with spreadsheet-like formulas. Support for most common spreadsheet functions. Cube addressing syntax with capabilities to traverse hierarchies and create custom dimension member mappings. Input validation is possible with the 'validate' function.
Create worksheets to enter data manually or display reports. Support for simple charts (lines, columns and bars).
Import or export your data from/to CSV files or build simple CSV reports with several mouse clicks.
Keep a list of users and roles. Fast fine grained access control system allows user rights to be granted for single dimension members. Matrix-authorization concept can be implemented with cell access formulas. Support for decentralized user administration scenarios with limited user-administrator accounts.
Let users collaborate more efficiently by marking dimension members as submitted/accepted/rejected.
Visual Basic scripts for complex imperative data processing and custom functions.
Scriptable import/export functionality. Direct access to relational databases.
Scheduled data exports, imports and script-based jobs.
Implement missing standard spreadsheet functions.
Customize the application with your corporate logo and colors.
The user must explicitly define which aggregates are computed, just like in a common spreadsheet application. This makes computations more predictable and allows for storing data on different hierarchy levels. Egeria is not meant (at least for now) for ad hoc data analytics. You can export a portion of data to analyze it in specialized OLAP software or an office pivot table.
Can partially be implemented with dimension member mappings.
Cell colors and font style are used to indicate validation errors and unsaved data at the moment. Use cell validation formulas to indicate incorrect user input.