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 |
1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.
What is Local Cache and how does it help in performance tuning
----------------What is Scopr Relationship?
what is the difference between native sql and cognos sql?
we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?
What is defined as catalog and types of catalogs in Cognos?
What is the function of cognos dispatcher?
hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?
what are the applications of the tabular model ????
What is the difference between the standard and metrics folder?