Three days, more than 100 sessions, on 10 different tracks, Campus Days Denmark has become quite the act in town. I submitted three session abstracts. I was lucky and very delighted, that one of those got chosen. I will be presenting, in cooperation with my colleague Rasmus Reinholdt Nielsen (LinkedIn|Twitter), on the topic Optimizing BI […]
Tag: BI
Preparing for my first public UG presentation
August 23rd will be the day I speak publicly for the first time. The sorry crowd will be members of the Microsoft BI Professionals Denmark User Group, in short MSBIP. See more at http://msbip.dk/ or http://www.linkedin.com/groups?gid=4069528&trk=hb_side_g I will be speaking about how to create a custom assembly, in order to use the power of the relational […]
Reporting Services issue when installing local Domain Controller
Problem: At a client we had to produce a server, in order for us to have a development environment, since they couldn’t spare the server power. Odd situation, but that’s not the point. The point is that, somewhere during the installation process of this server, after installing SQL Server, we noticed that the server wasn’t […]
Rolling period with shell dimension SSAS
Often I meet the business requirement of listing data for the last X months. In this blog post, I will try to give my shot at, how this is done elegantly and with maximum flexibility. We start of backwards and enhance the Data Source View in the cube with a custom Named Calculation called UtilityKey (or whatever you like). […]
SSMS Quick Tip
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 […]