Oracle Essbase

  • Automating Databases Processes in Oracle Essbase

    Automating Databases Processes in Oracle Essbase - ESSCMD and MaxLUp to this point in my blog, we have done almost everything in the various user interfaces. We modeled the database in the Essbase Studio console. We used the Administration Services console to view and create load rules, to create a drill- through report, and to create member formulas. We even generated a report (via MDX) using Smart View.

    From a practical deployment perspective, however, most databases processes are automated. After you create the initial database using Essbase Studio (or custom load rules in the Data Prep Editor), you create automation scripts to use these objects in a larger batch process. This blog's article focuses on the command-line capabilities inherent in Essbase.

  • 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 Essbase Care and Maintenance: optimization & backup

    Oracle Essbase optimization and backupIn this blog, we recommend methods for optimizing an Essbase database and backing up data. The recommendations are general in nature, and some may be inappropriate for your particular situation. You should discuss your specific needs with your consultant before implementing any optimizations.


    Optimizing Essbase

    It has been said that tuning an Essbase database depends as much on the chef as it does on the recipe. The optimization process requires more than blindly following a specific set of steps. You need an understanding of the data and the users to be able to select the most appropriate optimizations for your system.

  • Oracle Essbase Examples: ERP Enhancing & Excel Workbook replacing

    Oracle Essbase ExamplesIn this article we present some real-world examples of how Oracle Essbase have been used to solve analytic challenges. These examples are assembled from a variety of sources, 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.

    Each example describes a typical challenge that can be addressed using OLAP technology, and then shows how Oracle 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.

  • 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 Smart Space with Essbase overview

    Oracle Smart SpaceOracle Smart Space, Fusion Edition is a way for people to connect to the whole of the Oracle Business Intelligence Suite Enterprise Edition (OBIEE) stack. It provides direct connectivity to the EPM Workspace (and so to Web Analysis and Financial Reporting documents), OBIEE, and Oracle BI Publisher. Smart Space also provides Essbase developers and administrators easy access to calculations, load rules, and even the status of cubes.

    Rather than needing to go to each of the documents of interest, users of Smart Space have the documents come to them! Smart Space uses gadget technology to serve appropriate content directly to the user.

  • 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.

  • Using Oracle Crystal Ball with Essbase

    Oracle Crystal Ball with EssbaseUncertainty makes strategic planning complex. Removing, or even mitigating, uncertainty can create unlimited business value. However, most companies lack the strategic planning infrastructure to rise above the unknown.

    My previous blog have illustrated how OLAP tools support management processes and provide key stakeholders with relevant, actionable insight for speed-of-thought analysis. Yet while understanding the past through historic data is necessary for sound decision-making, is it sufficient for forward-looking estimates? Making the right decisions requires you to anticipate and plan for possible changes in the future. A common approach to anticipate these changes is to first assess the company's current position by analyzing historical information to understand the company's past. Occasionally, however, there might be very little or no historical precedent. And even if you do have historical data, it might not extrapolate correctly into the future. For example, let's assume your company wanted to launch a new product or compete in a different market. Your company's past and present state can be a good indicator of future performance, but does not guarantee it. The linkage to making the right actionable decisions still requires additional analysis.

  • Using Oracle Essbase Studio powerful features

    Oracle Essbase Studio powerful featuresThe preceding demonstration covered the basic workflow for building, deploying, calculating, and validating an Essbase database. In this blog article, we will address some optional features and more complex functionality available with Oracle Essbase.

    We start by introducing two powerful features available with Essbase Studio: drill-through reports and lineage tracking. Then we move from Essbase Studio to Administration Services. We use the Administration Services console to take a closer look at the anatomy of a load rule and show you how to create custom load rules. We then return to the concept of member formulas, introducing the scripting languages and creating a member formula and a calculation script. We wrap up the section with a look at how to use the built-in reporting languages available with Essbase.