• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Microsoft Data Analyzer

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint