How to change Boolean variable Yes As "TRUE" and No as
"FALSE" in Cognos reporting studio?
- 2 Answers
- 8995 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........
what is the generated prompt,how can i use?
How to crate cubes in transformer ?
how to find the rank in report studio? i need steps for this question.
How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.
what is model and say about process how to create model and how to test model?
Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!
what is filter?give me one example that you created a report in your project?
can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com
1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?
Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development
Teradata 
