Evolving an OLAP schema in SSAS2005 -
08-15-2006
, 12:43 PM
(Cross posted from MSDN forums, no response there yet)
We are an ISV that ships as part of our product a set of SSAS2005 cubes.
Our customers can then customize those cubes (adding measures and
dimensions) using tools that we provide. As we release updates to our
product, we need to upgrade our customers databases, but without overwriting
their customizations.
One way of doing this is to write AMO code. However, I'm curious if
there's an easier way that I'm missing. Ideally there would be a way to
generate a "change script" that would apply a series of transformations to
an existing cube set (add a measure here, tweak a dimension attribute there,
etc) without mucking with existing customer customizations.
Does such a mechanism or tool exist? |