PREFIXID

This Essbase configuration setting enables you to change the prefix in automatically generated 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

See Also

Member IDs