dimensional model question
From: brw <xbrian_at_mac.com>
Date: 13 Nov 2006 14:55:44 -0800
Message-ID: <1163458544.855458.3890_at_e3g2000cwe.googlegroups.com>
bit of a noob here, but ya'll are nice, right? ; )
Date: 13 Nov 2006 14:55:44 -0800
Message-ID: <1163458544.855458.3890_at_e3g2000cwe.googlegroups.com>
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?
Am I making sense? Your help is appreciated.
brw Received on Mon Nov 13 2006 - 23:55:44 CET