How to change Boolean variable Yes As "TRUE" and No as
"FALSE" in Cognos reporting studio?
- 2 Answers
- 9011 Views
- Wipro, I also Faced
- E-Mail Answers
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
Diff b/w Crossproduct and Outerjoin?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
what are the dimensions that you have in your current project?list them?
------------- How to identify the Revenue Column in Report?
What are the different uses of a repository manager?
What is Fullouterjoin?
What is catalog and types of catalogs in cagonos and which is better?
What are the components of the report studio?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What are the types of folder present in cognos?
what is the main advantage of impromptu over cognos reportnet?
How to do Performence Tunning in Cognos Reports?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
How to join multiple db in catalog?
How create measures and demensions?
