Creating a SSAS Project

To create an Analysis Services project by using the Analysis Service Project template

• Open the New Project dialog box, do one of the following:
• On the File menu, select New, and then select Project.
• Press Ctrl+Shift+N, to display the New Project dialog box.
• On the toolbar, click New Project.
• In the New Project dialog box, in the Project types pane, select Business Intelligence Projects.
• In the New Project dialog box, in the Visual Studio installed templates category, select Analysis Services Project.
• In the Name text box, type the name of the project.
• In the Location drop-down list, type or select the folder in which to store the files for the project, or click Browse to select a folder.
• To add the new project to the existing solution, in the Solution drop-down list, select Add to Solution.
• —or—
• To create a new solution, in the Solution drop-down list, select Create new Solution. To create a new folder for the new solution, select Create directory for solution. In Solution Name, type the name of the new solution.
• Click OK.

Creating Analysis Services project by using the  Sql server Management Studio

You can use SQL Server Management Studio to create a new, empty database on an instance of SQL Server Analysis Services.

• To create an Analysis Services database
• Connect to an Analysis Services instance.
• In Object Explorer, expand the node for the connected Analysis Services instance.
• Right-click the Databases node of the Analysis Services instance and select New Database.
• In the New Database dialog box, in Database name, type the name of the new database.
• In Impersonation, provide impersonation information for the new database.
• In Description, type the optional description for the new database.
• Click OK

Creating Analysis Service project based on Existing Analysis service database

To create an Analysis Services project using the Import Analysis Services 9.0 Database template

• On the File menu, select New and then select Project, or press Ctrl+Shift+N, to display the New Project dialog box, or click New Project on the toolbar.
• Select Business Intelligence Projects from the Project types pane in the New Project dialog box.
• Select Import Analysis Services 9.0 Database from the Visual Studio installed templates category of the New Project dialog box.
• Type the name of the project in the Name text box.
• Type or select the folder in which to store the files for the project in the Location dropdown list, or click Browse to select a folder.
• Either select Add to Solution to add the new project to the existing solution in the Solution dropdown list, or select Create new Solution to create a new solution.
• If Create new Solution is selected in Solution, select Create directory for solution to create a new folder for the new solution, then type the name of the new solution in Solution Name.
• Click OK.

Completing the Import Analysis Services 9.0 Database Wizard

• On the Welcome to the Import Analysis Services 9.0 Database Wizard page, click Next.
• On the Source Database page, specify the server and the database from which the wizard will extract the contents and create the Analysis Services project, and then click Next.
• You can either type the database name or query the server to view the existing databases on the server.
• When the wizard finishes extracting the contents of the Analysis Services 9.0 database, click Finish on the Completing the Wizard page.
• Open the Solution Explorer window to view the contents of the project.