Home » Developer & Programmer » Warehouse Builder » Designing my dimension and fact (Oracle 10g, Unix, Windows.)
Designing my dimension and fact [message #277585] Tue, 30 October 2007 12:52
beetel
Messages: 96
Registered: April 2007
Member
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: Tue Sep 30 20:49:27 CDT 2014

Total time taken to generate the page: 0.09727 seconds