January 27, 2012 at 8:14 am
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
January 27, 2012 at 11:55 am
Debbie,
What is FactSENChild? Is that a measurement (fact), a dimension key, or something else?
Chris Umbaugh
Data Warehouse / Business Intelligence Consultant
twitter @ToledoSQL
January 30, 2012 at 2:13 am
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