In this scenario by using DECODE()function we can solve this problem Ex

im having null data in one of the cell in my report
i have to display as "no data" when u run the report
how can i achive this problem?

Question Posted / bash

Answer Posted / bash

In this scenario by using DECODE()function we can solve this
problem

Ex: Decode(column_name,' ','No-Data')

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is meant by drill down?

921

Can you explain new content durability?

969

Define query studio?

945

What are all the advantages of Cognos?

972

Can you explain a cognos controller?

962

What is cognos connection?

1234

What is Metrics designer?

976

What are the advantages of cognos?

917

Explain what is the main advantage of impromptu over cognos reportnet?

983

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2199

What is defined as catalog and types of catalogs in Cognos?

1041

What are all the types of indexes in Cognos?

1146

how to create cubes in transformer ?

1004

What are the different types of important services used in cognos?

964

How do we drill through from a powerplay cube to reportnet?\

2294