While there are
numerous commonly desirable options here, let's create
a quick custom measure, just to get a feel for the process. For
purposes of this example, let's say we want to add a
measure to present a projected across-the-board 6.50 percent increase in the Information
Systems expense amount.
14. Select the Custom Formula
15. Click Next.
The New Measure
Wizard - Step 2 of 2 dialog appears.
16. Type Projected 1998 into the Name box.
17. Type the following simple formula
into the Formula box (or use the tools below it to insert the syntax):
[Measures].[Amount] * 1.065
The New Measure
Wizard - Step 2 of 2 dialog appears, as depicted
in Illustration 5.
The newly added
measure, Projected 1998 appears, under the My Items folder on the
Measures tab, as shown in Illustration 6.
Illustration 6: The Custom Measure
Appears (Circled in Red)
19. Click the Projected 1998 measure
to highlight / select it.
20. Click the Execute button
(circled in Illustration 7) in the main toolbar.
The combined bar chart
/ grid changes to reflect the new measure, as depicted in Illustration 7.
Illustration 7: The Custom Measure
in the Display After Executing
Before we leave this
example, let's do a quick row / column swap.
21. In the Columns area of the
lower Dimension Tool pane, click the Measures member to select
22. Drag Measures over to the
Rows area, dropping it under Store.
23. Select the Store member.
24. Drag Store to the Columns
area, once inhabited by Measures.
The lower section of
the Dimension Tool pane now appears as shown in Illustration 8.
Illustration 8: Swapped Rows and
Column Members - Preparation
We now need to execute
again, to refresh the display.
25. Click the Execute button
The display changes to
reflect the swapped rows and columns, as depicted in Illustration 9.
Illustration 9: Swapped Rows and
Columns After Executing
Swapping rows / columns
might not improve the presentation in this case, but can often be a valuable
tool for analysis / reporting purposes.
26. Drag the Measures and Store
members back to their original positions.
27. Click Execute to refresh
the display, once more.
28. Select File --> Save Book to resave
the Briefing Book.
We will examine
further common navigation features, together with more advanced attributes, in
our next example.