1.0 Assumptions

Nov 5, 2009 at 12:18 PM
Edited Dec 2, 2009 at 3:36 AM


Version 1.0 of this product makes some rather significant assumptions and will only work if these assumptions are true for your BI environment.

  1. **This project currently assumes a pure Microsoft SQL Server BI implementation
  2. Your ETL solution consists of one SQL Server Agent job that calls SSIS packages
  3. SSIS is used as the ETL solution in your BI enviornment
  4. SSRS is used as the reporting solution in your BI environment
  5. SSAS is used as the OLAP solution in your environment
  6. SSIS logging is implemented via the SQL Server log provider writing to the sysdtslog90 table
  7. Currently only SQL Server 2005 is supported although it can be easily modified to work with 2008
  8. The reports can run under a user context that has read permissions on the following tables
    1. YourDB.sysdtslog90
    2. msdb.dbo.sysjobhistory
    3. msbd.dbo.sysjobsteps
    4. ReportServer.Catalog
    5. ReportServer.ExecutionLog
  9. Creation of a date table name DimDate (script provided)