Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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'

Question Posted / brahmaiah508

Answers were Sorted based on User's Feedback



I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the ..

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

I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the ..

Answer / krishna

case when column_Name =0 then 'NULL'
else 'column_Name'
end

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More Cognos Interview Questions

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

0 Answers   IBM,

-------------What is Coditional Prompting?

0 Answers   IBM,

What are the different kinds of panes included in cognos?

0 Answers  

What is difference between data mart and data warehouse?

0 Answers  

What is meant by junk dimension?

0 Answers  

what are the applications of the tabular model ????

5 Answers   iFlex, iGate,

Can you define transformer?

0 Answers  

what are the dimensions that you have in your current project?list them?

0 Answers   IBM,

advantages of cascade prompt ???

3 Answers   iFlex,

How do we create row level security in cognos8?

3 Answers  

what happens when date function has taken as attribute

1 Answers   TCS,

architecture of cognos8

1 Answers   IBM, Sonata,

For more Cognos Interview Questions Click Here
Categories