Mit beskedne bidrag til næste version af SSIS er hermed i hus. I går fik jeg bekræftelse fra Microsoft om, at forslaget har fundet vej til enten næste version eller næste service pack.
In regards to this article about named calculations in SSAS, I had the perculiar finding today, that NULLs are handled somewhat differently than I would have expected. In my case I had constructed a named calculation, just as in the article, by concatenating two columns, both of type string and allowing NULLs. The perculiar part was, that when […]
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 […]
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 […]
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 […]