Setup Instructions

Aug 6, 2009 at 9:20 PM
Edited Aug 7, 2009 at 1:29 AM

Here are the basic instructions for setting up the solution. Down the road I would like to streamline this but for now it will be somewhat manual. Please post questions/comments/suggestions as replies to this thread.

Install Video - http://screencast.com/t/pBpdGXN8

Setup

  1. Get the latest version of the project from TFS
  2. Open the project in the Business Intelligence Development Studio on the database server you want to deploy the data mart to (remote is possible as well)
  3. Create the SSISEventLogDM database manually on your server
  4. Open the _Setup SSIS project and Set the connection strings in the Setup.dtsx package
  5. Run the Setup.dtsx package

Deploy Cube

  1. Open the SSISEventLogOLAP project
  2. Point the project to the server you want to deploy the cube to
  3. Deploy the SSISEventLogOLAP project

Load Cube

  1. Open the SSISEventLogETL SSIS project
  2. Modify the config file - SSISEventLogETL.dtsConfig
  3. Run the MasterLoad.dtx package

Deploy Reports

  1. Open the SSISEventLogReports SSRS project
  2. Configure the project to deploy to your SSRS server (2008)
  3. Deploy the project
Sep 23, 2009 at 5:22 PM

More details on step 2 inside the 'Load Cube' section above:

<font size="2" color="#0000ff"><font size="2" color="#0000ff">

<!--

</font></font><font size="2" color="#0000ff">

 

</font>

File Connections--> Change to the location you downloaded the project

 <!--Shared Data Source--> Change to the location of your Admin and SSISEventLogDM databases

<!--SSAS Connections--> Chnage to where you deployed the AS database