<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">My understanding is as follows:<br>NULL as a value (not literal) is for Members that do not exist physically but do logically such as [Geography].[All Geography].Parent. When you pull a cell value for which one member of the context is NULL, you get a NULL value as a numeric (or String etc) for the cell value as opposed to an EMPTY value which is when the membes all exist but there is no value in the cube at that position.<br><br>After that there's lots of tricky things you can do with numeric NULL values like addition, multiplication etc E.g. A is a numeric expression that evaluates to NULL and B is a numeric expression that doesn't. What does A+B evaluate to?<br><br>As for the 'IS NULL' construct, that's to test Member
expression and numeric expression for having the NULL value given that NULL=NULL yields false. You can also use NULL explicitly in Range function:<br>[Time].[1997].FirstChild : NULL<br><br>Here's an example of an MDX query that should test a problem (not tested anywhere):<br><br>WITH MEMBER [Time].[1997].[Test] AS '[Time].[1997]+0'<br>SELECT <br>{[Time].[1997], [Time].[1997].[Test]} on COLUMNS,<br>{[Store].[All Stores].Parent} on ROWS<br>FROM [Warehouse Sales]<br><br>Michael<br><br>PS: I've got code for running multiple tasks going but without test cases. Found some time. Taking longer than expected. Will post by next week but don't want to disturb your efforts to release.<br><br><br><br></div></div><br>
<hr size="1">
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur <a href="http://fr.rd.yahoo.com/evt=42054/*http://fr.answers.yahoo.com">Yahoo! Questions/Réponses</a>.</body></html>