BISM Normalizer

Trial

BISM Normalizer manages Analysis Services tabular models

(4) Review
Visual Studio
2013, 2012, 2010
Download (7,171)
1/27/2015
2.0.1.2
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (4)
Q and A (31)
Sign in to write a review
Sort by:

by Derek Evans FL | September 11 2014

Absolutely brilliant add in. Works great. Helps me identify what the impact will be on production deployments. Create change scripts to be tested and handed to change management.

I use this daily

Thank You

Christian Wade September 11 2014
| Edit |
Delete

You're welcome and thanks for the feedback!

by Jon Capezzuto | March 15 2014

This is a brilliant utility! You just saved me hours of manual, tedious changes to merge two cubes. And you found several changes that I would have overlooked. Microsoft should buy this from you to include in the base product. Thanks for making this available!

Christian Wade March 17 2014
| Edit |
Delete

Thank you for the feedback Jon! Much appreciated!

by MartinLamZoosk | March 04 2014

i don't write reviews usually.. but this is AMAZING!!! we've developed scripts to do automatic partitions on our tabular cubes, so redeploying changes from the SSDT project is a NO NO, as it erases my existing partitions all the time.

Using BISM normalizer gives me the confident to make metadata / structural changes to our server, without worrying that it would accidentally overwrite other stuff, such as my auto created partitions, and I can review the xmla scripts before I run it.

i seriously won't know what to do if it were not for bism normalizers

p.s. also i was just cursing my life when i couldn't get the BIDS helper actions deployed to my prod (and I don't want to do deploy from SSDT), come here, and found out that the new version now supports it! amazing!

thanks

Christian Wade March 06 2014
| Edit |
Delete

Thanks for the feedback Martin! Much appreciated!

by bayFX | October 08 2012

Nice and Unique Tool for the BISM Developers.
Thanks Christian.

