Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Subversion Architecture/ Repository Structure for BI

Go down

Subversion Architecture/ Repository Structure for BI Empty Subversion Architecture/ Repository Structure for BI

Post  BIDev Wed Nov 06, 2013 5:33 pm

Hi Everyone,

We are just getting started with Microsoft's stack of tools as our BI solution.


We will be creating/using SSRS Reports, SSAS Tabular Models, Excel Services.PowerPivot models and PowerView reports for each functional area within our company.

For each functional area say ("Human Resources") we will be having a set of Reports, Data models, Dashboards etc

I was wondering if anyone of you could point me in the right direction for maintaining all the projects under Version control ( We will be using SVN ). Is there a standard way of maintaining all these diverse kinds of files/folders under SVN ?

Or in simple terms could you point me the benefits of using one over other in the following.

1) Create separate folders for each Functional Area  such as "Human Resources", "Sales" etc and house all the reports, models related to that functional area within their respective folders

The folder structure would look something like this

Human Resources - > HR Models -> HRDataModelProject1 ( This level will be the root for svn - And developers will checkout projects from this level )
Human Resources - > HR Reports -> ReportProject1

Sales- > Sales Models -> SalesModelProject1,
Sales- > Sales Reports -> SalesReportProject1,



Or

2) Create separate folders for each content type such as Data Models, Reports etc as separate folders and house reports or models for each functional area


Models - > HumanResources - > HRDataModelProject1  ( This level will be the root for svn - And developers will checkout projects from this level )
Models - > Sales - > SalesModelProject1

Reports - > HumanResources - > HRReportProject1
Reports - > Sales - > Sales ReportProject1

Are there any pros and cons of the above methods? Or is there any other way to do it more efficiently ? Your advice is very much appreciated !

Many Thanks
BiDev

BIDev

Posts : 2
Join date : 2013-10-30

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum