Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Feb 17, 2004

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

By William Pearson

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.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM