Yesterday I was trying to setup a new Power BI dashboard for our SQL Server Analysis Services logging data. We are running traces on most of our servers, in order to keep up with what is going on – this mainly because all other access to the boxes is restricted. Now, having the data in a…
Tag Archives: SQL Server
Run your cubes in Warp Speed – Really Really Fast!
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 unlocked some underlying functionality in the Windows OS, to enable the MOLAP cubes to operate…
How to Process Multiple Dimensions via BIDS and SSMS
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 turned to Visual Studio Business Intelligence Development Studio [BIDS] or SQL Server Data Tools [SSDT], which…
Speaking at #SQLSatCambridge
Do you sometimes drift off, thinking/dreaming crazy scenarios, that you almost instantly know won’t ever become a reality? I had one of those moments, when I spotted, that #SQLSatCambridge and the NFL game at Wembley between The Pittsburgh Steelers and Minnesota Vikings were scheduled only a day apart. Oh how I wished to be in England…
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)…
