FinanceHub Version 2020.11

Data Submission

Excel templates using the FinanceHub client can submit data back to Oracle OLAP, triggering post-load events such as aggregation, modeling or report generation.  

Full auditing of data submission is easily reportable and the API also allows for rollback of specific or all submissions. (1)

AW Data Loading

Data can be loaded directly into the Analytic Workspace environment without having to pass through the RDBMS layer. Data loads can be scripted and included as Local Processes within the FinanceHub work-flow Process Manager.

Meta-data management

Dimensional and structural maintenance can be scripted or manually maintained directly within the Analytic Workspace engine, without having to pre-populate the RDBMS layer.

User management

FinanceHub Server, handles user creation and rights management specific to an OLAP application.

Process Management

A robust and fully auditable Process Manager executes either Standard or locally defined processes.  

OLAP DML Execution

Local processes can be created using the full Oracle OLAP DML programming syntax to manipulate, load or export your data.  Many legacy applications can take advantage of this with minimal changes to the core business process logic.  Maximizing your ROI.

Data Scoping

Data can be fully scoped to enable or disable access to your business data.

Work Flow

Business processes can be defined based on input actions.

Oracle OLAP standard computability

Once you have built your cubes and meta data, you can enable them for Oracle OLAP standard compatibility for SQL client access, or access from other tools, such as OBIEE, Oracle BI Spreadsheet Addin, or APEX.