Most of the time there will be a relationship between different attributes in the dimension. We saw an example of this kind when we created the date dimension […]
SSAS: Working with Dimensions, what is a dimension?
In this post we now create our first dimension. A dimension is the data on which the question is being asked. The purpose of the cube is to […]
SSAS: Working with Dimensions, what is a dimension?
In this post we now create our first dimension. A dimension is the data on which the question is being asked. The purpose of the cube is to […]
SSAS: Securing Analysis Services Part 3
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. […]
SSAS: Securing Analysis Services Part 3
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. […]
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 […]