Non additive facts in fact table

Hi
I would like to know if non additive and additive measures can be placed in same fact table where almost all the dimensions are common and can be shared as well as the granularity is also same (for both additive and non additive one), except that few dimensions are not applicable for few non additive facts or for few additive facts. I am bulding a financial / banking model where the source system would send pre computed measures (after going through a complex logic).
Is there any best practice or guideline followed in the industry in general, which says to seprate all non additive facts into a different fact table.

Thanks

As long as the granularity is same its ok to have them in the same fact. i dont see any issues...

DMModeler wrote:Hi
Is there any best practice or guideline followed in the industry in general, which says to seprate all non additive facts into a different fact table.

Thanks

No sir. They live in the same fact table as additive facts. BI tools understand whether a metric is additive or not. For others querying the database directly, there should be documentation (usually developed by the data modeler) describing each metric and its associated metadata.