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 Dec 11, 2006

Actions in Analysis Services 2005: The URL Action - Page 3

By William Pearson


Inspect the Operation of the URL Action within the Cube Browser

Once the deployment of the project has been accomplished, we can fully leverage the Browser that the Cube Designer makes available to us. We will do so by taking the following steps:

1.  Click the Browser tab to initialize the Browser for the Designer, as depicted in Illustration 5.

Illustration 5: Click the Browser Tab ...

2.  Once the Browser loads, click the Reconnect button, as shown in Illustration 6.

Illustration 6: Click the Reconnect Button ...

Let’s perform a Browse scenario to ascertain that our URL Action functions as expected. The Analysis Services Browser is an extremely convenient place to accomplish this and other examinations. (More in-depth details about use of the Browser, a formidable tool within itself, are developed within other articles of this series, in sections where the objectives, typically within “verification” procedures, are to examine or analyze values, and other details, within the cube.)

3.  Within the cube tree appearing inside the Metadata pane, expand Measures.

4.  Expand the Reseller Sales folder, as depicted in Illustration 7.

Illustration 7: Exposing Measures within the Cube Tree

5.  Drag the Reseller Sales Amount measure, followed by the Reseller Order Quantity measure, to the area of the Browser canvas marked Drop Totals or Detail Fields Here, as shown in Illustration 8.

Illustration 8: Dragging the Measures to the Browser Canvas ...

6.  Once again inside the Metadata pane, expand the Product folder.

7.  Right-click the Product Categories hierarchy that appears in the expanding tree.

8.  Select Add to Row Area from the context menu that appears, as depicted in Illustration 9.

Illustration 9: Adding the Product Categories Hierarchy to the Cube Browser Row Axis

9.  Expand the Date folder in the Metadata pane,

10.  Expand the Calendar folder that appears.

11.  Expand the Date.Calendar hierarchy that appears within the expanded Calendar folder.

12.  Right-click the Calendar Quarter level that appears.

13.  Select Add to Column Area from the context menu that appears, as shown in Illustration 10.

Illustration 10: Adding Calendar Quarters to the Cube Browser Column Axis

The available Calendar Quarters appear within the browser’s column axis.

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