Null Measure Data Processing....

Hello,

I created a cube with measures and dimensions using AMO. The measure group comes from a table called "client_coverage", and there is a measure called "count". There are also 2 dimensions, namely "TimeZone" and "Source".

For example,

Coverage

ID TimeZone Source

-- -- --

1 null null

2 null null

I've programmably set the "null processing" for measure "count" to "preserve", and both dimensions' UnknownMembers to "visible" and set their key column's "Null Processing" to "Unknown Members".

However, when I browse the cube, there is no number shows up for the coverage "count" measure. I've checked that the dimensions are setup correctly with proper relationships to the coverage measure group.

Interesting thing is, if I remove the cube dimension manually from the cube using the Business Intelligence studio and then right away add them back in. Then the number shows up.... like :

Source Count

- --

Unknown 2

I wonder if there is something needs to be done in my AMO program when adding the cube dimensions (the things that the BI studio does automatically).

Any help is very appreciated..

Thank you very much,

Sincerely,

Hsiao-I

Ah.. I found out that I have to set the relationship between the measure group and the dimension's "Null Processing" property to the same as the Dimension's Null Processing property... that solved the problem!!