1. Using Oracle Essbase
  2. Access Oracle Essbase
  3. Set Up Your Client

Set Up Your Client

In the Console, you can download desktop tools to use for administration, import, and export. Set up your local client computer using these tools. Many of your interactions with Essbase originate from your local machine. Be sure you're using the latest versions provided in the Console, as older, previously downloaded versions may not work correctly.

  • Command Line Tools

    Manage, migrate, backup, and recover Essbase applications.

    • 11g Excel Export Utility—Exports Essbase 11g applications to application workbooks. You can use the application workbooks to re-create the applications on the current Essbase version.

      Download dbxtool.zip, and see Export Essbase 11g On-Premises Cubes and About Application Workbooks for details.

    • 11g LCM Export Utility—Exports artifacts from Essbase 11g On-Premise as a .zip file, which you can import in to Essbase 12c or higher. This Life Cycle Management (LCM) utility can also be used to export from, and import to, 11g releases of Essbase. This utility packages into a zip everything you need to support migration to the current version. Download EssbaseLCMUtility.zip, and see the enclosed README for usage details.

      See also Migrate an Essbase 11g On-Premises Application.

    • Command Line Interface (CLI)—A scripting interface that uses REST APIs to perform most common Essbase administrative actions. The CLI includes an LCMImport command you can use for migrating 11g LCM Export Utility .zip files exported from Essbase 11g On-Premise. The LCMExport and LCMImport commands also facilitate migrating applications between instances, on versions 12c or higher.

      Download cli.zip, and see Download and Use the Command-Line Interface.

    • Migration Utility—Utility to manage migration of an entire Essbase instance, for Essbase 12c or higher. In addition to migrating application artifacts, this utility also helps you migrate user role assignments and users/groups from supported identity providers. Download migrationTools.zip, and see the enclosed README for usage details.

      See also Migrate Using Migration Utility.

  • Smart View

    • Smart View for Essbase—Provides a Microsoft Office interface for data analysis. It is the out-of-box query interface for Essbase.

    • Cube Designer Extension—Deploys Essbase cubes from formatted application workbooks. Cube Designer is an add-in to Smart View that enables desktop design of Essbase cubes. It can also be used to deploy cubes from tabular data in an Excel worksheet.

      See Set up Cube Designer.

  • Essbase Administration Services Lite—Optionally manage applications using Essbase Administration Services (EAS) Lite. Although the Essbase web interface is the modern administration interface supporting all of the current platform features, a light version of Essbase Administration Services is a limited-support option for continued management of your applications, in case your company is not ready to adopt the new interface.

    See Use Essbase Administration Services Lite.

  • Essbase Maxl Clients—Provides Linux and Windows clients to enable scripting of Essbase administrative tasks. MaxL is an administrative, language-based interface for managing Essbase cubes and artifacts.

    See Manage Essbase Using the MaxL Client.

  • Essbase Clients—Provides libraries for Essbase C API.

  • Essbase Java API—Enables development of Essbase client tools in Java, and provides libraries, samples and documentation for the Essbase Java API.