I just wanted to let you know if you are not aware of about a very nice tool available for BI. I except every BI developer to use this tool..."BIDS Helper" is available free for download in codeplex to install and it takes few minutes to install in dev machine.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.
Thanks, Guarav
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.
Thanks, Guarav
No comments:
Post a Comment