Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

BISM Normalizer

with 5 comments

I’ve just come across a new, free utility for SSAS 2012 Tabular called BISM Normalizer:

http://visualstudiogallery.msdn.microsoft.com/5be8704f-3412-4048-bfb9-01a78f475c64

Basically it’s a tool that allows you to compare the metadata of two Tabular models and optionally copy parts of one model over to another. It’s very interesting because it addresses what I think is one of the big challenges encountered when bridging the gap between self-service and corporate BI: how can you take a bunch of independently-produced PowerPivot models and merge them into a single, coherent, Analysis Services Tabular model? Ultimately this is a problem that Microsoft is going to have to deal with itself in future versions of SSAS, along with the related problem of how parts of a ‘corporate’ Tabular model can be reused inside PowerPivot models (I’d like some form of object inheritance or ‘linked tables’, rather than have to copy data and rebuild metadata from scratch as we have to today).

Written by Chris Webb

December 29, 2011 at 10:36 am

5 Responses

Subscribe to comments with RSS.

  1. Thanks for the tip. this is exactly what I needed.
    Also a good idea to visit the VS Gallery every now and than to catch up with the latests tools

    Itay

    February 27, 2012 at 9:42 am

  2. [...] Chris Webb for blogging about it. [...]

  3. [...] A tool like this greatly facilitates the organic growth from self-service PowerPivot models into enterprise Tabular models…as Chris Webb alludes to in this post. [...]

  4. […] BISM Normalizer is 2 years old today. I launched it on Christmas Day 2011 (way before SQL Server 2012 hit RTM). It’s arrival was marked by a wise man writing a blog post. […]

  5. […] A tool like this greatly facilitates the organic growth from self-service PowerPivot models into enterprise Tabular models…as Chris Webb alludes to in this post. […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,240 other followers

%d bloggers like this: