How to change Boolean variable Yes As "TRUE" and No as
"FALSE" in Cognos reporting studio?
Answers were Sorted based on User's Feedback
Answer / chandrasekar. p
After creating boolean variable we will assign variable 'Yes' as 'True' and 'No' as 'False' from using block/style variable in cognos report studio.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / suman palisetty
write a case statement
case when [data item] ='Yes'
then 'True'
else 'False'
end
| Is This Answer Correct ? | 1 Yes | 5 No |
How to schedule the report twice in a day?
3. What was the size of your cube?
Write a SQL query which should fetch the 5th maximum salary of an employee from the table?
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
What is content store?
Why cognos decision stream is used?
What are cognos connection initial page components?
what is the difference b/w mdx and sql?
------------------What is Inline Query?
How security is concerned with Reportnet? Explain its implementing steps.
what is the difference between querystudio in reportnet and cognos8
what are the types of facts ? explain them?
2 Answers Business Objects, Informatica, Syntel, Teradata,