My Account | Contact Us   888.537.8135  

MicroStrategy Business Intelligence Solutions

Solutions: MicroStrategy and Oracle

JD Edwards · Peoplesoft · Siebel

Overview | Unique Optimizations | Certifications & Memberships

Unique Optimizations

The MicroStrategy BI platform takes full advantage of Oracle’s highly parallel query processing architecture to deliver the highest performance and efficiency levels.

MicroStrategy’s open architecture truly leverages the capabilities of the Oracle Application Server and OracleAS Portal. MicroStrategy’s deployment-ready portlets require no additional programming when delivering detailed reports and run seamlessly on OracleAS Portal server. This allows users to integrate insight from the MicroStrategy platform into both enterprise portals, with complete OLAP manipulations, as well as sophisticated visualizations via Dynamic Enterprise Dashboards™.

Oracle-specific SQL syntax
  • Analytic functions (OLAP functions)
  • CASE expressions
  • Full outer joins
  • Set operators
  • Sub queries
Multi-pass SQL for analytical sophistication
  • Use of no logging tables
  • Use of global temp tables
  • Use of inline views
  • Use of WITH clause
  • Statistics collection on intermediate results
Integration with key Oracle features
  • Real Application Clusters
  • Materialized views
  • Bit mapped indexes
  • Oracle OLAP option
  • Oracle advanced data types: XML, spatial
Extensions to Oracle functionality
  • Aggregate awareness with physical summary tables
  • Middle-tier caching via Intelligent Cubes
  • Middle-tier report caching
  • Application-level partitioning
Oracle Application Server
  • Web Universal  on Oracle Application Server
  • Java SDK on Oracle Application Server
  • Oracle AS 9.0.3 is certified
OracleAS Portal
  • PIK integration with OracleAS Portal
Supported Web Servers
  • Apache 2.0
  • Apache 1.3.26