myObjectiveOLAP
Client
myObjectiveOLAP Client as simple as you want; as powerful as you need
Reporting
myObjectiveOLAP enables cell based reporting of Oracle OLAP data directly within Microsoft Excel. There is a quick conversion process to migrate Express Spreadsheet Addin reports (using the xpCellQDR function) to myObjectiveOLAP.
Data Explorer provides a graphical tool for reporting on OLAP data from a myObjectiveOLAP Server enabled Oracle OLAP database.
User created reports can be executed on creation, and saved for future use. They can be distributed onto other users as a read-only standard report, or as a template for further reports.
Users can schedule a report to run at repeatable future times, and email the resulting report. The results of an overnight batch run can be waiting in your inbox when you arrive at your desk in the morning.
We even support Oracle's standard OLAP data-model so you can use your own reporting tools such as Oracle Business Intelligence Enterprise Edition, or Business Objects. Any SQL client can view your analytical data.
VBA API for Oracle OLAP
myObjectiveOLAP exports functions to Microsoft Excel which can be used by Microsoft's Excel Visual Basic for Applications.
Common VBA functions enable the end user to interact either with the myObjectiveOLAP library itself or to execute commands or retrieve data from the Oracle OLAP database server.
myObjectiveOLAP allows the VBA user to set Options within the Oracle OLAP environment
The myObjectiveOLAP Graphical API allows the VBA user or developer to integrate standard myObjectiveOLAP windows and screens into their own application.
All of these functions provide the capability to create sophisticated Excel templates for bespoke data entry or dashboard screens.
Tools
myObjectiveOLAP contains a number of graphical tools intended to automate and help the end-user or developer.
User Tools
- Data Explorer for reporting on multi-dimensional cubes within your Oracle+OLAP Analytic Workspace.
- Relational Explorer for reporting on relational data.
- Process Manager manage workflows, processes, interfaces.
- Process & Workflow Control create and define Processes, Workflows & Models.
- Dimension Control create dimensions & hierarchies.
- Cube Control create and define cubes and formula variables.
- Application Settings Editor to configure the application.
- Model Creator define OLAP models and statistical calculations.
Developer or DBA Tools
- User Manager, define new application users & assign roles and responsibilities.
- OLAP Console to communicate with Oracle OLAP at the command line
- Edit Create and edit OLAP programs, syntax suggestions, colour coding and do <-> doend highlighting.
- OLAPWebServices Produce dashboards and OLAP Web Services will update them with the lastest information for you.
- Read OLAP Script File to execute a predefined OLAP DML Script
- Session Manager to monitor and kill individual myObjectiveOLAP user sessions
...lots more; check out the manual for all the features
