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
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.