Tag Archives: SSAS

Run your cubes in Warp Speed – Really Really Fast!

Posted on 01/04/2014 by Jens Vestergaard

So, finally Microsoft came up with a new feature for the MOLAP part of Analysis Services. The community has been hungering for updates ever since the new kid Tabular came around. Now it apears that the SQL Server team has … Continue reading →

Posted in Programming | Tagged , , | 1 Comment

How to Process Multiple Dimensions via BIDS and SSMS

Posted on 31/03/2014 by Jens Vestergaard

m4s0n501 This is one of those tips I need to write down, before I forget… Sometimes Analysis Services acts up and you need to do a process full on all the dimensions in the database. When that happens I usually … Continue reading →

Posted in Programming | Tagged , , | 1 Comment

Teradata based Data Source Views in Analysis Services

Posted on 05/11/2013 by Jens Vestergaard

Now here’s a catch. I was trying all night long to figure out why Visual Studio was hanging on me, every time I wanted to add a Teradata based relational data source. Turns out that the list of available objects … Continue reading →

Posted in Programming | Tagged , , | 3 Comments

Using Powershell to view Partition Slice Information in Excel

Posted on 18/09/2013 by Jens Vestergaard

Challenge In a blog post written by Chris Webb (b|t), years ago, Chris displays how to query the ASSP.DiscoverPartitionSlices(…). I stumbled upon the post while investigating solutions to problems with partition slicing. But since there were about 20 cubes, each containing … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

Using Powershell to create Local Users from AW Customers

Posted on 04/09/2013 by Jens Vestergaard

As a part of my upcomming presentation at SqlSaturday Cambridge, I will probably be needing a lot of users to demo some aspects of security in Analysis Services. Therefore I have created a Powershell script, my first actually, to generate … Continue reading →

Posted in Programming | Tagged , , | 2 Comments