SQL Server Analysis Services offers the possibility to create roles, whereby you can manage the access certain users will have to data in the cube(s) on the database. The following is a basic tutorial on how to create a role Limited Access, used to limit the access to the Product dimension of the Adventure Works [...]
Archive for maj 2011
9 maj
How to get SSAS to return the correct currency format.
Although setting the language and collation correctly, it’s not easy to see why a specific MDX would not return the right formatting, in regards to monetary, thousands seperator etc. There is however a way of forcing the language, through a property available on the calculated measure. In the following example, I’ll show that even though [...]
5 maj
How to find what port a service is listening at
In general, this can be used to find the port of any service that you might be interested in. In my case I needed to setup a small testing scenario, involving a PC and a laptop. The PC containing an instance of SSAS that contains the data for the application. So I needed to setup the firewall [...]
