Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

how you migrate reports to cognos 8 from previous versions?

1032


how to connect datamarts

2782


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1050


When we save a report in report studio with what extn it save?

1060


--------------Diff b/w ODS and OLAP?

3195


What are the components of the report studio?

1172


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

2546


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2425


Give me any example of semi and non additive measures?

957


What is the model filter?

1008


What is cognos powerhouse?

1021


What are all the types of report?

1089


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

1895


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!

2004


---------------Describe OLAP Reporting and RDBMS Reporting?

2092