Default values for "Missing Value Characters"

[erna]

We have a problem displaying/aggregating two values from tables with facts in Query and Report Studio:

One fact has a value for the corresponding dimension, the other doesn't and therefore NULL ist returned.

The statement "IF value IS NULL THEN 0 ELSE value" doesn't help.

We already found out in Framework Manager that by changing the data format for the fact to "format type": "number" - "properties" - "missing value characters" from (Default) to 0  the problem is solved.

Does anybody know where those (Default)-properties can be looked up and changed, so that we don't have to change all (many) tables and facts?

Thanks in advance

[almeids]

There may be something you can add to crnformat.xml or fm.ini in your configuration directory (there in ReportNet, anyway).
This is the sort of thing that should have a definitive answer, so you may want to ask Cognos.
In any event, if you find such a setting it will likely only help you with new modelling going forward - changing a default initial value isn't going to take care of your existing projects.  It might be worth taking a look at the project xml and seeing if you can do some sort of global substitution with a text or xml editor there.