Interested to Buy Any Domain ? << Click Here >> for more details...
how can you create a report like if country=india then true
if contry=spain then false?
- 2 Answers
- 5921 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / thanjairajan@gmail.com
1.Go to Report Studio
2.Select list container
3.Drag query item to the list container. i.e for example we take country,staff name,revenue query item from source tab
4.Drag query calculation from tool box tab to right side of the container.
5.In the box give new query item name. in this example Result is new query item name.
5.Expression definition window will show. in that we type like this.
case
when [country]='India'
then 'True'
when [country]='Spain'
then 'False'
end
6.Then run the report. u will see new column is result. in that true value will display equivalent of India country and false value will display equivalent of Spain country.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the Main Difference between Conditional Block and Render Variable in Cognos. Both are used for Condtional rendering.But what is the Main Diff?
what is your project workflow and your role in the project?
Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain
-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?
What is the use of powerhouse?
What is the difference between Open Connection command ang Open Session Command?
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
where we use page break and page set. with example?
what is reprompt?
What is the difference between group and associare?
Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You
What is Lookup ,bridgeing tables where they will use in the Dataware house
Teradata 
