Simba Technologies is the leading supplier of MDX and SQL data connectivity solutions. This FAQ provides more information about our innovative MDX Provider for Oracle OLAP product.
The MDX Provider for Oracle OLAP supports Oracle 11gR1.07 and later. Oracle "OLAP D Patch,” 9147749, is required for production servers running 11.1.0.7, while Oracle “OLAP A Patch,” 9219338, is required for production servers running 11.2.0.1. (Evaluation on unpatched servers is ok, but the OLAP patch provides a number of performance enhancements.)
MDX Provider for Oracle OLAP supports Microsoft Excel 2010 (both 32-bit and 64-bit), Excel 2007 and Excel 2003.
In addition to Microsoft Excel, MDX Provider for Oracle OLAP supports arcplan Enterprise 7 and SAP BusinessObjects Voyager. Support other products from vendors such as Cognos will be added in future releases of MDX Provider for Oracle OLAP.
We invite you to contact us with priority suggestions for support for other client-based BI software.
Yes, you can install MDX Provider for Oracle OLAP on your SharePoint server(s). This allows one version of the truth storage of Excel connections and PivotTables that are hot-refreshable from Oracle OLAP via either Excel Services thin web client or a spreadsheet download. See the whitepaper Using Microsoft Excel and Oracle OLAP with SharePoint Excel Services on the documentation web page for this product.
MDX Provider for Oracle OLAP is licensed directly by Simba Technologies and its partners. For purchasing information, please click here.
For purchasing information, please click here.
Contact Simba Sales at 
.
Yes, the MDX Provider for Oracle OLAP supports value-based hierarchies.
It does with some minor modification of your cube. This is described in the MDX Provider for Oracle OLAP User Manual.
What-if Analysis (write back) is a new feature in Microsoft Excel 2010. Prior releases did not support it. Support for this feature will be added in a future release of the product.
The easiest accessibility would be provided using ADOMD (not ADOMD.NET). This doesn't preclude use of .NET for applications that might want to connect to MDX Provider for Oracle OLAP, only that they must use the ADOMD interface. So, C++ and C# can use this ODBO provider directly.
Contact Amyn Rajan within Simba Technologies () and Bud Endress within Oracle (
).
Additional information is also available here.
MDX Provider for Oracle OLAP uses a stand-alone Windows installer. No separate Oracle client install is needed; an Oracle 'Instant Client' is included in the MDX Provider for Oracle OLAP installer.
Simba Technologies is the de facto independent expert on the MDX query language. Simba is the only company that offers data connectivity solutions for both SQL and MDX.
Founded in 1991, Simba worked on both the ODBC specification and the OLE DB for OLAP (ODBO) and MDX specification with Microsoft. Simba also was a founding member of the XMLA Council, chairing its Interoperability SIG and hosting its InterOp events.
Simba assisted Hyperion in building its MDX and XMLA interfaces. SAP’s MDX interface is also built upon Simba’s technology. Simba is the only independent company with knowledge and technology encompassing Microsoft’s newest MDX enhancements. More than half of all MDX providers in use today were built using Simba’s MDX technology.
