White paper - PerformancePoint 2010 and PowerPivot

Written by Ali Kazazi

Thursday, 20 May 2010 02:45

Abstract

This document covers the basics of integration between PerformancePoint Services in Microsoft SharePoint Server 2010 and Microsoft SQL Server 2008 R2 PowerPivot. It describes the basics of utilizing a PowerPivot model in PerformancePoint and expands on the issues one should expect in using the two products in conjunction with one another.

Table of Contents

Abstract 1
Introduction 3
What is “PowerPivot”? 3
PerformancePoint and PowerPivot 4
PowerPivot Model Representation in PerformancePoint 7
    Dimensions and Attribute Hierarchies 7
    Measures 8
Important Considerations 9
Design Experience 10
    1. PerformancePoint Time Intelligence (TI) 10
    2. Show Details 10
    3. Count Measures 12
    4. Named Sets 13
    5. Analytic Reports 13
Setup and IT 14
    1. ADOMD.NET Driver 14
    2. Access to PowerPivot In-Memory Instance 15