Monthly Archives: May 2011

How to setup basic dimension security in SSAS

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.

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

Posted in Programming | Tagged , , , | 2 Comments

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

Posted in Programming | Tagged , , | Leave a comment