June 3, 2011 at 7:04 am
First, if you are not using Surrogate keys as your dimension primary keys, you should be. The natural keys can still exist in the dimension, but they should not be the key that links to other tables.
Add a record to each dimension that represents N/A or something to indicate that the fact does not apply to that dimension.
When the fact table should have 2 FK columns, 1 for each of the dimensions linking to the SK of each dimension. Your measures, etc. can all filter out the N/A data.
June 5, 2011 at 8:23 am
great solution. it did solve the problem.
i do have another question:
like you suggested i added a record for each dimension. i wasn't sure if you meant to put the NA for each column in that record.
is there a way to i can specify that the NA member should not be visible?
currently i did it manually by using scope for each NA member of the dimensions attribute:
Scope
(
[Dim Customer].[Age].&[NA]
) ;
This = null ;
End Scope ;
so my question is: s there another way to indicate that this record not related to the fact?
thank you!
June 6, 2011 at 3:00 am
is there a way to i can specify that the NA member should not be visible?
Do this at the client, not at SSAS. If Excel is your client, N/A is easily filtered out using the drop down.
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply