If you ever need to test Analysis Services roles, you can easily do so either by browsing the cube or by means of a query. When browsing a cube through SQL Server Management Studio (SSMS) or Bisuness Intelligence Developer Studio (BIDS), you can select one or more roles to be enforced on data, by clicking the little […]
During one of my current tasks, which was to run the same test on multiple copies of the same database, I needed to setup a flow where I could deploy the database from VS2010 or setup database w/ vsdbcmd run the test (import 5.5 mio facts + 250K dimension elements into a dw model) rename the […]
Sometimes, just sometimes, I plunge right into using a tool without reading too much documentation. This has some advantages and some drawbacks. Trying to decipher error messages without the right background knowledge can be a hard nut to crack. Just now I found myself in one of these rare occasions, where I had to make the […]
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 […]