1. Scripting Reference for Oracle Essbase
  2. MaxL
  3. MaxL Statements (Aggregate Storage)
  4. Create Outline (Aggregate Storage)

Create Outline (Aggregate Storage)

The MaxL create outline statement for ASO mode helps you create an aggregate storage Essbase outline based on an existing block storage outline.

The outline you are creating must be for an aggregate storage cube that is local to your current login session. The block-storage cube you are using as a source can be remote. If a remote host is specified, you can also specify a user name and password if the connection is remote.

Permission required: Database Manager.

Essbase supports the following scenarios for converting block storage outlines to aggregate storage outlines:

  • Non-Unicode block storage outline to non-Unicode aggregate storage outline

  • Non-Unicode block storage outline to Unicode aggregate storage outline

  • Unicode block storage outline to Unicode aggregate storage outline

The following conversion scenarios are not supported:

  • Unicode block storage outline to non-Unicode aggregate storage outline

  • Aggregate storage outline to a block storage outline

Syntax


Description of creotl.gif follows
Description of the illustration creotl.gif

You can create an outline in the following ways using create outline.

Keywords

create outline...

Create an aggregate-storage cube outline based on a block storage outline. If an outline of the same name already exists, it is replaced.

create or replace outline...

This statement has the same result as create outline above.

at HOST-NAME

If the block-storage cube you are using as a source is remote, specify its discovery URL. For example, "https://myEssbase-myDomain.analytics.us2.example.com/essbase/agent"

as USER-NAME identified by PASSWORD

If the block-storage cube you are using as a source is remote, specify the location. If the connection is also remote (requires a different authentication), provide the user name and password, as you would do when creating a remote partition.

Example

create or replace outline on aggregate_storage database Sample2.Basic2 as outline on database sample.basic;

Creates an aggregate storage outline based on the Sample.Basic outline. For a complete example of how to create an aggregate storage version of a block storage cube, see Creating an Aggregate Storage Sample Using MaxL.