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
- 6154 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is difference between data mart and data warehouse?
Can you explain cognos planning?
How create measures and dimensions?
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..
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What are the other methods working as deployment functionality?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
How do we convert from Numeric to be Words?
how to merge 2 crosstabs thans
Explain what is the main advantage of impromptu over cognos reportnet?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
Explain the different types of views used in cognos.
What do you mean by Drill down and Drill Up?
What are the advantages of using cognos sql?
What is the difference between regular dimension and derminant?
