Introduction to MSSQL Server 2000 Analysis Services: Reporting Options for Analysis Services Cubes: ProClarity Part II - Page 3

February 17, 2004

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 radio button.

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.

Click for larger image

Illustration 5:  The New Measure Wizard - Step 2 of 2 Dialog

18.  Click Finish.

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 it.

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 once again.

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.