BIDS Helper

Thursday, December 6, 2007

I know this means I'm quite late writing about it, but I only came about to learn about this Visual Studio.Net add-in quite recently and I wanted to study it for a bit before writing about it. The BIDS Helper is an excellent extension to the BI Development Studio which comes with SQL Server 2005. Though my main uses for it are for the SSAS part of my BI project, the newly released version also has features for SSIS. Among other features for SSAS, the BIDS Helper enables you to: Validate aggregations – checking whether the calculations you defined...

Recreating a Report Model

Wednesday, October 31, 2007

Remember how I taught you to recreate your Analysis Project? Well, let's say this time you have a model you deployed to the Reporting Services Server, but you have changed it since then and want the old version back. So how would you recreate the model you have on the server?  First of all, create a new Data Source View in your Analysis Project. It doesn't have to include all the relevant tables, as you'll only use it as a shell to build upon. After you've finished defining the DSV, save the project. Then, right click the new DSV...

Recreating an Analysis Services Project

Saturday, August 25, 2007

Well, continuing our story about strange things that can happen, I thought I'd share with you this little tidbit. I was taking over a project from someone who had left the company a while back. In the cube that was on the old server, there was an MDX calculation. Only thing was that calculation was missing from the project on the new server (and I admit I couldn't guess what was behind it). So what can you do when you need something that in a project of an old cube? You import the project back to you! The way to do...

Strange things can happen to a cube….

Thursday, August 9, 2007

…like for instance, it could all of a sudden turn into a ball!  J Ok bad computing joke. So this time around I thought I'd tell you about a weird incident I had with my cube. I found out I could see my cube in the Management Studio and even browse it, but when trying to run an MDX on it (again, in the Management Studio) it would tell me I didn't have any cubes for the MDX to run on.. I could still run MDX scripts on it in my SSAS project so I continued as usual, thinking to myself...

Data Dude Service Release 1

Wednesday, August 1, 2007

I'll start by describing Data Dude (or DB Dude) first to all of us who don't use it, now shall I?   It's a tool for the management of databases, enabling you to keep track of version history of a database with a source control on the scripts that build the database. The tool was first introduced to the very talented DBA in my department – Boris Kogan – by Maor David from SRL. Boris was obviously very pleased to have a bit of work and headache saved with this new tool. Just a week ago, Microsoft released the SR1...