Technologies

Our Technology partners

Oracle EssbaseOracle Essbase

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.

The fully integrated calculation engine with over 350 pre-defined functions supports a wide spectrum of applications. To fulfill specific requirements, you can also define custom rules ranging from simple aggregations and formulas spanning multiple dimensions to intelligent time-series calculations, powerful financial algorithms or sophisticated forecasting and trend functions.

As a specialist in Oracle Essbase, cubus has implemented countless successful projects over the years. Get more information on our consulting services for Oracle Essbase here.

 

THE FUTURE FOR WEB ANALYSIS USER

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:
 

 

 

 

 

IBM Cognos TM!IBM Cognos TM1

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.

TM1 calculates KPIs and aggregations in reports at turbo speed. The multidimensional in-memory database eliminates the need for time-consuming hard drive access during runtime. The TM1 database comes with IBM Cognos TM1 Turbo Integrator, which provides easy-to-use interfaces to various data sources.

IBM Cognos TM1 provides a fast, easy way to create ad hoc queries as well as predefined reports and tables in Excel.

You can also use cubus outperform EV Analytics as a Web-based, user-friendly tool for ad hoc analysis in IBM Cognos TM1.

IBM Cognos 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.

 

Microsoft AnalysisMicrosoft analysis Services

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.

cubus outperform supports Microsoft Analysis Services versions 2005, 2008, 2012, 2014 and 2016.

 

SAP IntegrationSAP Integration

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 IS allows Microsoft SQL Server users to connect SAP extraction processes directly to Microsoft Integration Services.

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

Xtract Universal offers a fast, easy, user-friendly tool for integrating SAP data in various target environments.

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 IS BW Cube runs BW queries and returns the data as a table.

Xtract IS OHS uses Open Hub Services to extract BW cubes (version 3.5 and up), ODS objects and InfoSource.

Xtract IS Hierarchy extracts hierarchies from SAP BW / BI.

Xtract IS BW Loader transports attributes, text or transaction data to the BW system using an SSIS package.

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.

Migrate from IBM EV to cubus EV

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.

 

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.

3. Uninstall the IBM Cognos Executive Viewer Client (if installed)

4. Uninstall the IBM Cognos Executive Viewer Desktop Explorer (if installed)

5. Install cubus outperform EV Analytics

6. Modify the new EVServer.exe.config with all specific settings that you have configured before. (dataSourceSettings, custom LogProviders, BuiltInAdministrators, …)

If you are using “Local Views”, the view files have to be copied from “My IBM Cognos Executive Viewer Views” to “My EV Views”.

 

Platforms

cubus outperform EV Analytics is a web-based analysis and reporting environment. It is developed to be integrated into today`s Microsoft Windows-based working environments.

All major windows server platforms and windows desktop client environments are supported, including:

Microsoft Windows Server 2003, 2008, 2008 R2, 2012, 2014

Microsoft Windows XP SP3

Windows Vista SP2

Windows 7 SP1

Windows 8 und Windows 10

 

  • Aduno Group
  • Advantest
  • AirPlus International
  • Alcatel-Lucent
  • Die Zieglerschen
  • eplus
  • Energie Südbayern
  • FAUN KIRCHHOFF GRUPPE
  • Knorr-Bremse
  • National-Bank
  • Ritter Sport
  • J. Safra Sarasin
  • Teufel Raumfeld
  • wüstenrot württembergische