Home » Developer & Programmer » Data Integration » Designing my dimension and fact (Oracle 10g, Unix, Windows.)
Designing my dimension and fact [message #277585] Tue, 30 October 2007 12:52
Messages: 96
Registered: April 2007
I have 3 dimensions:
1. Region
2. State
3. Time
Each state belongs to a region. Let's say I have Regions 1, 2 and 3 and:
- states NY, NJ, MA are in Region 1
- states GA, FL, TX are in Region 2
- states CA, NV, KY are in Region 3
Now, if NY has made 5000 sales, NJ made 3000 and MA made 1000, Region 1 then has 9000 sales. If my customer wants a roll-up report which is per Region, as well as, a drill down report which is per state at a given time, how do I design my dimensions and fact??

Previous Topic: File Transformation
Next Topic: Object Import Order
Goto Forum:

Current Time: Sat Sep 18 22:23:19 CDT 2021