Lesson: Retrieving Dynamic Calc Members

  To apply styles to Dynamic Calc members in Asymm.xls:

1. Select File, and then Open.

2. From  EPM_ORACLE_HOME/products/Essbase/EssbaseClient/client/sample, open Asymm.xls.

3. To drill up on Actual, in cell C3, double-click the right-mouse button.

4. In cell C3, drill down on Scenario to display all members of Scenario.

   Essbase displays only the Scenario members for Qtr1.

   

5. Select Essbase, and then Options.

6. Select Style.

   You must be connected to the Sample Basic database to display the Style page. See Connecting to a Database.

7. In Members, scroll down until you see Dynamic Calculations.

8. Select Dynamic Calculations, and then click Format .

9. In Font, select Bold Italic.

10. In Color, select Gray.

11. Click OK, and then select Display.

12. In Cells, click Use Styles, and then click OK.

13. Select Essbase, and then Retrieve.

    Essbase displays the data and applies all styles that you set, including the styles set for Dynamic Calc members and the styles you set in Basic Tutorial. You know that the columns for Variance and Variance% are dynamically calculated because Essbase displays these members in gray, bold, italicized font. (Variance and Variance% display a red background because that style was previously set for all members of the Scenario dimension.)

    

14. Close the Asymm.xls file without saving it.