Interested to Buy Any Domain ? << Click Here >> for more details...
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
- 2 Answers
- 6435 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / krishna
case when column_Name =0 then 'NULL'
else 'column_Name'
end
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is called a slice?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
what is a prompt value in report studio and variables ?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
hi friends pls forward impropmtu interview question
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What are the ways to import data into catalog?
What is called Cognos powerplay?
What is metric store database?
Define query items?
Why are meta service important then other services?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What are the types of hierarchies?
How do you improve the performance of the Cognos Analytics report
