Following are the steps to be followed to create a SQL Server Analysis Services (SSAS) Project in Microsoft SQL Server 2005 Business Intelligence Development Studio
Open SQL Server Business Intelligence Development Studio by using the following path: Start->Programs->Microsoft SQL Server 2005->Business Intelligence Development Studio
Open New Project wizard by clicking on New->Project. Following window opens up:
Select ‘Analysis Services Project’. This creates the Analysis Services project in the Solution Explorer as follows:
Defining a Data Source :
Right click on the ‘Data Sources’ folder of the project, and select New Data Source. The DataSource wizard will walk through the complete process of creating a data source.
In the connection Manager Dialog box, select the server name containing the database. Fill in the authentication information, and click OK.
Creating a Data Source View:
Right click on the ‘Data Source Views’ folder in the Solution Explorer, and select new DataSource View.
The following window appears:
It consists of two panes ‘Available Objects’ and ‘Included Objects’. Since, not all tables are needed in the project; you can create a data source view from the data source, which consists of only those tables that are needed in the project.
Click Next. Give a name to the view.
The schema of the view will be displayed as below :
Invoking the Cube wizard:
Right click on the ‘Cubes’ folder on the Solution Explorer, and select New Cube.
Select the option to build the cube using a data source.
Select the DataSource view for the cube.
Identify Facts and Dimensions.
Complete the wizard by giving a name to the cube.
Deploy the cube
Once the cube is designed, it needs to be deployed :
Right click on the Cube, in Solution Explorer, and select ‘Deploy’.
Process the Cube
Right click on your cube, and select ‘Process’.
Browse the cube
Right click the cube, and select Browse.
A sample browse would look like following
Related Posts
- Error while processing OLAP cube in SQL Analysis Services
- Ad hoc Reporting using SQL Server Reporting Services 2005
- DB2 with DotNet and SQL Server Reporting Services
- SQL Server 2005 Components
- Sybase with DotNet Application and SQL Server Reporting Services
Tags: Business Intelligence Development Studio, SQL Server 2005, SQL Server Analysis Services, SQL Server Business Intelligence, SQL Server Management Studio, Step by Step Tutorial
When I try to deploy, I am getting the following error. Please send me your deployment configuration setup, if possible along any other possible configuration with where ever you used userid/password.
My error message”
Unable to connect to localserver : A connection cannot be made. Ensure that the server is running.”
Thanks in advance,
Ramesh (dvrameshusa@gmail.com)
PS: Please e-mail with the solution, if possible.
Do u have SQL Server client version ?