dbTalk Databases Forums  

Evolving an OLAP schema in SSAS2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Evolving an OLAP schema in SSAS2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kevin Dente
 
Posts: n/a

Default 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?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.