SAP Knowledge Base Article - Public

1384626 - Chart component using Qaaws data shows #N/A in Xcelsius dashboard.

Symptom

Chart component using Qaaws data shows #N/A in Xcelsius dashboard.

Environment

  • Xcelsius 2008

Reproducing the Issue

  1. Create two QAAWS queries which have prompts. The data returned by QAAWS should be a time field.
  2. Consume these two queries into Xcelsius.
  3. Set both of these to refresh on load.
  4. Calculate some Vlookup formula which would be based on the data coming from QAAWS.
  5. Map these formulas to a chart component.
  6. When you preview the dashboard, the chart component shows "#NA" instead of the data.

Cause

The chart is not displaying the values because the formulas are getting executed before the query brings up the values.

Resolution

  1. Open the dashboard and go to the Data Manager option.
  2. Set the first query to refresh on load however set the second query to refresh on a Trigger cell.
  3. This trigger cell will be the time field which gets updated by the first query.
  4. Now this will enable the first query to refresh completely and would only invoke the second query after the first query data is fetched.
  5. Save the changes and preview the dashboard. Now the chart will display the correct data.

Keywords

Charts, Xcelsius, QAAWS , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008