http://bidshelper.codeplex.com/
There are many advantages in using this tool…
1. The first thing which I use this is for checking the dimension health, this is very helpful especially when you are dealing with the hierarchies…this helps in checking the data which is violating the hierarchy rule like data with many to many relationship etc…
2. There are many other useful options available like smartdiff (for finding the difference in code between versions), Deleting the Report Dataset Catch files (to make sure we see the refreshed data), Roles Report (gives the detail on the roles used in the cube) etc…
I would strongly recommend using this tool as this helps in improving and analysing many things while doing the BI development work.
A Visual Studio.Net add-in with features that extend and enhance the functionality of the SQL Server 2008 BI Development Studio (BIDS).
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
- Duplicate Role
- Many-to-Many Matrix Compression
- Measure Group Health Check
- Non-Default Properties Report
- Parent-Child Dimension Naturalizer
- Printer Friendly Aggregations
- Printer Friendly Dimension Usage
- Roles Report
- Similar Aggregations
- Smart Diff
- Show Extra Properties
- Sync Descriptions
- Test Aggregation Performance
- Tri-State Perspectives
- Update Estimated Counts
- Validate Aggregations
- Visualize Attribute Lattice
- Integration Services
- Batch Property Update
- Biml Package Generator
- Create Fixed Width Columns
- Deploy SSIS Packages
- Design Warnings
- 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
- Sortable Package Properties Report
- SSIS Performance Visualization
- Variables Window Extensions
- Reporting Services
- General