Monthly Archives: May 2011

How to setup basic dimension security in SSAS

Posted on 10/05/2011 by Jens Vestergaard
Share

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 … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

How to get SSAS to return the correct currency format.

Posted on 09/05/2011 by Jens Vestergaard
Share

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 … Continue reading →

Posted in Programming | Tagged , , , | 2 Comments

How to find what port a service is listening at

Posted on 05/05/2011 by Jens Vestergaard
Share

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 … Continue reading →

Posted in Programming | Tagged , , | Leave a comment