Creating Ledger ID and Ledger Description attributes in Ledger Dimension of each Cube

Ledger ID is the primary key in the Business Model and Mapping layer and must be mapped from the physical layer. Ledger ID is not available as an attribute of Ledger dimension in the Essbase cubes after import. You must manually create Attributes.

  To create the Ledger ID attribute:

  1. Right-click the Ledger Dimension and select Create Columns For Alias Table.

  2. Select LEDGER_ID_ALIAS from the list. Ledger_id is added to all the levels of Ledger Dimension.

    This screen shot displays an example of adding a Ledger ID to list for ledger dimension.

  3. Similarly, add the Default alias (Select Default) in step 2, which provides the Ledger Description.

  4. Default Alias is added to all levels of the Ledger dimension.