Re: dimensional model question

brw wrote:

> 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

Sigh. I suppose it might be entertaining to watch what sorts of answers you get.

Then again, I suppose it might be rather tedious too.

I suggest you post your question in a data warehousing newsgroup. I don't know that you would get better answers, but nobody would have to pretend to have a theory-supported answer. Received on Tue Nov 14 2006 - 00:35:32 CET