none
Decomposition tree using sharepoint list RRS feed

Answers

  • Hi there,

    In PerformancePoint Services you can use a PowerPivot model as a data source to build your PerformancePoint Services dashboards. To use PowerPivot as a data source within a PerformancePoint Services dashboard, you must have PerformancePoint Services activated on a SharePoint Server 2010 farm and have PowerPivot for SharePoint installed. Once a PowerPivot model has been created by using the PowerPivot add-in for Excel, this Excel file must be uploaded or published to a SharePoint site that has PowerPivot services enabled. Create the data source connection in Dashboard Designer using the Analysis Services data source template.
    MSDN article: How to setup the PowerPivot model as a data source
    http://technet.microsoft.com/en-us/library/ff191197.aspx

    There are so many blogs/article which might help you:
    http://denglishbi.wordpress.com/2011/01/03/using-powerpivot-with-performancepoint-services-pps-2010/

    Does that help?
    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    • Marked as answer by Renato Torres Friday, December 2, 2011 1:04 PM
    Friday, December 2, 2011 12:19 PM

All replies

  • HI there,

    Analytical reports can only leverage multidimensional sources in PerformancePoint.  So you could use PowerPivot to pull in your SharePoint list data, upload the PowerPivot (Excel 2010) file to SharePoint (assuming you have PowerPivot for SharePoint setup), and then reference the PowerPivot file to create your analytical report. 

    Similar post:
    http://social.technet.microsoft.com/Forums/en-IN/sharepoint2010setup/thread/13f254ee-6eb3-4545-81e5-05048cbea553

    Does that help?


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Friday, December 2, 2011 6:55 AM
  • Hello Amit,

    Firtly, thanks for the reply.

    So, my point is: How can I reference the PowerPivot as a Multidimensional datasource in Dashboard designer? I can find anything talking about it.

     

    Could you help me?

     

    Cheers


    Renato Torres Project Blog - Projetizando
    Friday, December 2, 2011 11:59 AM
  • Hi there,

    In PerformancePoint Services you can use a PowerPivot model as a data source to build your PerformancePoint Services dashboards. To use PowerPivot as a data source within a PerformancePoint Services dashboard, you must have PerformancePoint Services activated on a SharePoint Server 2010 farm and have PowerPivot for SharePoint installed. Once a PowerPivot model has been created by using the PowerPivot add-in for Excel, this Excel file must be uploaded or published to a SharePoint site that has PowerPivot services enabled. Create the data source connection in Dashboard Designer using the Analysis Services data source template.
    MSDN article: How to setup the PowerPivot model as a data source
    http://technet.microsoft.com/en-us/library/ff191197.aspx

    There are so many blogs/article which might help you:
    http://denglishbi.wordpress.com/2011/01/03/using-powerpivot-with-performancepoint-services-pps-2010/

    Does that help?
    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    • Marked as answer by Renato Torres Friday, December 2, 2011 1:04 PM
    Friday, December 2, 2011 12:19 PM
  • Tks Amit,

     

    You are very helpfull, Im trying this links.

     

    Tks so much


    Renato Torres Project Blog - Projetizando
    Friday, December 2, 2011 1:04 PM