Technologies

As the first major multidimensional (OLAP) database on the market, Oracle Essbase is almost synonymous with planning, analysis, reporting and simulation. Business professionals can easily build new applications using simple modeling techniques. IT, in turn, profits from the complete administrative and optimization functionality that they expect from a modern database.

Originally designed as an in-memory OLAP databank, IBM Cognos TM1 has set the standard in this field for years. This technology calculates KPIs and aggregates data in record speed. Users can flexibly build powerful data models in this easy-to-administer platform for planning, analysis, reporting and simulation.

Microsoft SQL Server Analysis Services (SSAS), more commonly known as Microsoft Analysis Services, is the OLAP analysis tool of Microsoft SQL Server. Users can create data cubes directly in SSAS to later run complex queries on large quantities of data. With its functionality and interface that closely resembles Excel, cubus outperform provides a simpler way to edit SSAS data and run SSAS operations.

cubus outperform seamlessly integrates in existing SAP environments to pave the way for successful BI and PM applications. The extraction and integration of data from SAP ERP and SAP Business Warehouse environments plays an essential role in channeling all relevant business information into decision-making processes.

Our Technology partners

As the first multidimensional database, Oracle Essbase still sets the standard on the OLAP market. Administrators in business or IT departments use this foundation to build powerful, scalable applications for planning, analysis, reporting and simulation.

Oracle Essbase also serves as an integrated component in the software solution cubus outperform.

Even large data volumes or numbers of users are no match for the ultrafast queries of Oracle Essbase. Interfaces to various data sources are also included in its standard functionality.

Whether you access your data from a spreadsheet, formatted report, powerful ad hoc analysis tool or other data visualizations methods, you always have a consistent view of your company in Oracle Essbase.

For many years Essbase users have sworn by Hyperion Web Analysis as a quick and easy reporting solution.
After Standard Support had already been terminated in April 2015, now Premium Support expired on April 30th, 2017
For all companies that are still using the tool, we have made a list of the most popular features and compared them to the functionalities of the current generation of reporting solutions.
Our fact checker provides you with an overview:

TM1, which became part of the product suite of IBM in 2008, was launched twenty-five years earlier as the first multidimensional in-memory OLAP database. The tool was designed so that business users could easily build powerful, flexible data models.

Through its capabilities to write back data, TM1 provides an ideal platform for analysis, reporting, planning and simulation. Users can run multiple scenarios to test the plausibility of their data in personal work areas called sandboxes.

IBM PA TM1 has been an integrated component of our software solution cubus outperform since 2015. Our experts would be happy to support you in implementing your applications. Get more information about our consulting services here.

Although the development of Microsoft Analysis Services (SSAS) began in 1998, its origins date back two years earlier when Microsoft began to focus on the field of OLAP technologies. In 2005, Microsoft launched a new generation of OLAP technology which it has continually extended and improved ever since.

cubus outperform, which closely resembles Excel in its look, feel and functionality, simplifies how you work with SSAS data. You can implement planning, reporting and analysis applications based on SSAS databases directly in cubus outperform to transform this raw data into useful information. These sophisticated reports of varying complexity combined with simple data-entry meet today’s requirements for a reliable, easy-to-use BI solution.

As a very powerful data engine, SSAS offers various functions for working on a data level as part of its standard functionality. cubus outperform provides the ideal front end for SSAS because virtually any user can work with this data within an Excel-like environment.

Any IT system that supports data-driven decisions should have capabilities for extracting data from SAP systems. The job of the extraction tool is to decode the complexity of the SAP system as well as supply the BI and performance management system with master and transactional data.

Our SAP integration tool for cubus outperform and data warehousing solutions is based on the market-leading integration technology of Theobald Software. More than 2,500 clients worldwide, ranging from midsize companies to large, international corporations, use products from Theobald to connect their IT systems to SAP. This connection is certified by SAP and meets all major security standards in SAP environments.

Depending on the number of relational databases that need to be integrated to cubus outperform, you can choose from two different products:

Xtract Universal directly transfers data from SAP into an Oracle database environment for further processing (e.g. to manage and administer an Oracle Essbase environment).

Both products support a bidirectional interface, which means that you can transfer the final budget data from cubus output back to SAP. Using SAP as a master data source guarantees that you can easily work with the information from your company’s SAP systems.

