Technologies

cubus outperform uses powerful technologies so you can create measurable business success. cubus EV Analytics, one of the market’s most powerful OLAP analysis tools, runs on leading platforms such Oracle Essbase, Microsoft Analysis Services and IBM Cognos TM1 for ready access to relevant information. Reliable integrators and connectors ensure a secure data transfer between SAP and other sources.

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.

 

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.

If you are looking for a suitable front-end tool, you will find in the Whitepaper useful information about the requirements you should consider for a TM1 environment.

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 in the versions 2005, 2008, 2012 and 2014.

 

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.

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