The third part of the solution is based on an OLAP Data Base, to create it  we need to open Visual Studio Data Tools and create a new project using the Analysis Services Multidimensional and Data Mining Project Template.

SSAS creating project

Once created the project we need to add a new Data Source that use the Data Base that we created before (Part I) and that should be filled using the .Net application created in the part II of this series of post.

Connection manager

The next step is to create the Data Source View, in order to do this you need to do right click on the Data Source Views Folder of the solution and follow the wizard selecting the Data Source that was created before.

Your Data Source View should look like this.

Data Source View Twitter

Now we need to create the cube, in order to do this you need to do right click on the Cubes Folder and select new cube and follow the wizard.

Creating a cube 1 Creating a cube 2

We need to select the tables in which we want to create measures, for example count of tweets, users etc.

Creating a cube 3

Creating a cube 6 Creating a cube 5 Creating a cube 4

Your cube design will look like this

Creating a cube 7

Your also need to ensure that your Dimension Usage look like this

Dimension usage

We can see that the Hashtag table has a reference relation with the others dimension through the Tweets dimension.

Now you need to deploy and process your cube, in order to do this you need to do right click on the Cubes name and select Process.

deploy cube

After the cube is deployed you need to process it

processing the cube processing the cube 2

Now you can see your OLAP Data Base and the cube in your Analysis Services Instance using the SQL Server Management Studio.

exploring the cubeBrowsing the cube

In the next post we will see how to use excel to explore the data in the cube.