how can you create a report like if country=india then true
if contry=spain then false?
Answer Posted / arkchowdary
Actually your question is not clear.
2 ways we can do which you asked why bcz --------- If u
want to do on same Column then u can use Conditional
formatting
Another One------------ If you want to do display result on
new column take new Query Calculation.
-------------- With the help of New query calculation we
can do this Report.
Ex------------ In Query Defnition you need to give
condition like this-------------- If Country='INDIA'
then 'TRUE
else If country='SPAIN' then "FALSE'
Another One is --------------- Through Conditional
Formatting we will do this Report.
Ex---------------- Use Boolean Variable we will do
If Condition is True then select Yes.
If condiotion is False then select No.
I Hope Clear.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how to test reports in cognos?
What are the types of hierarchies?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
What is cognos powerhouse?
How security is concerned with Reportnet? Explain its implementing steps.
What is difference between page break and section report?
What is the importance of having monitor service in cognos?
whats the difference between previous version of cognos and cognos 8 BI?
what is the role of cognos comsultant?what actually it means?pls reply
What are the considerations regarding performance kept in mind while setting up cognos?
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 is cognos connection?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Can you explain a cognos controller?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?