Having created a server admin and a database admin we now need to add a business user who will have permissions on very specific aspects of the cube. […]
Popular Posts
Trending Posts
Recent Posts
Editors Choice
SSAS: – Securing Analysis Services – Part 2
In the previous posts we added a server level administrator to Analysis services. This administrator was able to make changes to server settings and also make changes to […]
SSAS: – Securing Analysis Services – Part 2
In the previous posts we added a server level administrator to Analysis services. This administrator was able to make changes to server settings and also make changes to […]
SSAS: Processing Options
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 […]
SSAS: Processing Options
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 […]
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 […]
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 […]