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
- 6216 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a dimension?
What is Online View?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
What is the difference between drill through, drill across?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
-----------With out using DrillThrough how to do Reports?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
is cognos 7 is better than cognos 8
Can you define transformer?
Why is auto-regression used in forecasting used on cognos platform?
Why need staging area database for dwh?
what are slowly changing dimensions? Why we are used scd?
What is called cognos reporting tool?
Define the slice and dice?
