Facts. Not showing Facts of 0

• Debbie Edwards

  SSCrazy Eights

  Points: 9217

  More actions

  January 27, 2012 at 8:14 am

  #149784

  Hi

  I have a table say for example

  Pupil DateID FactSENCHILD FACTSENACHILD

  1 01012003 0 1

  2 01012003 1 0

  3 01012003 1 0

  If I only add one fact into my query (Say I want a list of all the SEN children) it brings back all of them, even the ones with 0 against them

  I thought I needed to set Null Processing to Preserve but I cant find how you do this in 2008 R2. Any help would be appreciated.

  Thanks

  Debbie

• Chris Umbaugh

  Ten Centuries

  Points: 1334

  More actions

  January 27, 2012 at 11:55 am

  #1439559

  Debbie,

  What is FactSENChild? Is that a measurement (fact), a dimension key, or something else?

  Chris Umbaugh
  Data Warehouse / Business Intelligence Consultant
  twitter @ToledoSQL

• Debbie Edwards

  SSCrazy Eights

  Points: 9217

  More actions

  January 30, 2012 at 2:13 am

  #1439869

  Sorry its a fact table so the fact table links to the dimensions.

  I think I have actually found NULL processing now within 2008 R2. I have changed the 0 values to NULL within the fact table, set NULL processing to Preserve and it seems to be doing the right job now.