Re: Dependency tracking application

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Nov 14, 4:15 am, Ken <raid...@xxxxxxxxx> wrote:
Hello,
I need advice on whether SSAS or OLAP in general is a good choice to
model dependency chains. I need to model and store application
depdendencies
e.g app A is dependent on database db1 which resides on server 1
Db1 is also dependent on ETL job Load1, which in turn is dependent on
a data file df1.

The goal is to be able to build a report so user picks an object
(file, db, app, or server) and can view it's dependency chain. e.g
user chooses to view dependencies of data file df1 then the report
should list all it's dependent objects-
File df1 affects, Load1, which in turn affects Db1, which impacts App
A.

Thank you for your input.

Ken

Ken,

this is the BI metadata handling we are all waiting for years!
Using existing technologies, we suggested a way to track this
dependencies adapting the development methodology to the existing
tools. Let's take a look at our SQLBI Methodology (http://
www.sqlbi.com/sqlbimethodology.aspx).

Marco Russo
http://www.sqlbi.com
http://sqlblog.com/blogs/marco_russo
.