BIDS Helper

A Visual Studio add-in with features that extend and enhance business intelligence development functionality in SQL Server 2005, 2008, and 2008 R2 BI Development Studio (BIDS) and SQL Server 2012 SQL Server Data Tools (SSDT).

Features

• Analysis Services
  • Aggregation Manager
  • Calculation Helpers
  • Column Usage Reports
  • Delete Unused Aggregations
  • Deploy Aggregation Designs
  • Deploy MDX Script
  • Dimension Data Type Discrepancy Check
  • Dimension Health Check
  • Dimension Optimization Report
  • Measure Group Health Check
  • Non-Default Properties Report
  • Printer Friendly Dimension Usage
  • Printer Friendly Aggregations
  • Tri-State Perspectives
  • Similar Aggregations
  • Smart Diff
  • Show Extra Properties
  • Update Estimated Counts
  • Validate Aggregations
  • Visualize Attribute Lattice
• Integration Services
  • Create Fixed Width Columns
  • Deploy SSIS Packages
  • dtsConfig File Formatter
  • Expression and Configuration Highlighter
  • Expression List
  • Fix Relative Paths
  • Non-Default Properties Report
  • Pipeline Component Performance Breakdown
  • Reset GUIDs
  • Smart Diff
  • Sort Project Files
  • SSIS Performance Visualization
  • Variables Window Extensions
• General
  • Enable/Disable features

Installation

To install BIDS Helper, download the installer from the Releases tab.
If for some reason you cannot use the installer the latest release includes an xcopy deploy option.

Suggestions

We are currently in the process of brainstorming other potential features, and have been adding them as work items. If you have a feature you would like to see added, drop us a line on the forums.

Future Releases

The next release date has not yet been scheduled. The features for the next release have not yet been decided. The following new features are complete:

• Analysis Services
  • Parent-Child Dimension Naturalizer
• Integration Services
  • Sortable Package Properties Report

For information about compiling the latest source code yourself, please see this discussion