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

A discovery URL has /agent appended to the end. You can use it to log in to the MaxL Client, and to access Essbase from Oracle BI and Data Visualization. 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

  • Command-line Tool (CLI)—Provides a command line interface for common Essbase administrative tasks.

    See Download and Use the Command-Line Interface.

  • Life Cycle Management (LCM)—Backs up Essbase 11g on-premises cubes and artifacts so you can import them to Essbase 19c.

    See Migrate an On-Premises Application Using LCM Utility.

  • Migration Utility—Provides a command line interface for migrating Essbase applications, cubes, artifacts, and users between Essbase instances.

    See Migrate Cloud Service Applications Using Migration Utility.

  • Export Utility—Creates an application workbook, from an existing cube, that you can use to import the cube and its artifacts. Use this to migrate Essbase 11g on-premises cubes to Essbase 19c.

    See Export On-Premises Cubes to Import to the Cloud.

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