Creating a Cube and Dimension using SSAS
In my previous article, we took an Overview of SSAS and its various components. In this article, we will create a cube by using Business Intelligence Development Studio (BIDS).
We will continue with the example we discussed with SQL Server Integration Services where we created a database with the help of Import Export wizard
1. In the existing solution named DemoBeginning, add an Analysis Services Project and name it DemoCube.
2. In the Solution Explorer, right click on Data Sources and click on New Data Source. This action launches the Data Source Wizard. Connect to the database created earlier named DemoDB. Select the impersonation information as ‘Use the Service Account’. Keep the default name and click Finish.
Tags: design