oracle olap

  • Building an Oracle OLAP Analytic Workspace

    Building an Oracle OLAP Analytic WorkspaceThe previous my article focused on designing OLAP applications. In this article, we walk you through the steps required to build an Oracle OLAP analytic workspace. Recall that an Oracle OLAP analytic workspace contains a collection of dimensions and a collection of cubes, where any given cube contains only the dimensions required to describe the measures in that cube. The analytic workspace also holds other multidimensional objects, such as folders and programs, that are required for an OLAP analysis.

  • Designing an Oracle OLAP Analytic Workspace

    Oracle OLAP Design Process in Analytic Workspace Analytic WorkspaceIn this section, we discuss the features in Oracle OLAP that you should be aware of when designing analytic workspaces. The content here expands on the concepts introduced in our blogs (where those concepts relate to design) and the general design principles discussed in the preceding section. 


    Determining Dimensions from user Requirements

    As mentioned, user requirements must drive the design of Oracle OLAP cubes. This fact is often overlooked in Oracle OLAP design, as the data is sourced from relational tables or views. Often, these tables are part of a data warehouse with a well-defined structure. The structure of the source tables will be an important influence, but the ultimate structure of the OLAP cubes should be driven by user requirements, not the convenience of loading data from the data warehouse, because often the data warehouse design is not reflective of user requirements. Oracle OLAP cubes can be used solely for their cube-organized materialized views to accelerate performance of queries on data warehouses, but they offer much more.

  • Java Development and Oracle OLAP and Essbase

    Using Java API for building Oracle OLAP &Essbase appsOracle offers Java APIs for both Oracle OLAP and Oracle Essbase. These APIs are public, which means that anyone can develop a custom application to work with one of Oracle's OLAP engines. Let's take a closer look at these Java features in my blog.


  • Oracle Application Express (APEX) for Oracle OLAP

    Oracle APEX for Oracle OLAPOracle Application Express (APEX) is a web-based application development and deployment tool that comes with the Oracle Database. Developers can use it to create reliable, secure, and easy-to-maintain web applications. The built-in wizards and functionality make it possible to build applications rapidly using relational and Oracle OLAP data. Since the Oracle OLAP data can be represented as SQL views, it is now easier than ever to report on the Oracle OLAP data. By using conditions on the SQL queries, it is possible to return data without the need to use aggregation functions. This greatly increases the performance of querying and retrieving data.

  • Oracle OLAP and Essbase architecture and components

    Your choice of an OLAP product from Oracle depends in part on your current IT infrastructure. If you are running an Oracle database as a data warehouse, the obvious solution is to add the Oracle OLAP option to your data warehouse. If you have an Oracle database as one source of data or if your organization has only non­Oracle data sources, your choice will depend on the criteria: purpose, buyer, typical end user, data management strategy, and architecture.

  • Oracle OLAP as a Cornerstone of BI

    Oracle OLAP and BIThe five key benefits of an effective OLAP solution: business-focused multidimensional data, business-focused calculations, trustworthy data and calculations, speed-of-thought analysis, and flexible, self-service reporting. Here, we show how Essbase and Oracle OLAP provide these benefits, even though they come at the problem from different points of view.

    Recall that Oracle Essbase was designed to solve the problems of spreadsheet hell and spread marts faced by people in the line of business. It does so by offering an independent multidimensional database that centralizes data from disparate data sources and arranges that data into dimensions that are intuitive for business users.

  • Oracle OLAP Care and Maintenance

    Oracle OLAP Care and MaintenanceBecause Oracle OLAP runs in the Oracle Database kernel, it inherits all the benefits of the Oracle Database. Many things that are normally done to improve performance or troubleshoot the Oracle Database will affect Oracle OLAP as well. Here, we will focus on how to configure, tune, back up, and troubleshoot Oracle OLAP analytic workspaces.


    Configuring and Tuning Oracle OLAP

    Oracle OLAP's multidimensional objects use the same database memory, processes, and storage as any other type of object in the database. As a result, Oracle OLAP benefits from the proper tuning and configuration of the Oracle Database itself. For the most part, if the Oracle Database is running efficiently, Oracle OLAP should be functioning efficiently as well. As with an Oracle database, if the Oracle OLAP design is off, the performance is off, so make sure you validate the design. If the design is bad, no amount of tuning can solve the big problem.

  • Oracle OLAP Examples: Data Warehouse & Financial Data Analyzing

    Oracle OLAP using ExamplesIn this blog, we present some real-world examples of how Oracle OLAP have been used to solve analytic challenges. These examples are assembled from a variety of sources, jjl including published stories and our own experiences. In some cases, we exclude the name of the company to protect its privacy; as you might expect, these companies have gained a competitive advantage and want to preserve this advantage.

    We start by presenting three Oracle OLAP examples. Each example describes a typical challenge that can be addressed using OLAP technology, and then shows how Oracle OLAP or Essbase was used to solve that problem. We do not cover every type of usage, but rather provide a sample of what has been done to give you an idea of the possibilities.

  • Third-Party Reporting Applications for Oracle OLAP and Essbase

    Oracle OLAP and Essbase Third-Party tools for ReportingAll the reporting tools that have been used as examples in my blog are Oracle products. There are also some high-quality third-party reporting tools available for both Oracle OLAP and Oracle Essbase.


    Third-Party Reporting Tools for Oracle OLAP

    Over the years, several products have been able to access the data in Oracle OLAP workspaces. Recently, with all the BI software company consolidations and mergers, the landscape has changed. Several of the smaller independent companies that produced some very good tools are no longer with us, but others have emerged to take their place. The three products we address here are the Simba MDX Provider, ClearView, and Escendo Analyzer. The Simba MDX Provider and ClearView both work with Microsoft Excel, but provide different levels of integration and features. Escendo Analyzer is a stand-alone application that works directly with the Oracle OLAP data.