Home » BI Tools » Analysis Services » Creating a SSAS Cube

Creating a SSAS Cube

A Analysis Services Project/Cube is developed in BIDS which is light weight version of Visual Studio. BIDS is a tool installed on the Server where the Analysis Services Package development is done by using SQL Server Installation Media by chosing Businness Intelligence Development Studio in Installation features.

From BIDS, if you Go to File>New Project you will see various options for Projects. The project related to Analysis Services Project.

Please follow the steps below Analysis Services Cube using the new Cube Wizard that comes with SQL Server 2008 Business Intelligence Development Studio:

Creating an Analysis Services Project:

Creating a Data Source in SSAS

Creating a Data Source View

Creating a Cube in SSAS

At a later point we will cover Creating perspectives

Last Step is to Deploying the Analysis Services Project

Leave a Reply

Your email address will not be published. Required fields are marked *