1355281 - Live Office (Xcelsius and Query as a Web Service) does not automatically translate the universe object names when importing data from Web Intelligence reports based on a translated universe

SAP Knowledge Base Article - Public

1355281 - Live Office (Xcelsius and Query as a Web Service) does not automatically translate the universe object names when importing data from Web Intelligence reports based on a translated universe

Symptom

  • In Live Office (LO) (and subsequently Xcelsius and QAAWS), when importing Webintelligence reports based on a translated universe (using Universe Translation Manager - UTM), the report is not immediately available in the language of the Preferred Viewing Locale when importing it.
  • Only after refreshing the report, the object names translated into the preferred language.

Environment

  • Business Objects XI 3.x
  • Live Office XI 3.x
  • Xcelsus 2008
  • Query as a Web Service XI 3.x

Reproducing the Issue

  1. Create a Webintelligence report based on a demo universe translated with the UTM
  2. Use Live Office to import the Webintelligence report into the excel file.
  3. In Live Office the name of the original universe objects (NameOf() variables) are not translated regardless of the language selected in "Preferred Viewing Locale".
  4. However after refreshing the report, the object names are translated correctly.

Cause

  • This is by design.  LiveOffice has not been specifically designed to interact directly with the Translation manager.
  • All what Live Office does is import the saved report from InfoView.  
  • It doesn't do the same checks as Web Intelligence when opening a report to establish whether there is an alternative translated version available.  
  • Only when refreshing the report in Live Office do the checks get done and the translated names are imported.  In effect, the report is refreshed in Infoview and passed on to LO.                                       

Resolution

  • Enhancement Request ADAPT01259160 has been created. 
  • However it is a complex change to make and it would require important modifications in the code which could impact other parts of the product suite.
  • Currently there is no commitment to implementing this new feature request.

Workarounds:

  1. Refresh the report in Live Office in order to import the translated names
  2. Refresh the report in Infoview with the required Preferred Viewing Locale and save the report as a new file (re-named to indicate the language for users) containing the translated data.  Users can then import this directly into Live Office in their required language.

Keywords

Webi, Infoview, maintain, traduction, incorrect, not working, XI31, QAAWS; wrong; incorrect; lost; dropped , KBA , BI-RA-XL , Dashboards and Presentation Design , Product Enhancement

Product

SAP BusinessObjects Xcelsius Enterprise 2008