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