1 Access Oracle Essbase

Oracle Essbase is a business analytics solution that uses a proven, flexible, best-in-class architecture for analysis, reporting, and collaboration. Essbase delivers instant value and greater productivity for your business users, analysts, modelers, and decision-makers, across all lines of business within your organization.

Access Essbase using credentials supplied by your Service Administrator.

To access Essbase, you must have the following information:

  • URL to access the Essbase web interface
  • User name
  • Password
  • Identity domain to which you belong

After you log in to the Essbase web interface, the Applications page is displayed.

Access Tools and Tasks from the Console

As a user or service administrator, you can access various tools and tasks that you will need.

Users and administrators have access to Console actions from the Essbase web interface. Note that the bold terms below represent the options listed on the Console.

As a non-service administrator user, you can:

  • Download desktop tools that you will install locally and use for administration, import, and export. See Set Up Your Client.
  • Monitor your own user sessions.
  • View database size statistics for applications for which you're a provisioned user.

As a service administrator, you can:

  • Download desktop tools that you install locally and use for administration, import, and export. See Set Up Your Client.
  • Set platform-based email configuration for email notifications of scenario status changes. See Enable Email Notifications for Scenario Status Changes.
  • View Essbase logs. See Use Logs to Monitor Performance.
  • Enable file scanner to scan files and ensure they're virus-free before they're uploaded into Essbase.
  • Monitor and manage all user sessions.
  • View database size statistics for all applications.
  • View agent and server configuration and add Provider Services.
  • Add substitution variables that apply to all Essbase applications. See Use Substitution Variables.
  • View ODBC settings on the server, which can be used for debugging database issues.
  • Enable Performance Analyzer to capture incremental log data according to the interval you set in the Console. See About Performance Analyzer and System Performance Templates.

Essbase, REST, and Smart View Client URLs

Get the URL for the Oracle Essbase instance you are using from your Service Administrator. The basic format of the URL is:

https://IP-address:port/essbase

The default SSL port is 443, unless it was changed during stack creation.

For example:

https://192.0.2.1:443/essbase

Essbase components, such as the Smart View client and the REST API, have their own URLs.

Sample Smart View client URL:

https://192.0.2.1:443/essbase/smartview

You can access Smart View if you have valid credentials. You can also configure the Smart View URL. See Connect to Essbase.

If you have multiple Essbase instances to connect to from Smart View, see Access Multiple Essbase Servers From Smart View.

A Provider Services URL has /japi appended to the end. You can use it to register multiple Essbase instances for centralized URL access. Example:

https://192.0.2.1:443/essbase/japi

A discovery URL has /agent appended to the end. You can use it to log in to the MaxL Client. Example:

https://192.0.2.1:443/essbase/agent

The following is an example of a REST API URL:

https://192.0.2.1:443/essbase/rest/v1

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.