PerformancePoint Planning Server SQL Server Integration Services (SSIS) Starter Kit

Language:
English
Step-by-step directions detailing the recommended data import package steps in a typical PerformancePoint Planning Server application
  • Version:

    1.0

    File Name:

    SSISStarterKit.zip

    Date Published:

    3/30/2009

    File Size:

    670 KB

      This document includes step-by-step directions detailing the recommended data import package steps in a typical PerformancePoint Planning Server application. It provides a starter Visual Studio 2005 Business Intelligence Development Studio (BIDS) 2005 solution including a SQL Server Integration Services (SSIS) project with two files which can be used as the starting point for Dimension and Fact data load packages. The Dimension data is set up to source from an Excel file, and the fact data package sources from a SQL Server database called CustomerDataScrubbed. BizCorp is a sample Performance Point Planning application used as the destination. You must change your database connections, package variables and configuration file settings to be appropriate for the packages to work in your environment. Those steps are covered by this document.
  • Supported Operating System

    Windows Vista, Windows XP

      • A PerformancePoint Planning application which contains dimensions, including a time dimension and at least one model site
      • Visual Studio 2005/Business Intelligence Development Studio (BIDS) (installed through SQL Server 2005 tools)
      • SQL Server 2005 SP2
      • PerformancePoint Planning Server Business Modeler
      • An account with Data Modeler permissions on a PerformancePoint Planning Server Application that also has Administrator permissions in the development environment
      • Knowledge of how to create and deploy a SQL Server Integration Services (SSIS) package
      To read the "Starter Project Instructions" paper, you must have Microsoft Office Word 2007. You can also use Office Word 2003 or Word XP and the Microsoft Office Compatibility Pack.
    • Click Download, and then save the archive file to your computer. Open the "Starter Project Instructions.docx" file in Word to read complete instructions about the solution.
Site feedback
Microsoft

What category would you like to give web site feedback on?



Rate your level of satisfaction with this web page today:

Comments:

Submit