I am pretty serious about this one, not because I believe in UFOs or any other extra-terrestrial theory but because as a DBA who implements Business Intelligence solutions […]
Configure Email Subscriptions in SSRS
In this blog we are going to look at how to configure Email subscriptions in SSRS. Subscriptions like its names suggests is a way for the user to […]
SSAS: – Dimension Hierarchies
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 […]