AREA-ALIAS

The AREA-ALIAS terminal in the MaxL language is a shortcut name that you can associate with a specified cube area. The cube area is required to create an Essbase database partition. The area alias is optional.

An area alias is a shorthand name used in the create partition statement for referring to an already-specified member expression that designates which areas of the databases should be partitioned.

Type

name (see MaxL Syntax Notes)

Example

In the create partition statement below, "myalias" is an area-alias for the member expression specified in the area specification. To create area-aliases, enter the alias names after the member expression in each area specification. To specify which area is relevant when mapping members (if applicable), refer to its alias name in the mapped phrase.

create or replace replicated partition sampeast.east
        area '@IDESCENDANTS("Eastern Region"), @IDESCENDANTS(Qtr1)'
to samppart.company at aspen
as admin identified by 'password'
        area '@IDESCENDANTS(East) @IDESCENDANTS(Qtr1)' myalias
        mapped myalias (Year) to (Yr)
update allow validate only;

Note:

All area aliases used in a mapping should be associated with the target (as in the example above), and the direction of member names listed in the mapped clause should go from source to target.

Referenced By

create partition