CRX-API-0005 An error on or around the position '0'. The variable named '[QueryX].[XXXX]' is invalid

Technote (troubleshooting)


Problem(Abstract)

An error is shown when there is a conditional variable based on a query item that is not displayed within the current container on the report layout. This is due to new functionality in IBM Cognos that optimises the query to eliminate unused data items from the resulting query SQL or MDX. To include a query item on the layout without displaying the object now requires that the query item be added to the properties of the container in the layout. This can be accomplished using the "Properties" property.

Symptom

CRX-API-0005 An error on or around the position '0'. The variable named '[QueryX].[XXXX]' is invalid.


Resolving the problem

Select the query item being used for the evaluation of the conditional variable in the report, under properties of the report object. For example, for a list object, click the ellipses next to "Properties" in the Data section of the List object properties.

Note: For other report type such as chart and crosstab, the data item must appear in the layout.

Steps:

  1. Select the report object that has the conditional variable being used for formatting or anything other object that report user may be using with the conditional variable.
  2. Use the control above the properties pane to navigate the ancestor objects from the layout. For a list report, select the List object. For a crosstab report, select the Crosstab Node Member.
  3. Locate the Data section in the Properties pane for the List or Crosstab Node Member object.
  4. Within the Data section, click on the elipses "..." next to the Properties entry.
  5. Select the query item that is being used in the conditional variable expression.
  6. Click OK to return to your report layout. The data item should now be available within the scope of your List or Crosstab Node when the report is executed.

If the error still appears when a data item is being used directly on the page without a query container such as a list or crosstab then similar steps can be taken to set the available query items at the Page level.

To do so:
  1. Select the Page object from the ancestor control after selecting any object in the page layout.
  2. Set the Query property of the Page object to reference the query containing the required data item.
  3. The list of available query items can now be set for the Page using the Properties entry in the Data section of the Page object properties.


See attached document for screen capture of the location of the properties property.

Related information

CRX-API-0003 conditional formatting condition format crosstab

Cross reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos 8 Business Intelligence Analysis Studio
Business Analytics Cognos 8 Business Intelligence Cognos Connection
Business Analytics Cognos 8 Business Intelligence Cognos Viewer
Business Analytics Cognos 8 Business Intelligence Framework Manager
Business Analytics Cognos 8 Business Intelligence Install and Config
Business Analytics Cognos 8 Business Intelligence Report Studio
Business Analytics Cognos 8 Business Intelligence Software Development Kit

Historical Number

1018453

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Business Intelligence
Report Studio

Software version:

8.3, 8.4, 8.4.1, 10.1, 10.1.1, 10.2

Operating system(s):

AIX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:

1339433

Modified date:

2009-11-06

Translate my page

Machine Translation

Content navigation