Project Server Pivot Table report in excel no direct access to SQL RRS feed

  • Question

  • Project Server report works however trying to make changes fails

    the data source connector in excel connection

    Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=XXX_Analysis2;Data Source=SQL_FQDN;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error

    Providor data source connects to SQL using MSOLAP.4 however due to nature can only connect via SharePoint WFE only - is this possible?

    Tony Stanley

    • Moved by Wayne Fan Monday, March 5, 2012 1:45 AM Project Server issue (From:SharePoint - Excel Services (pre-SharePoint 2010))
    Friday, March 2, 2012 12:51 PM

All replies