dbTalk Databases Forums  

Unable to get Null measure values in OLAP cube...

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Unable to get Null measure values in OLAP cube... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GB
 
Posts: n/a

Default Unable to get Null measure values in OLAP cube... - 06-24-2005 , 02:08 PM






Hello:
I have a lot of NULL values in data fact table for measure column
which is Numeric data type. When I created a cube, it showed me
0 value instead of NULL. Could you give me a hint how to preserve
NULL value for the measure in a cube?

Thanks,
GB



Reply With Quote
  #2  
Old   
Richard Tkachuk [MSFT]
 
Posts: n/a

Default Re: Unable to get Null measure values in OLAP cube... - 06-24-2005 , 06:13 PM






In AS2000, split the measures you want to retain null behavior and eliminate
the rows from your fact table.

In AS2005, set the null handling behavior on each measure to retain.

--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"GB" <v7v1k3 (AT) hotmail (DOT) com> wrote

805 (AT) clgrps13 (DOT) ..
Quote:
Hello:
I have a lot of NULL values in data fact table for measure column
which is Numeric data type. When I created a cube, it showed me
0 value instead of NULL. Could you give me a hint how to preserve
NULL value for the measure in a cube?

Thanks,
GB





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.