Managing Team Development with SSAS, TFS, & BIDS

Posted by Kevin D. White on Stack Overflow See other posts from Stack Overflow or by Kevin D. White
Published on 2010-04-16T15:20:51Z Indexed on 2010/04/16 15:23 UTC
Read the original article Hit count: 426

Filed under:

ssas

|

tfs

|

project-management

I am currently a single BI developer over a corporate datawarehouse and cube. I use SQL Server 2008, SSAS, and SSIS as my basic toolkit. I use Visual Studio +BIDS and TFS for my IDE and source control. I am about to take on multiple projects with an offshore vendor and I am worried about managing change. My major concern is manging merges and changes between me and the offshore team. Merging and managing changes to SQL & XML for just one person is bad enough but with multiple developers it seems like a nightmare. Any thoughts on how best to structure development knowing that sometimes there is no way to avoid multiple individuals making changes to the same file?

© Stack Overflow or respective owner

Related posts about ssas

SSAS Maestro Training in July 2012 #ssasmaestro #ssas

as seen on SQL Blog - Search for 'SQL Blog'
A few hours ago Chris Webb blogged about SSAS Maestro and I’d like to propagate the news, adding also some background info. SSAS Maestro is the premier certification on Analysis Services that selects the best experts in Analysis Services around the world. In 2011 Microsoft organized two rounds of… >>> More
SSAS – Synchronisation performance

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
I’ve always thought of SSAS synchronisation as a clever file mirroring utility built into SSAS and i have never considered the technology as bringing any performance gains to the table. So, its a good job I like to revisit areas…. :) I decided to compare the performance of robocopy and SSAS Synchronisation… >>> More
Query Logging in Analysis Services

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
On a project I work on, we capture the queries that get executed on our Analysis Services instance (SQL Server 2008 R2) and use the table for helping us to build aggregations and also we aggregate the query log daily into a data warehouse of operational data so we can track usage of our Analysis databases… >>> More
SSAS: distribution of measures over percentage

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I am running a SSAS cube that stores facts of HTTP requests. The is a column "Time Taken" that stores the milliseconds a particular HTTP request took. Like... RequestID Time Taken -------------------------- 1 0 2 10 3 20 4 20 5 … >>> More
Preserving Language across inline Calculated Members in SSAS

as seen on Stack Overflow - Search for 'Stack Overflow'
Problem: I need to retrieve the language of a given cell from the cube. The cell is defined by code-generated MDX, which can have an arbitrary level of indirection as far as calculated members and sets go (defined in the WITH clause). SSAS appears to ignore the Language of the specified members when… >>> More

Related posts about tfs

TFS - Rebinding solution to new TFS when prior TFS no longer available

as seen on Stack Overflow - Search for 'Stack Overflow'
The prior instance of TFS I was using is no longer available and I have a test project I want to bind to the new instance of TFS. However, when I try to add the solution to source control, the error message tells me that the collection is not available on the server. I have deleted all old source… >>> More
TFS 2010 Basic Concepts

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 false false false false EN-US X-NONE X-NONE … >>> More
TFS 2010, can I migrate source code only ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Our old TFS 2008 installation is getting old, and we would like to migrate to TFS 2010. However, the structure of our team projects is not so well thought out, and there has been various experiments with process templates and editing of work items and so on. Therefore, I would like to migrate our… >>> More
Insufficient Permissions Problems with MSDeploy and TFS Build 2010

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I ran into these problems on a TFS 2010 RC setup where I wanted to deploy a web site as part of the nightly build: C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\Web\Microsoft.Web.Publishing.targets (3481): Web deployment task failed.(An error occurred when reading the IIS Configuration… >>> More
TFS 2008 Web Access Report 100 record limitation

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
By default TFS 2008 Web Access has the limit of 100 record when you open any query in report mode. Even if you tried to export the query to excel or PDF you will only get first 100 record exported. To overcome this issue, you have to reconfigure this count in the web.config file Navigate to… >>> More