In previous posts we have successfully created a simple cube deployed and processed it. In this post we are now going to add one of the most important […]
Create and edit a data source view in SSAS.
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 […]
SSAS Create a Cube
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 […]
SSAS: Working with dimensions, creating a dimension
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 […]
SSAS: Adding a dimension to a cube
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, […]
SSAS: Manually processing the cube
Occasionally there may be a need to manually process the cube. This would occur when the cube design has not changed but new data has been imported into […]
SSAS: – Implementing Perspectives
A perspective is a very useful feature within SSAS as it allows the designer to mask the underlying complexity of the cube based on the user. The perspective […]
SSAS: browsing the cube
With the cube processed we are now ready to browse or query the cube to fetch some data from it. There are many way of doing this; the […]
SSAS: – Defining a measure
Now that the dimension has been defined we need to add a measure to our cube in order to be able to answer the question “What is distribution […]
SSAS: – Define translation
In previous posts we explored the properties of a cube and some basic tasks that we would need to perform as part of creating and managing a cube. […]