MDX Provider for Oracle OLAP

MDX Provider for Oracle OLAP

Posted by: Simba Technologies

Make better, faster decisions with real-time data from your company's Oracle data warehouse.

Overview

Using your favorite applications like Excel, SAP BusinessObjects, IBM Cognos or MicroStrategy, users can slice, dice, pivot and gain meaningful insight from their data. Relational or Multidimensional data architectures and Disk-based or In-memory storage architectures can navigate drill paths and write back for planning and ?what if? modeling purposes. Companies like Starbucks, GM OnStar, Royal Bank of Scotland (RBS) have used Simba's Solutions for Oracle OLAP for its interactive visualization, predictive modeling and data mining powering them with valuable data to make decisions.Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries ? producing results with speed of thought response times. Take your data analysis to a new level with the latest Excel 2013 functionality, including slicers, spark lines, named sets and drill-through. Direct connectivity to live data means that you don?t have to load a static copy of your data into Excel or a mid-tier server. Critical Excel files are always up-to-date with your current enterprise data. As a client-side driver, it's easy to deploy, cost effective and low maintenance. No additional mid-tier servers or add-ins are needed. No special training is required. If users are familiar with Microsoft Excel PivotTables, accessing Oracle data is the same as Excel connecting to any data source. Product Highlights
  • Native Microsoft Excel PivotTable support for Oracle OLAP
  • Connects leading analytic/reporting apps, including SAP BusinessObjects®, Cognos® Software, MicroStrategy®, and more to Oracle OLAP
  • Complies with OLE DB for OLAP (ODBO) and XML for Analysis (XMLA) specifications

Features

Exposes all Oracle OLAP cube features to BI client tools for analysis.Enables BI features like drill through from summary to source data, advanced date and time filtering, formatting, creation of calculated members on the client, and more.Directly connects to Oracle OLAP without extracting and storing data. Has a client only ODBO installation, or a thin mid-tier installation for XMLA that requires no client software.XMLA installations include monitoring, logging, and other system administrator features.

  • Uses Oracle Database Enterprise Edition Release 11.1.0.7 (or later) server with OLAP Option.
  • SupportsMDX for 1999 and 2005 query language.
  • Supports Windows 32- and 64-bit operating systems, Windows XP SP3/Windows Server 2003 SP2 and later.
Supported BI clients for Simba MDX Provider for Oracle OLAP: ODBO edition:
  • Excel 2007, 2010, 2013
  • arcplan
  • SAP BusinessObjects Analysis, edition for OLAP v3.1
  • Bissantz DeltaMaster

Support

Simba Technologies is the technology leader in data access and analytics software and enables you to access and analyze any data, anywhere, any time. We provide ?the glue? between front-end business intelligence applications and back-end data servers ensuring products interoperate across vendors according to established data standards such as SQL, ODBC, JDBC, ADO.NET OData, XMLA and MDX. As industry's recognized expert in real time, standards based connectivity, our solutions in Big Data and traditional Data Warehouse markets allow connectivity with legacy and next generation Business Intelligence (BI), Analytics, Reporting Tools and other Applications. Companies worldwide like Hortonworks, Google, Intel, Microsoft, Splunk, Tableau, Oracle, and SAP have partnered with Simba to enable seamless connections. Literally, millions of people use our software every day. Headquaters Simba Technologies Inc. 938 West 8th Avenue Vancouver, BC Canada V5Z 1E5. www.simba.com

Solutions@simba.com Phone : +1.604.633.0008 [ext. 3] Fax : +1.604.633.0004 www.simba.com

Recommended Products