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
- 6214 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naresh
Create one new Derived Column ,In derived column Expression use case statement as ---->
case when column_Name =0 then 'NULL'
when column_name<>0 then cast(column_name,varchar(20))
end
after this hide the original column by checking properties of column
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / krishna
case when column_Name =0 then 'NULL'
else 'column_Name'
end
| Is This Answer Correct ? | 8 Yes | 0 No |
What is a Complex report and explain?
Define report item?
what does my folder and public folder contains? difference between the my folder and public folder?
Why cognos decision stream is used?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
what is the difference between group and association?
3. What was the size of your cube?
Define catalog in cognos and write its various types?
What is main difference mapplets and mapping?
-------------What is Coditional Prompting?
How can we improve performance in framework manager level?
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.
Teradata 
