May 5, 2009 at 7:55 am
I have the following (example data) in the star schema
Pupil Date Fact3
8163 April 2008 NULL
44968 April 2008 NULL
When it is viewed in the cube you see
Pupil Date Fact3
8163 April 2008 0
44968 April 2008 0
It includes these records in my counts. I dont understand how they are appearing in the cube. Is there any way I can omit from the cube. I have tried reprocessing the cube etc but no joy.
May 6, 2009 at 7:10 pm
Take a look at the properties on the measure that you defined in the cube. If you look at the source and expand that, what do you have the NullProcessing value set to? This could explain why it is converting the null values in the data to zeroes in the cube.
You might want to set this to Preserve if you are using SSAS 2005.
Take a look at this article and search for Null Processing - Handling Data Integrity Issues in Analysis Services 2005
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply