dimensional model question

bit of a noob here, but ya'll are nice, right? ; )

Scenario:
Building an EDW for a dashboard app.

First element of the dashboard is...Finance, of course (probably be sep. elements for expense, revenue and profitability).

Under revenue, users would like to drill into region, revenue category, etc

The question:
Should this all go into one fact table, or would I be better off separating expenses from sales?

I kinda think I need to separate (a sales table and an expenses table), since sales will use different dimensions than expenses (right?).

Am I making sense? Your help is appreciated.

brw Received on Mon Nov 13 2006 - 16:55:44 CST