In this article we will show you, How create New Project in SQL Server Analysis Services with example.
Double click on the BIDS application to open the Business Intelligence Development Studio. To create New Analysis Services Project, Please click on the File Menu and then select theProject option as shown in the below screenshot.
Once you click on the Project option then, New Project window will be opened to select the Analysis Service project. Please select Analysis Services Multidimensional and Data MiningProject Template from the available Business Intelligence Templates
Please provide the Project Name and change the location as per your requirement. We just changes the Solution Name and Name only but you can try. Click ok to finish creating new Analysis Services Project.
Folders Seen in SSAS Project
Once we created a New SSAS Project. If you observe the solution Explorer we have the following folders.
- Data Sources: Connection string and credentials. Please refer SSAS Data Sources article to understand, How to create New Data Source in SQL Server Analysis Services.
- Data Source Views: Same like data set. Please refer SSAS Data Source View article to understand, How to create New Data Set in SQL Server Analysis Services.
- Cubes: Helps to create the cube, include measures and measure groups. Please referCreate OLAP Cube in SSAS article to understand, How to create New Cube in SQL Server Analysis Service
- Dimensions: Helps to add database level dimensions, these can be applicable to all the cubes, to access them every cube has to add to their own dimension folders (project level). Please refer Create Dimensions in SSAS article to understand, How to create New Dimensions in SQL Server Analysis Service
- Mining Structures: For the data mining purpose
- Roles: Provides security to the cube like assigning new roles etc.
- Assemblies: If we require any external assemblies to work then add them to this folder
- Miscellaneous: If the cube require any images or documents then add all of them to this folder
