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

Getting CRX-API-0003 A data type error using Reports 10.1.2 (OLAP)

Started by gosoccer, 07 Aug 2014 11:12:34 AM

Previous topic - Next topic

gosoccer

Friends, :)
I'm using Report 10.2.1 and using cube environment.

I'm working on a line chart. Once I use the Conditional Palette, I'm getting the following error when I establish a new
pallet for one of the member sets used as a part of the Series X-AXIS.

I think the Set of Members (# of Success) is not being recognized in a compatible form with the Conditional Palette.

Could someone please direct me to the right path regarding to this error?

Please see attached showing some of the Options I am taking to establish the coloring that is giving me the error.

Invalid expression ([Query4].[# of Success] = "# of Success"). CRX-API-0003 A data type error ocurred at or near the position '25' in expression: '([Query4].[# of Success] = "# of Success") '. The operand types ('double,string (varchar)') for operator 'Equal (=)' are not compatible.

Thanks so much in advance for your time.

MFGF

Quote from: gosoccer on 07 Aug 2014 11:12:34 AM
Friends, :)
I'm using Report 10.2.1 and using cube environment.

I'm working on a line chart. Once I use the Conditional Palette, I'm getting the following error when I establish a new
pallet for one of the member sets used as a part of the Series X-AXIS.

I think the Set of Members (# of Success) is not being recognized in a compatible form with the Conditional Palette.

Could someone please direct me to the right path regarding to this error?

Please see attached showing some of the Options I am taking to establish the coloring that is giving me the error.

Invalid expression ([Query4].[# of Success] = "# of Success"). CRX-API-0003 A data type error ocurred at or near the position '25' in expression: '([Query4].[# of Success] = "# of Success") '. The operand types ('double,string (varchar)') for operator 'Equal (=)' are not compatible.

Thanks so much in advance for your time.

Hi,

You haven't told us what condition you have defined? Normally you pick the string values you want to use for each colour, but you just seem to have an item name? For example, if I had Product Line members in the series of my chart and I wanted to create a conditional palette for one or more of these, I would choose the individual member(s) for each colour in the palette. It's not clear what you are doing here. Can you elaborate?

MF.
Meep!