BIDS Helper 1.4.2.0 has been released

Today I was notified that a new release was available for BIDS Helper with the newly added Version Notification that was included with version 1.4.1.0 (BIDS Helper 1.4.1.0 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 cool 

This new release also includes fixes for:

• Change Variable Scope in Event Handler
• Dimension Health Check Fails with GUID Keys

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.

BIDS Helper 1.4.1.0 available

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 too

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

• General
  • Version Notification
• Analysis Services
  • Sync Descriptions
• Reporting Services
  • Smart Diff

This release also incorporates the following bug fixes and enhancements:

• Parent/Child naturalizer fails if view contains spaces
• Deploy SSIS package error (BIDS 2005 and BIDS 2008 side by side)
• SSAS Estimated Count errors – CubeDimensionID does not exist
• Deploy SSIS Packages – no Deploy (BIDS Helper) tab?

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.

BIDS Helper 1.4 Released

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:

• Analysis Services
  • Parent-Child Dimension Naturalizer
  • Test Aggregation Performance
• Integration Services
  • Sortable Package Properties Report
• Reporting Services
  • Dataset Usage Reports
  • Delete Dataset Cache Files

And it contains a number of enhancements and bug fixes:

• Analysis Services
  • Enhancements to Edit Aggregation Dialog
  • improved Printer Friendly Aggs report

Integration Services

• Problem with BIDS 1.3.0.8 (SQL 2005) and VSS
• Smart Diff error – File or project not found
• Expression List doesn’t show all Expressions

As you can see there are a couple of features for Reporting Services now  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 BIDS  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.

BIDS Helper 1.3.0.6 available on CodePlex

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 variable

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

Analysis Services

• Dimension Data Type Discrepancy Check
• Non-Default Properties Report
• Printer Friendly Aggregations
• Similar Aggregations
• Smart Diff

Integration Services

• Deploy SSIS Packages
• Fix Relative Paths
• Non-Default Properties Report
• Reset GUIDs
• Sort Project Files
• SSIS Performance Visualization
• Pipeline Component Performance Breakdown
• Variables Window Extensions

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 appreciated

Did you know? SQL Server 2008 includes Dimension Designer Enhancements

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.

BIDS Helper on CodePlex.com

I blogged about the new release back in December here when version 1.2.0.1 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:

Features

• Analysis Services
  • Aggregation Manager
  • Calculation Helpers
  • Column Usage Reports
  • Delete Unused Aggregations
  • Deploy Aggregation Designs
  • Deploy MDX Script
  • Dimension Health Check
  • Dimension Optimization Report
  • Measure Group Health Check
  • Printer Friendly Dimension Usage
  • Tri-State Perspectives
  • Show Extra Properties
  • Update Estimated Counts
  • Validate Aggregations
  • Visualize Attribute Lattice
• Integration Services
  • Create Fixed Width Columns
  • dtsConfig File Formatter
  • Expression and Configuration Highlighter
  • Expression List
  • Smart Diff
• General
  • Enable/Disable features

 

 

I did take a quick peek at the Source Code section for this Project and it appears that version 1.3.0.0 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 .  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.

BIDS Helper 1.2.0.1 released today

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 1.2.0.1 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.