BIDS Helper is a Visual Studio open source extension multiple with features That extend and Enhance business intelligence development functionality in all editions of Microsoft’s SQL Server 2005, 2008, 2008 R2 and 2012. [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 originally released on May 27, 2007. [2] Its most recent version, BIDS Helper 1.7.0 was released on March 17, 2015. [2]

In Version 1.5, released on June 7, 2011, Varigence contributed key portions of the Biml engine, including dynamic package generation to BIDS Helper. [7] [8] Business Intelligence Markup Language (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. [9] Version 1.5 also had the Expression Editor contributed by Konesans.

Features

BIDS Helper has the features of BEST , SSIS and SSAS . SQL Server: [10] How to Install SQL Server in SQL Server

Analysis Services Multidimensional

Deploy MDX Script – a tool that allows you to change the size of your data in a single database. The data types on the KeyColumns and NameColumn of dimension attributes. It displays any discrepancies and lets you fix them with the click of a button. Dimension Health Check – all you can do with the Dimension Optimization Report – This report lists all dimension attributes and hierarchies on rows. On columns, it lists various properties which can be used to optimize dimensions. Duplicate Role – You can copy a role with all of the associated settings and permissions Many-to-Many Matrix Compression – Analyzing the data in a m2m This feature automates this process and returns a report showing how much each m2m can be compressed. Measure Group Health Check – allow you to check various indications of measure group health. Non-Default Properties Report – will not let you down. Parent-Child Dimension Naturalizer – aids in converting parent-child dimensions into natural hierarchies. Printer Friendly Aggregations – a. Printer Friendly Dimension Usage – all you need to know about the Dimension Usage tab. Roles Report – recursively list the members of the role and the members of groups so That You can Easily determine qui members Actually-have access via Each role Similar Aggregations – Allows you to view a postponement That lists Any aggregations qui are very similar to Each Other. Smart Diff – lets you compare versions of a SSAS, SSIS, and SSRS files. BIDS Helper preprocesses XML files so that the diff versus source control is more meaningful. Show Extra Properties – exposes hidden properties on several Analysis Services objects. UI for editing descriptions on Analysis Services objects. Sync Descriptions – if you have a long time entering descriptions for relational tables and columns (for example, using the Kimball Dimensional Modeling Spreadsheet). Aggregation Test Performance – test the performance of your aggregations Tri-State Perspectives – this feature Operates in the Perspectives tab of the Cube Designer.

Analysis Services Tabular

Smart Diff – lets you compare versions of a SSAS, SSIS, and SSRS files. BIDS Helper preprocesses XML files so that the diff versus source control is more meaningful.
Tabular Actions Editor – provides a UI for editing actions for Tabular models. For example, this feature allows the designer to customize the columns by drillthrough.
Tabular Display Folders – provides a UI for editing display folders on measures, columns, and hierarchies. All displayed folders are edited in the same place.
Tabular HideMemberIf – allows HideMemberIf settings to be changed
Tabular Pre-Build – catches the build event and checks features for BIDS Helper settings that have been lost. Because these were backed up in annotations, They can be restored, and the user will be prompted if this is necessary. 
Tabular Sync Descriptions – if you have a long time entering descriptions for relational tables and columns (for example, using the Kimball Dimensional Modeling Spreadsheet).
Tabular Translations Editor – Allows you to code in one language. For example you could code in English but display in Spanish. Using the Kimball Dimensional Modeling Spreadsheet) it can help you import these descriptions to the table in your Tabular model in Analysis Services. Tabular Translations Editor – Allows you to code in one language. For example you could code in English but display in Spanish. Using the Kimball Dimensional Modeling Spreadsheet) it can help you import these descriptions to the table in your Tabular model in Analysis Services. Tabular Translations Editor – Allows you to code in one language. For example you could code in English but display in Spanish.

Integration Services

Batch Property Update – Allows you to update multiple packages to at once
Biml Package Generator – provides the ability to create packages from Business Intelligence Markup Language (Biml)
Create Fixed Width Columns – Allows you to use your Excel spreadsheet to create the column definitions in a Few simple steps.
Deploy SSIS Packages – lets you quickly deploy SSIS packages directly from BIDS without having to create a deployment manifest and use the Package Installation Wizard.
Design Warnings – provides similar functionality to the Design Warning feature in Analysis Services 2008. It compares the current package against a list of design guidelines, And adds warnings to the Error List in Visual Studio for any items that need to be investigated. 
DtsConfig File Formatter – watches for when a window is activated or created for a file with a.

Reporting Services

Dataset Usage Reports – lets you view a list of used and unused Reporting Services dataset
Delete dataset Cache Files – the automated deletion of the files .rdl.data
Smart Diff – lets you compare versions of a SSAS, SSIS, SSRS and queues

General

Enable / Disable features – Allows for the enable and disable individual features
Preferences – Allows for the configuration of features via a Preferences screen
version Notification – helps you stay current by alerting You When a new version is released BIDS Helper

References

  1. Jump up^ “BIDS Helper – People” . Code Name . Retrieved November 21, 2012 .
  2. ^ Jump up to:d “BIDS Helper 1.6.5” . Codeplex . Retrieved January 29, 2014 .
  3. Jump up^ Tok, Wee-Hyong; Parida, Rakesh; Masson, Matt; Ding, Xiaoning; Sivashanmugam, Kaarthik (2012). Microsoft SQL Server 2012 Integration Services . O’Reilly Media, Inc. p. 511. ISBN  978-0735665859 .
  4. Jump up^ Ferrari, Alberto; Webb, Chris; Russo, Marco (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 .
  5. Jump up^ Beresford, James (December 18, 2009). “BIDS Helper” . BI Monkey – James Beresford on Microsoft BI and Consulting in Sydney, Australia . Retrieved November 5, 2012 .
  6. Jump up^ Rad, Reza; Perfeito, Pedro (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 .
  7. Jump up^ “BIDS Helper 1.5” . Codeplex . Retrieved November 21, 2012 .
  8. Jump up^ Leonard, Andy; Masson, Matt; Mitchell, Tim; Moss, Jessica; Ufford, Michelle (2012). SQL Server 2012 Integration Services Design Patterns . APress. p. 302. ISBN  978-1430237716 .
  9. Jump up^ Welch, John (June 7, 2011). “Biml Package Generator” . BIDS Helper . Retrieved September 30, 2011 .
  10. Jump up^ “BIDS Helper – Documentation” . Codeplex . Retrieved November 21, 2012 .

Leave a Reply

Your email address will not be published. Required fields are marked *