Forget SQL Management Studio, Stick to BIDS

Ok, so lately there has been a decent bit of frustration from our crew about how to deploy a Analysis Services Project from BIDS to XMLA without going into SQL Management Studio and going through that whole mess.  Well my fellow coworker Xander got a solution figured out for this.  One of the other key side effects is that one doesn’t actually need the database/cube itself physically on the box once this is done, but simply the project itself (it helps to have a cube to push to).

First just setup the actual XMLA build process.  To do this click on Tools and then External Tools.

Click on Add and in the Title, Command, Arguments, and Initial Directory enter the following;

  • Title:  Build XMLA- Command: Microsoft.AnalysisServices.Deployment.exe- Arguments: “-enter project name here-.asDatabase” /d /o:....\Project.xmla- Initial Directory: $(ProjectDir)\bin- Check the “prompt for arguments” option.- Check the “output window” option.

When the prompt comes up during execution of the Build XMLA you must remember to enter your project name exactly so that the database name matches.

Select OK and then click on Tools again.  You will now see a Build XMLA option on the Tools menu.

Now open a new project.  Since it is the standard template example, I’m going to open up AdventureWorks.

Make sure just before executing this that you have done a clean build of the project.  Without a build the necessary *.aspDatabase file won’t be available.  Once you have opened and built the solution then click on the Tools -> Build XMLA option.  The argument prompt will appear.  Enter the project name as shown in the image.  Now you should see the output window display the status.

After execution navigate to the project root and you will find the “Project.xmla” file.  Now you’re good to go without fighting with SQL Management Studio all the time, nor needing a physical installation of your database/cube.

del.icio.us Tags: BIDS,SQL Server 2005,Tools,XMLA

Technorati Tags: BIDS,SQL Server 2005,Tools,XMLA

This Week in Newark, New Jersey

So this week I’m in Newark at a client site.  I must admit it is great to get out of the office and see WebTrends‘ Software in action.  In the office it is easy to get overwhelmed with the bugs, the development plan, the client services schedule, the team action, and the list goes on.  It is truly nice to get out and see what all this work actually comes to.

So far I’ve been able to work out some great key tagging strategies and plans for utilization of the warehouse product that we offer.  The reporting capabilities that the client will have, combining their internal technologies with ours, are unsurpassed in the analytics market.  Some of the ideas that I’ve talked about with the client are coming back with me for future prospective enhancements or services offerings.

One piece of software that works surprisingly well with the WebTrends Warehouse is Microsoft’s Reporting Services.  Between WebTrends Analytics and Warehouse, combining the data in SQL Server, and utilizing the Reporting Services Solution as a reporting add on to what is already included in the box pretty much allows a client to slice, dice, and pepper that data anyway they want to create the information they need.

I’m hoping to write up some of the cool solutions that can be built with WebTrends and the other 3rd Party Software out there.  As always, stay tuned and I’ll be posting soon.

Slave Labor != Productivity and Output

Scobleizer goes on a partial rant about slackers.  His correlations are all out of whack.  I’m not even going to link him as I feel he doesn’t need anymore publicity then he already has.

I still strongly agree with the Edwards W. Demming and the “Toyota” crowd.  You don’t slave away to get results, you work smarter.  If you can’t get your job done in a nice solid 6-8 hr day, then a 8-15 hr day of “busting ass” is NOT going to get the product done faster, better, or in a more solid way.  It usually just means there is a better way to get something done sitting around the corner. Sometimes those hours come up, but by all means they should be a rarity and not a commonality at companies.

To paraphrase, if the ground troops can’t do their jobs, the fault lies at the hands of management.  Good leaders can get almost any employee to be a great asset, it is all about positioning, and if that can’t be done those same leaders need to know when to pull the welcoming mat out and send em’ packing.

It sounds harsh, but it really isn’t.