How to change Boolean variable Yes As "TRUE" and No as
"FALSE" in Cognos reporting studio?

Answer Posted / suman palisetty

write a case statement

case when [data item] ='Yes'
then 'True'
else 'False'
end

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are all the types of gateway used in Cognos?

548


what do u mean by bridge group? where we r using this one?

1545


What is the deployment requirements used in cognos?

553


What are the two types of framework manager?

684


What are cognos connection initial page components?

600






Define catalog in cognos and write its various types?

619


Can you define a catalog and types of catalogs in cognos?

572


How do we convert from Numeric to be Words?

2504


Give me any example of semi and non additive measures?

555


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1543


Explain informatica architecture?

562


write a query to display the departments with no employee?

1553


what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

1700


How to deploy from one server to another server?

2019


What is the difference between low affinity and high affinity connections?

555