SAP BW and PowerPivot integration

The Objective of the this article is to integrate SAP BW info cubes and Power Pivot via SQL Server 2008 R2 Reporting Services.

Without replicating huge Business data from SAP systems to intermediate Data Warehouses, we can directly load into PowerPivot and can be able to establish relationships between dimension tables and fact tables.This is very handy process to reduce IT infrastructure for BI solutions.