SAP Knowledge Base Article - Public

1559818 - Error Failed to run Query with Xcelsius Processing Server and Xcelsius Cache Server

Symptom

  • Query as a webservice queries fails to run in Xcelsius with error message "Failed  to run Query"
  • The queries use universe level condition @variable for objects in Universe
  • New Xcelsius Cache server and Processing server are enabled

Environment

  • Business Objects Enterprise XI SP3
  •  XCELSIUS 2008 SP3
  • Add new Xcelsius Processing server and Xcelsius Cache server

Reproducing the Issue

Following are the steps to replicate the issue:-

1) Open the Business Objects Sample Universe Island Resort Marketing.

2) Create a new Universe level condition with the following syntax

    Resort_Country.countryin @variable('Enter Name')

3) Save and Export this Universe

4) Open Query as a webservice designer tool

5) Create a new  query and drag the modified object as a filter in query

6) Publish the query

7) Import the query in Xcelsius and map the components to Excel range

8) Click on Preview

9) The error message  displayed is 'Failed to Run Query'

Cause

Universe level condition @variable is not supported with BOXISP3 Xcelsius Cache and Xcelsius Processing Server(only supports @variable('BOUSER'))

Resolution

To request a new feature or product enhancement, SAP has defined a new process and tool that is now available to customers called Idea Place: https://ideas.sap.com''. Idea Place gives customers the ability to log their own Enhancement Requests and work more directly with our Technology and Development group.

SAP is committed to reviewing and responding to the ideas submitted on a regular basis. The ideas with the most votes will receive a higher level of attention for response and consideration. The processes and procedures associated with this site will continue to evolve and enhance over time.

Keywords

KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards all versions