If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

crx-api-0005 variable named invalid

Started by c84user, 10 May 2011 10:57:19 AM

Previous topic - Next topic

c84user

HELP PLEASE! I am modifying an existing crosstab report using a cube.  I added new data items to the crosstab (I also see them in the associated query).  When I add the item to the existing conditional variable that is being used for other data items in the same crosstab, I encounter the following error

CRX-API-0005 An error ocurred at or near the position '11'. The variable named '[Driver characteristics].[TCP_CGI_ORIG_YEARS_RESIDENCE_LR1]' is invalid.

All information I found regarding this error states the data item has to be associated with the report.  In my case, it is on the crosstab and shows in the report.  What do I need to do to resolve this error?
I'm confused about why the style variable is having a problem with the new data item added.  Here's the code for the conditional variable.  Everything's working except the new data item added (the first one).

Case
WHEN [Driver characteristics].[TCP_CGI_ORIG_YEARS_RESIDENCE_LR1] = '( blank )' THEN 'Hide'
WHEN [Driver characteristics].[TCP_TENURE_GRP_LR] = '( blank )' THEN 'Hide'
WHEN [Driver characteristics].[TCP_YRS_RES_GRP_LR] ='( blank )' THEN 'Hide'
........ several more like this

WHEN [Driver characteristics].[TCP_YRS_LIC_GRP_LR] = '1.07' THEN 'Gray'
WHEN [Driver characteristics].[TCP_YRS_LIC_GRP_LR] = '1.15' THEN 'Black'
WHEN [Driver characteristics].[TCP_YRS_LIC_GRP_LR] = '1.18' THEN 'Black'
WHEN [Driver characteristics].[TCP_YRS_LIC_GRP_LR] = '1.42' THEN 'Black'

WHEN [Driver characteristics].[TCP_VEH_AGE_GRP_LR] = '0.98' THEN 'Gray'
WHEN [Driver characteristics].[TCP_VEH_AGE_GRP_LR] = '1.00' THEN 'Gray'
WHEN [Driver characteristics].[TCP_VEH_AGE_GRP_LR] = '1.01' THEN 'Gray'
WHEN [Driver characteristics].[TCP_VEH_AGE_GRP_LR] = '1.02' THEN 'Gray'
WHEN [Driver characteristics].[TCP_VEH_AGE_GRP_LR] = '1.08' THEN 'Gray'
WHEN [Driver characteristics].[TCP_VEH_AGE_GRP_LR] = '1.16' THEN 'Black'

Else '0' END