Fact Table - not all dimensions required - Ari

Hi,

I would like to create a transaction Fact table for all activities of
consultants and candidates.
Some activities that are done by consultants don't involve any candidate.
Does this necessarily mean that I need two fact tables or can I use one
table and
insert -1 in columns where the activity doesn't apply for any candidate /
consultant?

Thanks,
Arik.

Fact Table - not all dimensions required - nolt

In my project, The fact table contains 26 Dims, the status just like yours.
I choose the method by using '-1' in the fields which not activity and a
field SumType contains the active fieldname list like 'ds','dsl','dslp',etc.
Then in the cube, I can easily know which dims are active by SumType and the
dim's value.
It works well