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

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


      File Name:

      Date Published:


      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.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Try Office 365 free for one month.
    The power of Office. Everywhere.
    Start your free month of Office 365 now.
    Learn more