none
Project Server Excel (OLAP) reports not saving in PWA RRS feed

  • Question

  • Dear Sir,

    I have a 3 tier architecture of project server WFE, APP, and Data Base servers.

    Currently i have build an OLAP data base on PWA and i cliced on Business Intelligence -> Templates -> Olap data base -> Project Non Time phased -> and the report opens in Excel and i have selected my required fields and created a report and when i am trying to save i can do it only in computer but i am unable to save it in the templates (PWA).

    Configured Excel services and Secure Token Service also but no luck please help me on this.

    Thanks

    Geeth


    Geeth

    Thursday, March 14, 2013 10:14 AM

Answers

  • Hi Paul,

    I have solved the problem by installing Windows Desktop Experience Feature as in my computer it was not installed.

    Thanks

    Chaitanya


    Geeth

    Tuesday, March 19, 2013 9:54 AM

All replies

  • Hi Geeth,

    What version of Excel do you have? Do you not see an option to Save to SharePoint etc?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Thursday, March 14, 2013 11:40 AM
    Moderator
  • Hi Paul,

    I am using Excel 2010 but i have the option to save in sharePoint but some how it is not saving and when i click on save to sharepoint the location it is showing is the same my documents data sources only.


    Geeth

    Thursday, March 14, 2013 12:11 PM
  • Hi Geeth,

    Ok, when clicking Save to SharePoint, Click Browse for a location. In the Save As window that pops up, type the URL of the ProjectBICenter site either the URL bar or the File name field and press enter. An example of the URL needed is http://<SERVER>/pwa/projectbicenter. Then click through to the library where you want to save the excel file.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Thursday, March 14, 2013 12:18 PM
    Moderator
  • Hi Paul

    Microsoft Excel is throwing the below error s it is not able to connect to the server,

    could not open "http://trypmsapp:8888/PWA/ProjectBICenter/Templates/English%20(Unites%20States)/trypmsdb_trichypms%20-%20BSNL%20)Olap/"

    


    Geeth


    Thursday, March 14, 2013 12:52 PM
  • Hi,

    Do you see this for all document libraries?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Thursday, March 14, 2013 3:19 PM
    Moderator
  • Hi Paul,

    I have solved the problem by installing Windows Desktop Experience Feature as in my computer it was not installed.

    Thanks

    Chaitanya


    Geeth

    Tuesday, March 19, 2013 9:54 AM