To connect to Microsoft SQL Server Analysis Services, a database connection is needed. If a database connection exist, proceed to Step 2.
If no database connection exist:
In Web Analysis Studio, select File, then New, then Database Connection, then SSAS.
For SSAS Server, User ID, and Password enter the required information and click Next
Select a cube and click Finish.
Enter a database connection name in the Save dialog box.
To create a document, select File, then New, then Document Wizard.
Click Browse and select an SSAS database connection.
Select Auto Populate Dimensions and click Next
From Filters add one or more dimensions toRows.
Double-click a dimension in Rows and select members.
Note: | You can right click a member to use dynamic member selections. |
From Filters add one or more dimensions to Columns
Double-click a dimension in columns and select members
Click Next to select Page members or click Finish to complete.