Default values for "Missing Value Characters"

[erna]

Hello and Guten Morgen,

I already opened a thread in "Framework Manager" for the above. But the answer (which was good and correct) didn't help me with our problem.

I have two facts from different tables which are joined by a dimension "cost center".

The facts in "is-values" has "cost centers" which are not existent in "plan-values". Therefore NULLs araise in row "plan-values" and the calculated row "balance" is "0".

I tried out in Framework Manager setting the values for "missing value characters" to "0" for "plan-value" - but as you can see in the screenshot, that didn't help either.

I know that by using "coalesce" and "case" statements the NULL can be filled with a "0" - but our users don't - and also most of them are only firm in use of query studio.

So does anybody know, if there is another way to solve this ?

Thanks in advance

[blom0344]

Looks like the typical SQL server null issue in calculations. You will need to use either coalesce or isnull() for this to work. This should typically be solved in the fact definitions in the framework and not something end-users should be confronted with..