Tag Archives: SSAS

Using a Custom Assembly to search an Analysis Services dimension

Posted on 19/06/2012 by Jens Vestergaard
Share

Problem A client of ours had the business requirement that they wanted to be able to search for members in certain dimensions in their cube. In particular two specific dimensions, patients and health care persons (doctors, dentists, nurses etc.). And they … Continue reading →

Posted in Programming | Tagged , , | 2 Comments

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

Memory leak in mdsonar.cpp?

Posted on 07/05/2012 by Jens Vestergaard
Share

One can only guess, but it seems as if there was a memory leak in some method in the mdsonar.cpp file used by Analysis Services. As I was trying to create a cache for a cube, to speed up querying, … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

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

Analysis Services Dimension Security – via AMO

Posted on 25/01/2012 by Jens Vestergaard
Share

As part of a portal our team is currently developing, I needed a way to push permissions set in the portal onto the Analysis Services instances present in the system. A big part of the solution is what we call … Continue reading →

Posted in Programming | Tagged , , , | 1 Comment