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
how you migrate reports to cognos 8 from previous versions?
how to connect datamarts
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
When we save a report in report studio with what extn it save?
--------------Diff b/w ODS and OLAP?
What are the components of the report studio?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
Give me any example of semi and non additive measures?
What is the model filter?
What is cognos powerhouse?
What are all the types of report?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
---------------Describe OLAP Reporting and RDBMS Reporting?