Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lohoiwai
Starting Member
1 Post |
 Posted - 2002-09-25 : 02:36:00
|
| I try to create a cube from a fact table with some records has NULL measurement values, like 'sales value'. But the cube display '0' for those cell values through Ms-Office OWC client program. I want my program not to display cube rows with all those NULL measurement values. How can I do this ?Thanks for help |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-10-22 : 14:59:55
|
| Have you tried using the HIDE MEMEBER IF advanced Member property? I think it would be set to 'NO NAME' in this instance. The Edit would be made in the dimension associated with the field in question. |
 |
|
|
|
|
|
Problem of NULL measurement value in fact table