QE-DEF-0459 CCLException and QE-DEF-0260 Parsing error before or near position

[84gopi]

Hi,

My requirement is to display output as yes or No, for the 2 columns which has values 0 or 1.
So I have used below expression to get this, but getting

QE-DEF-0459 CCLException and QE-DEF-0260 Parsing error before or near position error in cognos report studio 10.2.

if ([Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Question Is Auto Failure]  and
[Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Answer is Auto Failure]  = 1)
then 'Yes'
else
'No'
end

Can any one help me to solve this ASAP?

Thanks
Gopi

[bdbits]

Unless your first condition is on a boolean data type, the expression is not valid. From what you wrote, you need to compare it to 0 or 1.

[BigChris]

Looks like you've got quite a few errors in there:

if ([Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Question Is Auto Failure]  and
[Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Answer is Auto Failure]  = 1)
then 'Yes'
else
'No'
end

I think it ought to read something like:

if ([Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Question Is Auto Failure] =1   and
[Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Answer is Auto Failure]  = 1)
then ('Yes') else ('No')

[84gopi]

Hi,

I need to display as 'Yes' in the report, if my 1st condition is true ([Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Question Is Auto Failure]  and [Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Answer is Auto Failure]  = 1)

Else

it should display as 'No' .

Logic here is that : if Question is auto failure and answer is auto failure is 1, then it is auto failed (yes), else it is not.

So I am using above logic...I hope it clears now.

[BigChris]

Did my suggested version work for you?

[84gopi]

yes, when i gave this condition and ran the report am getting wrong data, so need to re- design the model and report to get the issue fixed.

I am using dimensional modelling in my project. When I run the report few columns am getting same data ...so which is not correct.