Jump to content

User:Scriptbiml/sandbox

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Scriptbiml (talk | contribs) at 07:16, 22 November 2012. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
BIDS Helper
Developer(s)Darren Gosbell, Greg Galloway, John Welch, Darren Green, Scott Currie [1]
Initial releaseMay 27, 2007; 17 years ago (2007-05-27) [2]
Stable release
1.6.1 / September 7, 2012 (2012-09-07) [2]
Written inC#
Operating systemMicrosoft Windows
Available inEnglish
TypeIntegrated Development Environment
LicenseShared Source Permissive License (SS-PL)
Websitebidshelper.codeplex.com//

BIDS Helper is Visual Studio open source extension with multiple 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).[3] [4] BIDS Helper improves the development environment for integration, analysis and reporting services.[5] BIDS Helper is hosted on Microsoft's open source project hosting website CodePlex.[6]


History

BIDS Helper was was initially released on May 27, 2007. [2] Its most recent version, BIDS Helper 1.6.1 was released on September 7, 2012.[2]

Features

BIDS Helper has dozens of features that improve the functionality of BIDS, SSIS and SSAS. They are classified into one of five categories listed below based on where they increase functionality in SQL Server.

Analysis Services Multidimensional

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 [7]

Analysis Services Tabular

Smart Diff, Tabular Actions Editor, Tabular Display Folders, Tabular HideMemberIf, Tabular Pre-Build, Tabular Sync Descriptions, Tabular Translations Editor [7]

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 [7]

Reporting Services

Dataset Usage Reports, Delete Dataset Cache Files, Smart Diff [7]

General

Enable/Disable features, Preferences, Version Notification [7]

Biml

Biml is an XML-based language that allows you to describe your BI solution in a declarative fashion, similarly to using HTML to describe how a web page should appear.[8] BIDS Helper includes functionality that allows developers to write and execute Biml code for free.[9] Varigence has contributed key portions of the Biml engine, including dynamic package generation to BIDS Helper. Biml was first integrated with BIDS Helper in Version 1.5 released on June 7, 2011. [10]

References

  1. ^ "BIDS Helper - People". Code Name. Retrieved Novmber 21, 2012. {{cite web}}: Check date values in: |accessdate= (help)
  2. ^ a b c d "BIDS Helper 1.6.1". Codeplex. Retrieved November 21, 2012.
  3. ^ Tok, Wee-Hyong (2012). Microsoft SQL Server 2012 Integration Services. O'Reilly Media, Inc. p. 511. ISBN 978-0735665859. {{cite book}}: More than one of |pages= and |page= specified (help); Unknown parameter |coauthors= ignored (|author= suggested) (help)
  4. ^ Ferrari, Alberto (2009). "Chapter 2: Building Basic Dimensions and Cubes". Expert Cube Development with Microsoft SQL Server 2008 Analysis Services. Packt Publishing. p. 40. ISBN 978-1-847197-22-1. {{cite book}}: More than one of |pages= and |page= specified (help); Unknown parameter |coauthors= ignored (|author= suggested) (help)
  5. ^ Beresford, James (Decemeber,18 2009). "BIDS Helper". BI Monkey - James Beresford on Microsoft BI and Consulting in Sydney, Australia. Retrieved November 5, 2012. {{cite web}}: Check date values in: |date= (help); Text "web" ignored (help)
  6. ^ Rad, Reza (2012). "Chapter 15: Performance Boost in SSIS". Microsoft SQL Server 2012 Integration Services: An Expert Cookbook. Packt Publishing. p. 564. ISBN 978-1-84968-524-5. {{cite book}}: Unknown parameter |coauthors= ignored (|author= suggested) (help)
  7. ^ a b c d e "BIDS Helper - Documentation". Codeplex. Retrieved November 21, 2012.
  8. ^ Welch, John (June 7, 2011). "Biml Package Generator". BIDS Helper. Retrieved September 30, 2011.
  9. ^ Leonard, Andy (2012). SQL Server 2012 Integration Services Design Patterns. APress. p. 302. ISBN 978-1430237716. {{cite book}}: More than one of |pages= and |page= specified (help); Unknown parameter |coauthors= ignored (|author= suggested) (help)
  10. ^ "BIDS Helper 1.5". Codeplex. Retrieved November 21, 2012.
Retrieved from "https://en.wikipedia.org/w/index.php?title=User:Scriptbiml/sandbox&oldid=524316267"