Lesson: Entering Generation and Level Names

You can enter generation or level names directly into a worksheet to retrieve members. The Essbase application designer defines generation and level names for database dimensions in the database outline. Two options enable you to determine which generation and level names are defined in the database:

  To enter generation and level names directly into a free-form report:

  1. Select File, and then New or click New Worksheet icon.

  2. Select Essbase, and then Options.

  3. In Mode, under Retrieval, select Advanced Interpretation, and then click OK.

  4. Enter member names as shown:

    Entering member names in a free-form report.

  5. Enter a generation name as shown:

    Entering a generation name in a free-form report.

    Family is a generation name in the Product dimension. The name is defined in the Sample Basic database.

  6. Select Essbase, and then Retrieve.

    Essbase retrieves data for the member and generation names that you entered. The Family generation name expands to its individual members.

    Result of Free-Form retrieval with generation name.

  7. Change Year to a level name (Lev0,Year).

    Entering a level name in a free-form report.

    Note:

    Do not insert a space between the comma after 0 and the word Year. Generation and level names that are entered directly into a worksheet must be precise.

  8. Select Essbase, and then Retrieve.

    Essbase retrieves data for the level 0 members of the Year dimension, which are the individual months (Jan, Feb, Mar, and so forth).

    Result of Free-Form retrieval with level name

  9. Select File, and then Close.

    Do not save the worksheet.