Issue in Drill thru when sent NULL values are passed

[sreejithhk]

Hi,

We had a scenario where the drill thru results displayed correctly if the key value is not null. when the key value is passed as null then we got a exception and we are unable to drill thru to next level

Scenario:
we have a data item with a key value. This key value can be not null or null. this data item is passed to the next level if the key value is not null we are able to get vaild results. If the key value is null we are getting execption or in some case we are not getting appropriate results.

We cannot handle the null values since the Key is a direct value from the DB. the key value is both null and not null in the DB.

How can we handle this scenario in cognos?

[blom0344]

Passing null values is no option. You need to assign a fixed value for null values (like 0 or a very large , unlikely to be used integer) and handle things at the receiving side.  Use coalesce to convert nulls to a real value