A partner of Theobald Software, cubus has an experienced consulting team that can assist you with using Xtract software and integrating SAP data.

Xtract Universal enables automated data warehousing for Oracle, Teradata, Infonea from Comma Soft, INFORM and other leading platforms. BI architects can build an optimal, stable, high-performance data stream between SAP and the target environment. Using special ‘push’ functions, you can automatically load your target environment with SAP data without time-consuming ETL modeling. This allows you to deploy a data warehouse out of the box – with no additional middleware tools or configurations necessary.

Benefits for your business:

Choice of eight different extraction types

Central security

Central tracking and process monitoring for complete control over SAP access

Eight different components cover the complete spectrum of data extraction from SAP. Model type-safe data streams with full metadata support in a graphical editor. Perform stable, high-performance mass data extractions with just a few mouse clicks.

Xtract Universal is based on SAP-certified technology and runs on all popular SAP systems.

Architecture:

Xtract Universal is comprised of both a server and client component. The server component performs the actual extraction. The data warehouse communicates with the server component which, in turn, communicates with SAP. Since the server component has no interface, the extractions are configured in Xtract Universal Designer.

A direct interaction between SAP and ADO .NET providers, OLE DB data sources and Excel data sources is also supported.

Xtract IS

Xtract IS ensures a seamless integration between your mySAP or SAP BW system and SQL Server Integration Services. You can perform stable, high-performance mass data extractions with just a few mouse clicks.

The Xtract IS component suite offers a total of nine different components for SQL Server Integration Services and covers the complete spectrum of data extraction from SAP. You can model type-safe data streams with full metadata support in a graphical editor.

Xtract IS Table extracts table data.

Xtract IS Query extracts data from SAP queries.

Xtract IS BAPI calls RFC function models and can serve as a source, target or transformation.

Xtract Report allows you to continue using old ABAP reports including all business information after you have switched to a Microsoft environment.

Xtract IS DeltaQ uses R/3 extractors that are actually reserved for BW systems to implement your own change strategy between a productive R/3 system and SQL Server.

In the first six months more than 100 customers, especially from Europe and North America, have migrated from IBM Executive Viewer to cubus EV. Migration is easy and customers can choose from simple, value-based license and support models.

Migration can be carried out from any IBM Executive Viewer version starting from 5.X to 10.2.1. The effort to migrate is similar to the effort to upgrade from an IBM Executive Viewer version to a newer one.

A trade-in-program for existing IBM Executive Viewer licences exist. The yearly maintenance is calculated based on the list-price of the enabled licenses. If you pay lower maintenance with IBM today, we would consider reducing the amount. You are not obliged to install cubus EV immediately. We will continue to help you with phone support on your current IBM EV version. But if your issue requires a software patch, this could only be solved in a cubus EV version.

Why migrating to cubus outperform EV Anaytics?

These are the reasons:

According to the IBM announcement of April 25th, 2018 IBM Cognos Executive Viewer will no longer be supported until October 2018 (Termination of maintenance services)

Last release IBM Release by end of 2013 according the official end-of-lice letter

No development invest from IBM since years before 2013

With the upgrade on IBM TM1 version 10.2.2 (latest version) the IBM Cognos Executive Viewer will not work anymore (native API deprecated)

These are the breaking changes:

New and modern Ribbon User-Interface, intuitive usage

New graphic engine enables better data visualisation

Commentary function

New functions at calculator

Dynamic subtotals

Data Entry

Alternative hierachies

Subscription

EV Anywhere, Desktop App (active X free Client)

Outstanding vendor support (#1 5 times in a row, according BARC BI Survey 2018)

Here are some references from national and international customers who migrated to cubus outperform EV Analytics:

How to migrate from IBM Executive Viewer to cubus EV

If you install cubus EV on a system where IBM Cognos Executive Viewer is installed, the following steps have to be carried out before the installation.

1. Check the connection information of the installed IBM Cognos Executive Viewer installation. It is important to have the information for the CatalogProvider, the SecurityProvider and the LogProvider configuration. This information can be found in the file EVServer.exe.config.
Please make a backup of the existing configuration file EVServer.exe.config before making any changes.

2. Uninstall the IBM Cognos Executive Viewer Note: This will NOT remove the EVRepository containing all existing items (e.g. views) and permissions.