VSTS 4 DB : How about OLAP?

Hi all,

Forget about other RDBMSs. Are there any plans to support SQL Server Analysis Services as well SQL Server Database Engine

Generating change scripts, creating baseline schemas, cascading changes, unit testing, data compare, data generation......these are as equally relevant to SSAS as they are SSDE.

I realise this won't be in v1.0....but is it in the pipeline for the future

-Jamie

Answer this question

VSTS 4 DB : How about OLAP?

Yseesee
Done.

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=135735

Dave F.
ktarayao
Hi Richard,

Actually, I'm not sure seeing the XML/A is as important as just being able to manage the objects within an SSAS database in a manner similar to managing objects in an SSDE database. I think the desire for this bleeds a bit into what BIDS can do now (from a development standpoint), but BIDS doesn't quite go far enough yet. I think we'd like to be able to take an SSAS object's definition and compare it to what has been deployed, get some type of change script, etc. This functionality also relates to being able to compare different versions of an SSAS object from a source code control standpoint -- allow me to compare versions of that object.

Dave Fackler
Dennis Mayores
ok, good feedback. Please file that as a suggestion at http://connect.microsoft.com so we can track it....
Espen Eriksmoen LOke

Interesting - so I want to make sure I understand

For the definition of objects stored in the non-relational database in Analysis Services you'd want the definitions of those objects shown as XML/A. What else would you want to see
GaryV
Yes - this would be an extremely useful and complementary feature to the existing relational features. Especially relevant since Microsoft is really pushing SSAS to the forefront in this release and with such forthcoming tools as Excel 2007 and ProClarity.
DW-DW

Spot on Dave. That's exactly what I was driving at.

-Jamie
gnutech
So I assume you mean when data is stored in the Analysis Service Engine, as opposed to storing your OLAP in a relational store. What would you expect to have in the project The XML/A
CoreStar2000

Hi Richard,

Thanks for the reply.

I'm not just talking about data here - I'm talking structure as well. The big thing I would like is change scripts (comparing deployed cube with a new version in development) and yes - those would be XML/A.

Make sense

-Jamie
hinchi
I agree that in the future OLAP objects whould be included. Currently the object of deployment for OLAP is the OLAP database, so a simple change requires that everything get redeployed. The abilities provided in Data Dude(tte) should eventually include AS.
VSTS 4 DB : How about OLAP?

Answer this question