Sign in to start a discussion


  • Hide "Status = Same Definition" objects
    2 Posts | Last post Sun 5:31 PM
    • Feature suggestion: add a filter to show only objects that have different definitions, are missing in source or are missing in target. This will make it much easier to focus on the differences, as the majority of the objects are normally equal. 
      
      The feature can work similarly to the "Show Equal Objects" filter in the SSDT Schema Comparison window.
      
      Thanks,
      Vitaly
    • Hi Vitaly, I believe the Hide Skip Options feature does this.
      Thanks for feedback!
      Christian
      
  • Default measures
    3 Posts | Last post June 01, 2015
    • Would it be possible to enhance the tool so it supports default measures?
      
      We are currently using the approach at this link to manually apply the measure to the XMLA script: http://www.sqlservergeeks.com/sql-server-analysis-services-assign-a-default-measure-in-ssas-tabular-model-solution/
      
      Thanks,
      Vitaly
    • Hi Vitaly, will add to the backlog for investigation and prioritization!
      Thanks,
      Christian
      
    • Thanks Christian. This feature will save us a lot of time.
      
      Vitaly
  • Cannot query internal supporting structures for column
    4 Posts | Last post April 13, 2015
    • Hi Christian, 
      
      BISM Normalizer is giving us the following error message when pushing a change to our tabular model:
      
      "Cannot query internal supporting structures for column 'Table_X'[RowNumber] because they are not processed.  Please refresh or recalculate the table 'Table_X'."
      
      We can't seem to get past this error.  Have you seen this before?
    • Hi Alain,
      
      It looks like you have deployed some changes that require reprocessing a table in the target model.  Currently BISM Normalizer doesn't have functionality to do processing as part of the deployment.  It needs to be done in Management Studio, or using whatever mechanism you have for processing.
      
      I actually have it as a feature I would like to add in the future - to do processing as part of the deployment from BISM Normalizer - but it is not in the product yet.
      
      Thanks,
      Christian
      
    • Thanks Christian.  We have resolved our issue as it was relate to our model.
    • You're welcome!
  • No room is available to display rows
    5 Posts | Last post January 27, 2015
    • Hi Christian, 
      
      It's been great using the BISM Normalizer, thanks for developing this tool.
      
      I need your help as I have recently come across an issue with the BISM Normalizer where I get the following error when I click the "Validate Selection" button:
      
      No room is available to display rows.
      
      I have installed the latest version, 1.3.13.6, but that didn't solve the problem.  I work with 2 other colleagues on this project and they are not hitting this error so I'm wondering if it's something with my workspace database.  Any leads you can provide would be very much appreciated.
      
      Thanks,
      Alain
    • Hi Alain,
      
      At least one other user has had the same problem, but I have been unable to reproduce it.  If the same tabular project works on your colleagues' machines, it may be something environmental to do with your machine set up.
      
      If you like, I can set up a Webex for you to show me reproducing the error - just in case something comes up.  If so, e-mail me at bism.normalizer@gmail.com and I'll set it up.  Obviously I'd like to reproduce it, but it is proving a tricky one to reproduce!
      
      Thanks,
      Christian
      
    • I too got the same issue unable to generate the diff Script. 
      Please let me know if you are able to find a solution for this issue
    • Hi Prafulla - I have still not been able to reproduce this.  I will be making some big changes to a release in a few weeks.  If you still have this problem with the new release, maybe we can webex for me to see.
    • For reference, based off feedback from another user, I believe this issue is fixed in Version 2.0.0.0.
  • Another 'DatabasePermission' object has the 'DatabasePermission 2' name
    6 Posts | Last post January 27, 2015
    • Hi Christian, 
      
      I'm getting the following error message when doing a "Validate Selection":
      
      Another 'DatabasePermission' object has the 'DatabasePermission 2' name
      
      Any idea what this is about?
      
      Thanks,
      Alain
    • Hi Alain,
      
      Thank you for reporting this. Please try version 2.0.1.1 and let me know if fixed.
      
      Christian
      
    • How can I verify what version is currently installed?
    • Never mind, I found it under Tools -> Extensions and Updates.  
      
      I currently have version 2.0.1.2.  I'm running a compare now and I'll see what comes up.
    • Okay, the "Validate Selection" succeeded with no error message.  Thanks!
    • You're welcome!
  • BISM Normalizer 2.0.0.1 seems not working on VS2012
    4 Posts | Last post November 18, 2014
    • I have installed BISM Normalizer 2.0.0.1 on VS2012 SP4. However, I find that it do not load. After looking at the ActivityLog, it seems require VS2013 assembly to work:
      
      <entry>
          <record>479</record>
          <time>2014/11/14 06:23:36.351</time>
          <type>Error</type>
          <source>VisualStudio</source>
          <description>End package load [BismNormalizerPackage]</description>
          <guid>{D094957E-B4BC-493F-B473-A0DA301B21A1}</guid>
          <hr>80004005 - E_FAIL</hr>
          <errorinfo>Could not load file or assembly 'Microsoft.VisualStudio.Shell.12.0, Version=12.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.</errorinfo>
      </entry>
      
      So I install VS2013 isolated shell, and then I can load the application. But When I start compare the model. The same error popped up again:
      
      Could not load file or assembly 'Microsoft.AnalysisServices, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
      
      I'm quite upset that my beloved tool does not work on VS2012, but unfortunately My company has not upgraded to VS2013 yet. 
      
      Is there any solution to resolve?
    • Hi Mario, please try version 2.0.0.5.  Let me know if that works for you.
      Thanks!
      Christian
    • The problem is fixed and everything works fine.
      Thanks for the great tools~!
    • You're welcome!
  • Syncronizing tabular model structures
    4 Posts | Last post September 11, 2014
    • Hi Christian,
      
      I tried to get the already modeled structure from a deployed project into an empty one. The idea behin it is to use the modeled hierarchies etc. and get them into a new model. Next step would be to add a new fact and build the relationships.
      
      The only thing that worked for me was getting all content of the model into my new one and then delete what I did not need any more. Every other option I tried like selecting only the connection and one table (skip the rest) did not succeed. 
      
      Am I doing things wrong or is this just a use case BISM normalizer is not meant to handle.
      
      BR
      
      Marcus
    • Hi Marcus,
      
      BISM Normalizer should work well for your requirement.  Do you want to do a Webex so you can show me the process you are following?  If so, e-mail me at bism.normalizer@gmail.com and I'll set something up.
      
      Thanks,
      Christian
      
    • Hi Christian,
      
      thank you for your support. During the Webex we installed the latest version and everything worked as expected. Problem was the same as in the topic below the existence of measures with ']' in their names.
      
      Great Support
      
      Thanke
      Marcus
    • You're welcome Marcus.  Glad to help!
  • issue with special characters in measure names
    4 Posts | Last post August 22, 2014
    • if the name of a measure contains '[' or/and ']' the name is cut off in the Diff-Viewer window
      Also the wrong definition seems to be derived from online databases in this case
      
      maybe a similar issues exists for other special characters too?
    • Hi Gerhard,
      I have reproduced the problem with the ']' character.  Other special characters seem to be OK (e.g. [@#$%^&*?+:()).
      I'll look into it and get a fix out there soon.
      Christian
    • Thanks Christian! 
      cant wait for the fix
      could you drop me a short mail once you are done?
    • Gerhard,
      
      Version 1.3.13.6 deals with the ']' character (with a caveat - read below).  I did some digging ...
      
      Before SP1, no special characters were even allowed in measure names.
      
      Since SP1, special characters are allowed. However, if you open the .bim file and look at the XMLA for the command text in the MdxScript elements, you will see that Microsoft does a replacement of ']]' with ']' when displaying in the tabular model designer (genius).  I'm assuming they have some code that depends on ']]' to parse measure names and know when the end of the measure name occurs.
      
      I have built similar logic to allow BISM Normalizer to work with ']' characters, but I have not gone to the trouble of displaying ']]' as ']'.  It should update/create measures in the target database without problems and they will appear the same as in the source model in the tabular model designer, but in the BISM Normalizer differences grid, they show as ']]'.
      
      Maybe at a later date, I will change it to show as ']'.  We'll see.
      
      Thanks for pointing this out.
      Christian
      
  • Installation options
    2 Posts | Last post August 22, 2014
    • It seems that BISM Normalizer only gets installed for the latest installed version of Visual Studio. E.g. if you have VS 2010, 2012 and 2013 installed then BISM Normalizer is only available for VS 2013. It also seems that it is installed for the current user only.
      to make it available for other VS versions and other users you have to manually copy the Addin-files
      
      would be great if this could be selected in the setup:
      - for which VS version to install it (multiselect)
      - current user vs. all users (radio button)
      
      is this possible?
      would be great :)
    • Gerhard,
      
      You should not need to copy the files from one folder to another.  When going through the installation wizard, it should give the option to change the installation directory.  It defaults to something like "C:\Users\xxx\Documents\Visual Studio 2013\Addins", but you can change it.
      
      In Visual Studio > Tools > Options > Environment > Add-in/Macros Security, it lists all the addin file paths.  One of them is
        "%ALLUSERSPROFILE%\Application Data\Microsoft\MSEnvShared\Addins"
      which normally maps to
        C:\ProgramData\Application Data\Microsoft\MSEnvShared\Addins
      
      I think if you select this as the installation directory for BISM Normalizer it will be shared across users and VS versions.
      
      Alternatively can manually point all Visual Studio instances at the same BISM Normalizer installation directory, which also avoids copying the files.
      
      This also means that upgrading to a new version of BISM Normalizer is simpler because don't risk having different VS versions using different versions of BISM Normalizer.
      
      Cheers,
      Christian
      
  • BISM Normalizer expired
    5 Posts | Last post July 15, 2014
    • Hi Christian
      My copy of BISM normaliser has expired, the message tells me the last day is 2014-06-30, I’ve uninstalled and downloaded the most recent version but I’m still getting that error, the version I Am running is 1.3.13. Is there a later version?
      
    • Hi Michael,
      Version 1.3.13 should run till end of 2014. Please check the Visual Studio About box. It will have an item for BISM Normalizer (at bottom of list of installed extensions) that shows the version number. If that doesn't work, we can keep investigating.
      Christian
    • Hi Christian
      
      The version when I look in the about is 1.3.11.1. I've installed an uninstalled a few times, but let me throw in a reboot quick and see what happens.
    • All sorted
       
      The update had been happening against a different version of visual studio. Thanks again for your help and really useful product
    • Sounds good - glad you got it sorted
1 - 10 of 31 Items