Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Posts Tagged ‘bids’

BIDS Helper has been released

Posted by denglishbi on July 27, 2009

Today I was notified that a new release was available for BIDS Helper with the newly added Version Notification that was included with version (BIDS Helper available).

So what is new and what has been fixed?  Good question.  The new functionality that has been added is an SSIS Design Warnings Scanner which is similar to the SSAS AMO Warnings (Best Practice Alerts) that are part of BIDS 2008.  So now you can get Best Practice alerts with SSIS development.  Really coolHot 



This new release also includes fixes for:

So go out and download the latest version – http://bidshelper.codeplex.com and start leveraging all of the features that the BIDS Helper add-in provides for developing SSAS, SSIS, and SSRS solutions with BIDS.

Posted in Downloads | Tagged: , | Leave a Comment »

BIDS Helper available

Posted by denglishbi on May 14, 2009

Just getting caught up on some of my blog readings this morning and came across a posting by Darren Gosbell stating that they have released a new version of BIDS Helper – BIDS Helper release 1.4.1.  The one cool thing is that they have included a version notification into the add-in so that you will be notified now when a new release is available.  Plus there is a feature to synch the description information from a SQL Server relational table or view into your SSAS dimensions (only works with SQL Server and not with named queries in the DSV).  They have also included smartdiff with Reporting Services now tooSmile

Here is a list of the changes that Darren points out in his posting:

This release also incorporates the following bug fixes and enhancements:

If you are not using this yet, do not wait, this is an invaluable addition into the BIDS tool and I highly recommend this for any developer using SSAS, SSIS, or SSRS.  Thanks again guys for putting this together.

One other thing to point out is that the URL references for all CodePlex items has changed so that what used to be http://codeplex.com/bidshelper is now http://bidshelper.codeplex.com.  The old URLs are still working now, but just wanted to point this out, because this might not always be the case.

Posted in Downloads | Tagged: , | 1 Comment »

BIDS Helper 1.4 Released

Posted by denglishbi on January 29, 2009

Just wanted to let everyone know that a new release came out this week.  Check out the add-in for BIDS out on CodePlex here – BIDS Helper.  The new features include the following (along with a few enhancements):

