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 […]
Popular Posts
Trending Posts
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
Recent Posts
Editors Choice
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
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 […]
Taxes Arghh!!! To Ahaa…
Tax season has started and we are half though it, I usually do the accounts for my company or at least keep a close eye on what’s happening […]
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 […]