Lesson: Applying Styles to Parent Members

To indicate which members contain underlying children, you can apply formatting styles to parent members, including those with attributes.

  To apply styles to parent members:

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

  2. Select Essbase, and then Retrieve.

  3. In cell A2, drill down (double-click) on Year.

  4. Select Essbase, and then Options.

  5. Select Style

    Note:

    The Style page is available only when you are connected to a database.

    Essbase displays the Style page.

    In the Members group box, you can define styles for various types of database members, such as parent, child, and shared members.

  6. In Members, select Parent.

    Essbase defines a default color of navy for all parent members.

  7. Click Format to the right of Members.

    Essbase displays the Font dialog box.

  8. In Font style, select Bold Italic, and then click OK.

    Essbase displays an example of the selected style in the Sample box.

  9. Click OK again.

  10. Select Essbase, and then Options.

  11. In Display, under Cells, select Use Styles to enable the styles, and then click OK.

  12. Select Essbase, and then Retrieve.

    Essbase displays parent member names in bold, navy font.

  13. In cell A2, drill down (double-click) on Qtr1.

    Essbase displays Jan, Feb, and Mar in a regular font, because these members do not contain underlying children.

    Styles applied to parent members.

User Reference

Changing Member Name Fonts and Colors