Replacing <Null> by 0 in Crystal Analysis

[jschya]

hi,
is there any option in crystal analysis to replace the <Null> values by e.g. 0. For what reason ever is it impossible to replace these unwanted values while generating the cube.
regards
johannes schya
nuremberg, germany

 

[AMJackson]

My understanding of the way things work is that this is not really possible.
MSOLAP will treat NULL as 0 in most circumstances anyway.

Why do you want to replace <Null> with 0? What is the effect that you are wanting to see? Or is it that you just don't like the word <Null>?

AMJ

 

[jschya]

thx for the reply.

It's not that i don'r like the word <Null> but it's a request from our customer to replace it in CA.

Browsing the web there seemed to be two solutions to the problem, but neither seems working or feasible for the time being:

1) It should be possible to change the mdx statement and replace the <Null> by using the IsEmpty function. A full description is found in microsoft kbase:
Q244650 The solution is not feasible as it requires the modification of any mdx statement and the changes are in vain as &quot;CAP will regenerate any MDX code if you change the layout of yourt worksheet ...&quot;

2) Replacing the <Null> item by a calculated member allows the formatting of the field as '#;#;0;NULL', but as soon as the cube is published via eportfolio, the viewer ignores the format and the <Null> values are displayed.

regards
johannes schya