Facts. Not showing Facts of 0

  • 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

  • Debbie,

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

    Chris Umbaugh
    Data Warehouse / Business Intelligence Consultant
    twitter @ToledoSQL

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply