PREFIXID

The PREFIXID configuration setting enables you to change the prefix in automatically generated Essbase member IDs to a prefix of your choice.

Syntax

PREFIXID [<appname> [<dbname>]] <prefix>

Description

A member ID is a permanent, unique identifier for a member, separate from its name. All members in a cube's outline have a member ID. When Essbase auto generates member IDs, the IDs follow an incremental naming pattern: id__0, id__1, id__2, etc.

In rare cases, it may be necessary to change the prefix to ensure that it is unique. If the auto generated member ID is already in use by another member name or alias, you can change it, using PREFIXID.

Example

PREFIXID Sample Basic memberid