Aleady available

Metadata management system

Flexible visual document-based metadata model can be used to represent complex dimension member relations.

Multidimensional database

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.

Computation engine

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.

Views and worksheets

Create worksheets to enter data manually or display reports. Support for simple charts (lines, columns and bars).

Data import and export

Import or export your data from/to CSV files or build simple CSV reports with several mouse clicks.

User access control system

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.

Planned

Workflows

Let users collaborate more efficiently by marking dimension members as submitted/accepted/rejected.

Scripting

Visual Basic scripts for complex imperative data processing and custom functions.

Advanced data import and export

Scriptable import/export functionality. Direct access to relational databases.

Scheduled jobs support

Scheduled data exports, imports and script-based jobs.

Standard spreadsheet functions

Implement missing standard spreadsheet functions.

User interface customization

Customize the application with your corporate logo and colors.

Out of scope for now

Implicit aggregation

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.

Multiple hierarchies

Can partially be implemented with dimension member mappings.

Cell-based formatting and colors

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.