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 […]
Named Query in data source view
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 […]
SSAS: Establishing the relationship between the Dimension and the Measure
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 […]
SSAS- Deploying the cube
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 […]
SSAS: – Date dimension
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 […]