Tag Archives: BI

Preparing for my first public UG presentation

Posted on 08/08/2012 by Jens Vestergaard
Share

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

Posted in Programming | Tagged , , , | 1 Comment

Reporting Services issue when installing local Domain Controller

Posted on 29/05/2012 by Jens Vestergaard
Share

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

Posted in Programming | Tagged , , , | Leave a comment

Rolling period with shell dimension SSAS

Posted on 10/05/2012 by Jens Vestergaard
Share

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

Posted in Programming | Tagged , , | 2 Comments

SSMS Quick Tip

Posted on 23/02/2012 by Jens Vestergaard
Share

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

Posted in Programming | Tagged , , , , , , , , | Leave a comment

Julian Date og supplementsmånede

Posted on 12/10/2009 by Jens Vestergaard
Share

Jeg sad og skimmede nettet for smarte tricks til en tidsdimension i et datawarehouse. Jeg faldt over følgende indlæg: http://dylanwan.wordpress.com/data-warehouse-design/design-tip-1-key-for-the-date-dimension/ og fandt det egentlig meget interessant, lige indtil jeg stødte ind i kravet: supplementsmånede. Jeg kan ikke rigtig se, at man … Continue reading →

Posted in Programming | Tagged , , , , | Leave a comment