Release 1.4 contains a number of new features:

    And it contains a number of enhancements and bug fixes:

  • Integration Services
      • As you can see there are a couple of features for Reporting Services nowSmile  You can see how datasets are being used and also which ones are not.  Even an option to delete those cached dataset files from within BIDSOpen-mouthed  SSIS now has a documentation report that you can generate to get some high-level information to for the packages.  I see that there has been one source code change since the release, so if you want to be on the latest and greatest then check out the source code section.

        Posted in Downloads | Tagged: , | Leave a Comment »

        BIDS Helper available on CodePlex

        Posted by denglishbi on August 17, 2008

        Just doing a little blog reading this morning and noticed that Darren Gosbell posted an entry yesterday stating that version 1.3 of BIDS Helper is now available for download.  Some of the new features that are available which I briefly mentioned in my last posting about BIDS Helper are support for SQL Server 2008, being able to sort SSIS packages by their names in the project (like SSAS), smartdiff functionality in SSAS like they had setup for SSIS, and being able to change the scope of an existing SSIS variableSmile

        Here is the complete list of new features that have been incorporated in the new release:

      • Analysis Services
        • Integration Services
          • You can download the SQL 2005 or 2008 release and they do have a new xcopy deployment option also.

            If you want to use the smartdiff functionality you must have at least Visual SourceSafe or Team Explorer Client installed.  The project does not have to be bound to source control, but this component leverages the visual diff dialog from either of these tools.  If you don’t have one installed you will get this message:


            Check it out for yourself – http://bidshelper.codeplex.com.  Just want to once again thank the team (Darren Gosbell, Greg Galloway, and John Welch) working on this for all of their hard work, it is very appreciatedOpen-mouthed

            Posted in Downloads | Tagged: , | Leave a Comment »

            Did you know? SQL Server 2008 includes Dimension Designer Enhancements

            Posted by denglishbi on July 20, 2008

            SQL Server 2008 includes Dimension Designer Enhancements, new attribute relationships designer, and additional Best Practice Alerts:)

            The Dimension Wizard within BIDS 2008 (VS 2008) for Analysis Service Projects has been simplified and introduces a new attribute relationship designer.

            The wizard has reduced the number of screens and includes an auto-detection for parent-child hierarchies.

            There have also been modifications to the Best Practice Alerts and there are now 57 alerts integrated into the designer along with a new option to add comments to them and disable them if desired.

            Check out a screencast about the Dimension Designer Enhancements in SQL Server 2008 here.

            Read more about this in the SQL Server 2008 BOL ‘Dimension Designer (Analysis Services – Multidimensional Data) ’.

            Did you know? SQL Server 2008 includes Dimension Designer Enhancements from Dan English on Vimeo.

            Posted in Analysis Services | Tagged: , , , , | Leave a Comment »

            BIDS Helper on CodePlex.com

            Posted by denglishbi on April 26, 2008

            I blogged about the new release back in December here when version came out which fixed a few issues with the SSAS buttons in the calculation tab and with the SSIS highlighter.  In talking with colleagues and clients recently though it seems like quite a few people are surprised when I talk about BIDS Helper.  I thought everyone already knew about it or was using it, but I guess not.  I really feel that this is an excellent add-in for anyone doing SSAS or SSIS development that I had to post another blog posting.  I know that my blog is starting to get more coverage thanks to the BI Blog aggregator http://biglogs.com and now that my blog is mirrored on the Magenic blog site at http://blog.magenic.com/blogs I wanted to post another entry promoting the BIDS Helper which is available here.

            So what is so cool about BIDS Helper and why would you want to use it?  Well the main features that I like are the options to deploy the MDX script in the calculations tab of the cube, aggregation manager, update estimated counts, column usage reports, expression and configuration highlighter, expression list, and smart diff (all of the features are cool and helpful, but these are some of the key ones I use).  If you go to the site on CodePlex you can get detailed information about each feature with screenshots. 

            It appears that this add-in currently only works with the English version of BIDS and that it probably only works with 2005 and not 2008 versions of Visual Studio.  I haven’t actually tested it in VS 2008 yet, but according to some comments on the site there appears to be some issues.

            Here is the complete list of features that are currently included with the BIDS Helper along with a picture from the site that highlights a few of the features:




            I did take a quick peek at the Source Code section for this Project and it appears that version should be available anytime now.  Some of the new features according to the comments are the ability to sort the SSIS packages by name (like you can do in SSAS), VS 2008 support, SQL Sever 2008 support, smart diff for SSAS objects, and more performance improvements Hot.  This is cool stuff and you got to thank Darren Gosbell, Greg Galloway, and John Welch (hopefully I got all of the names right) for making this available.  Feel free to post an item on the discussion section for anything that you would like to see added because most of the new features being added are taken directly from this section here.

            Posted in Downloads | Tagged: , | Leave a Comment »

            BIDS Helper released today

            Posted by denglishbi on December 17, 2007

            This includes a few fixes that were introduced in the 1.2 version.  There was an issue with multiple buttons being generated in the calculations tab that has been fixed.  Here is a description of the fixes:

            Release Description

            This release incorporates a couple of bug fixes and some minor performance improvements.

            • FIXED: Multiple copies of the BIDS Helper buttons appearing in the calculations tab of the cube designer
            • FIXED: Occasionally the Expression/Configuration highlighter would fail to highlight items correctly
            • FIXED: The performance of the highlighter component has been slightly improved.

            If you haven’t installed this add-in for Business Intelligence Development Studio I would highly recommend it.  It is a lifesaver if you are trying to test out your calculations in your cube and just need to deploy the MDX script.  Find out more about the product on CodePlex.

            Posted in Downloads | Tagged: , | Leave a Comment »