Microsoft Data Analyzer

Create a View File

1. In Data Analyzer, click New on the File menu.

2. Click Next, and then click Add.

3. In the Name box, type a descriptive name for the view that is easy for you to remember.

4. In the Connection Type area, do the following:

   • If the data for the view is stored on a Microsoft SQL Server 2000 Analysis Services server computer, select the Server option and enter an OLAP server name.

   • If the data for the view is stored in an offline cube file, select the Local Cube option and type the full path to the offline cube file.

   • If the OLAP data is stored on a Microsoft SQL Server 2000 Analysis Services server computer that’s accessible over the Web, click the HTTP option and enter the Web address for the server. Click the Advanced button if you need to provide additional Web connection details.

5. Click the Connect button to connect to the OLAP data.

6. Select the OLAP catalog name in the Catalog list and the OLAP cube name in the Cube list.

7. Click OK to close the Connection Properties dialog box.

8. Click Next.

9. Select the check box next to each dimension you want to initially display in a corresponding dimension pane in Data Analyzer. Click Next.

10. In the Display Type list, select the format in which measures will be initially displayed, either Bars or Grid.

11. In the Length list, select an item that the bar lengths or pie slice sizes will represent.

12. In the Color list, select an item that the bar and pie slice colors will represent.

13. Click Finish. The view file is created, Data Analyzer connects to the source data, and the data view is displayed according to the options you specified.

Reset the View’s Lengths and Colors

• Do one of the following:

  • Close and reopen the view file.

  • Click Default Members on each dimension pane’s toolbar.

  • Right-click a blank area of each dimension pane, point to Go To, and then click Default Members.

Navigate Up and Down a Dimension’s Levels

• Do one of the following:

  • Click the Drill Up or Drill Down buttons to navigate to the next highest or next lowest level.

  • Double-click a member to show the member’s child members.

  • Right-click a blank area in a dimension pane, point to Go To, and then click the specific level’s name.

Change the Bar and Pie Slice Colors

1. On View menu, click Color Scale.

2. If you do not see four buttons at the bottom of the Color Scale dialog box, click the Color Scale dialog box’s Manual button.

3. Click Reset Values According To Data to reset the colors based on the current color scheme settings.

4. Click Automatic Mode. Switch to Manual Goal Settings to display the Min, Mid, and Max boxes. In these boxes, you can specify the minimum, midpoint, and maximum values on which to base the colors. To switch back to having Data Analyzer decide on the meanings of the colors, click the Manual Mode. Switch to Automatic Goal Settings button.

5. Click Change The Meaning Of Green And Red to determine whether low, middle, or high values are “good,” or green.

6. Click Change Color Scheme to determine whether colors are based on filtered members (click Use Highest And Lowest Values Of Significant Selected Members Only) or whether colors are based on all members in all of the dimensions (click Choose Absolute High And Low Values).

Change Which Dimensions Are Displayed and Change What the Colors Represent

1. On the Edit menu, click Change View.

2. To include or remove specific dimension panes, select or clear the appropriate check boxes on the Dimensions tab.

3. Use the controls on the Measures tab to change the type of display and what measures the view’s bar lengths, pie slice sizes, and colors represent.

Define and Use a Template Measure

1. With a view open in Data Analyzer, on the Edit menu, click Change View.

2. On the Template Measures tab, click Add.

3. In the Measure Name box, type a name that is easy for you to remember.

4. Click the Show Internal Syntax option.

5. Construct the custom measure by dragging dimensions, members, tokens, and functions listed in the lower half of the dialog box to the expression box just below the Measure Name box. When you have finished, click OK.

6. On the Measures tab, if the Display Type list is set to Grid, check the box containing the name of the new custom measure. If the Display Type list is set to Bars, select the name of the new custom measure in either the Length or Color list, depending on whether you want the bar lengths or colors to represent the new custom measure.

Use the Business Center

1. Right-click a member or dimension pane, and then click BusinessCenter.

2. Follow the BusinessCenter’s directions to customize a built-in question.

3. When you want to run a BusinessCenter question, click the BC icon next to the question.

Export a Copy of the Information in a Data Analyzer View to an Excel Worksheet

• With the dimension panes and members you want to export visible in Data Analyzer, click Export To Microsoft Excel Workbook on the Tools menu.

Export a Data Analyzer View as a PowerPoint Slide

• With the dimension panes and members you want to export visible in Data Analyzer, click Export To Microsoft PowerPoint on the Tools menu.