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 Jan 20, 2004

Introduction to MSSQL Server 2000 Analysis Services: Reporting Options for Analysis Services Cubes: ProClarity Professional, Part I - Page 2

By William Pearson

Using ProClarity with an MSAS Cube

We will assume a basic understanding of ProClarity throughout the article, as well as a proper "default" installation of the software in general, as we noted in the introduction above. The article assumes you have access to the MSSQL Server / the MSAS sample cubes, be it via Windows Authentication Mode or Mixed Mode (for purposes of this article, I'm using Windows Authentication). Keep in mind that the multiple potential security configurations in our individual environments may result in some differences in the steps as we proceed.

Initialize ProClarity and Establish Connectivity

The following steps allow us to establish connectivity to the Budget sample cube in the relatively simple scenario we have established for this lesson.

1.  Click the Start button.

2.  Select Programs --> ProClarity.

3.  Select Professional from the Submenu that appears, as shown in Illustration 1.

Illustration 1: Select ProClarity --> Professional

The Welcome dialog appears.

4.  Select the Cube for browsing radio button, as shown in Illustration 2.

Illustration 2: The Welcome Dialog

5.  Click OK.

The Connect ... dialog appears.

6.  Select the appropriate server in the Server selector box.

Use the Find Server search button, if necessary. In a single server configuration, the correct server will likely be the default. Mine is MOTHER1, as shown in Illustration 3.

Illustration 3: Select the Server that Houses the Sample Cubes

We also have the option of selecting a local cube as the data source within this dialog. The Advanced tab extends the dialog to allow for input of a Username and Password, should security requirements dictate the use of authentication of this sort.

7.  Click OK.

The Open Cube dialog appears, as shown in Illustration 4.

Illustration 4: The Open Cube Dialog

The Open Cube dialog lists the MSAS cubes existing on the server. The Connect ... button that appears on the dialog affords us another chance to change servers, as required, to connect to the appropriate cube to meet our needs. We note, in the lower left corner of the dialog, that connection is maintained via Microsoft OLE DB Provider for OLAP Services 8.0.

8.  Select the Budget cube by highlighting it.

I chose the Budget for Part I of our lesson because it has a very straightforward design and a single measure. This means minimal distraction with the structure of the cube, to allow us to focus on ProClarity and its functionality in our first exercises.

9.  Click OK.

We have the option of selecting the desired visualization with which we browse our cube in the next dialog that appears, as shown in Illustration 5.

Illustration 5: Select How You Want to Visualize Your Information Dialog

We will proceed from this point in the following section.

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