Comparison of OLAP Servers Wikipedia. The following tables compare general and technical information for a number of online analytical processing OLAP servers. Please see the individual products articles for further information. General informationeditData storage modeseditAPIs and query languageseditAPIs and query languages OLAP servers support. OLAP Server. XML for Analysis. LED Cube running latest ledcubeC3. Bring Microsoft SQL Server 2017 to the platform of your choice. Use SQL Server 2017 on Windows, Linux, and Docker containers. OLE DB for OLAPMDXStored procedures. Custom functions. SQLLINQ1. 4Visualization. JSONREST APIEssbase. Yes. Yes. Yes. Yes. Yes. No. Yes. Smart. View Excel Add. In, Web. Analysis, Financial Reports Cube. Yes. Yes. Yes. Java,1. R1. 6Yes. In the reporting. Yesic. Cube reporting and all XMLA complaint visualization tools like Excel, etc. Yes. Yes. Infor BI OLAP Server. Yes. Yes. Yes. OLAP Rules, Push Rules, Application Engine. ULgJP4dMck/UL9m6IuKqZI/AAAAAAAAD0Y/sFXWT6y_B2w/s1600/T3Desk-3D-Desktop.png' alt='D Cube R2 Software Update' title='D Cube R2 Software Update' />Yes. Yes. No. Application Studio Jedox OLAP Server. Yes. Yes. Yes. Cube Rules, SVS Triggers. Yes. No. Yes. Microsoft Excel, Qlik, Tableau, Jedox Web, Power BINo. Yes. Microsoft Analysis Services. Yes. Yes. Yes. NET1. Yes1. 8Yes1. 9Yes. Microsoft Excel, Share. Point, Microsoft Power BI, and 7. Micro. Strategy Intelligence Server. Yes. No. Yes. Yes. Yes. Yes. Yes Mondrian OLAP server. Yes. Yes2. 1Yes. Yes. Yes2. 2Yes. Yes. Yes 2. Oracle Database OLAP Option. No. Yes2. 4Yes2. Java, PLSQL, OLAP DMLYes. Yes2. 5No SAS OLAP Server. Yes. Yes. Yes. No. No. No. Yes. Web Report Studio SAP Net. Weaver BWYes. Yes. Yes. No. Yes. No. Yes Cognos TM1. Yes. Yes. Yes. Yes. Yes. No. Yes. TM1 WebTM1 Contributor, IBM Cognos Insight, IBM Performance Modeler, IBM Cognos Cafe for Excel, Cognos BI, TM1 Perspectives for Excel. Yes. Yes. Cubes. No. No. No. No. Yes. No. No. Cubes Viewer2. Yes Druid. No. No. Microsoft Outlook Read Receipt Delete Twitter. No. No. Yes. No. No. Superset, Pivot. Yes. Yes. OLAP distinctive featureseditA list of OLAP features that are not supported by all vendors. All vendors support features such as parent child, multilevel hierarchy, drilldown. Data processing, management and performance related features Data modeling features System limitseditOLAP Server cubes measures dimensions dimensions in cube hierarchies in dimension levels in hierarchy dimension members. Essbase3. 4    ASO, 1,0. BSOic. Cube. 2,1. Infor BI OLAP Server  Jedox OLAP Server. Microsoft Analysis Services3. OLAP. Unrestricted In memoryMicro. Strategy Intelligence Server. UnrestrictedaUnrestrictedaUnrestricteda  UnrestrictedaUnrestrictedaUnrestrictedaSAS OLAP Server3. Unrestricteda1. IBM Cognos TM1. UnrestrictedaUnrestricted. Unrestricteda2. UnrestrictedaUnrestricted. Unrestricted. Druid. UnrestrictedaUnrestricted. Unrestricted. Unrestricted. Unrestricted. Unrestricted. Unrestricted abcdefghijk. Please update as unrestricted, is just not possible. SecurityeditOLAP Server. Authentication. Network encryption. On the FlyaData access. Cell security. Dimension security. Visual totals. Essbase. Essbase authentication, LDAP authentication, Microsoft Active Directory. SSLYes. Yes. Yes. Noic. Cube. HTTP BasicForm Authentication, Windows SSO NTLM,KerberosSSLYes. Yes. Yes. Yes. Infor BI OLAP Server. OLAP authentication, Infor Federation Services, LDAP, Microsoft Active Directory. Yes. Yes. Yes. Yes Jedox OLAP Server. Jedox authentication, LDAP, Microsoft Active Directory. SSLYes. Yes. YesMicrosoft Analysis Services. NTLM, Kerberos. SSL and SSPIYes. Yes. Yes. Yes. Micro. Strategy Intelligence Server. Host authentication, database authentication, LDAP,Microsoft Active Directory, NTLM, Site. Minder, Tivoli, SAP, Kerberos. SSL, AES3. 7  Yes. Yes. Yes. Oracle Database OLAP Option. Oracle Database authentication. SSL  Yes. Yes. No. SAS OLAP Server3. Host authentication,SAS token authentication, LDAP, Microsoft Active Directory. Crack 7-Data Card Recovery'>Crack 7-Data Card Recovery. Yes3. 9  Yes. Yes. Yes. IBM Cognos TM1. Builtin, LDAP, Microsoft Active Directory, NTLM, IBM Cognos BI authentication. SSLYes. Yes. Yes. Yes. Druid. Druid Database authentication. SSLYes. Yes. Yes. YesOn the Fly  The ability to define authentication dynamically via programmatic interfaces. New users do not require restarting the server or redefining the security. Operating systemseditThe OLAP servers can run on the following operating systems Note 1 The server availability depends on Java Virtual Machine not on the operating system. Support informationeditSee alsoeditReferencesedit.