In previous posts we have already covered why processing the cube is important, in this post we look at the various processing options available within Analysis Services. The […]

A named query is a query that is executed in real time to fetch data from the underlying table. In many ways it behaves like a view created […]

A named query is a query that is executed in real time to fetch data from the underlying table. In many ways it behaves like a view created […]

In the last post we had finished creating our measure and measure group and in the post before that we created a dimension. However our cube is still […]

Now that we have finished creating a simple cube with a single dimension and a measure we need to deploy the cube to the SSAS engine. Let us […]

A Datasource view is a critical component of a Analysis Services Cube. The data source view is the first point at which object required by the cube get […]

Once the data source and the Datasource view have been created the next step will be to create the actual cube. Within BIDs there is a very useful […]

Now that we have some idea of what a dimension is let’s create one in our DemoCube project. First let’s have a look at all the tables we […]

In this post we now go ahead and add the dimension created in the previous post into the cube. As you can see from the above screen shot, […]