Results 1 to 2 of 2
  1. #1
    oPEEPINGTOMo is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    1

    Please Help with Setting up Fact & Dimension Tables

    Before i get started on my assignment, I have to figure out how to organize these into a fact table connected to dimension tables.



    A Coffee Store is collecting the following information:
    1. Product Type (ex: coffee, espresso, herbal tea, tea, etc.)
    2. Product Description (ex: Columbian, Cafe latte, Mint, Darjeeling, etc.)
    3. Product ID (ex: 1,2,3,4, etc.)
    4. Type (ex: regular, decaf, etc.)
    5. Area Code (for store location, such as 203, 206, 209, 210, etc.)
    6. State (for store location, such as, Connecticut, Washington, California, Texas, etc.)
    7. Market (location of the store in markets such as East, West, South, etc.)
    8. Market Size (ex: small, major, etc.)
    9. Profit (ex: measured in dollars)
    10. Margin (ex: measured in dollars)
    11. Sales (ex: measured in dollars)
    12. COGS (ex: measured in dollars)
    13. Budget Profit (ex: measured in dollars)
    14. Budget Margin (ex: measured in dollars)
    15. Budget Sales (ex: measured in dollars)
    16. Budget COGS (ex: measured in dollars)

    Could someone possibly provide some help in this that has more knowledge on it?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please define "assignment".

Please reply to this thread with any new information or opinions.

Similar Threads

  1. order by setting itself
    By byterbit in forum Reports
    Replies: 1
    Last Post: 02-02-2011, 08:59 AM
  2. Need help in setting up a DB construction
    By ClownKiller in forum Database Design
    Replies: 5
    Last Post: 01-06-2011, 06:21 PM
  3. Setting value of a formfield
    By toddbuckles in forum Programming
    Replies: 7
    Last Post: 12-27-2010, 09:46 PM
  4. Setting Value for Each Row in Subform
    By swimmermx in forum Forms
    Replies: 11
    Last Post: 07-21-2010, 05:25 PM
  5. Setting up new database
    By mduplantis in forum Database Design
    Replies: 1
    Last Post: 06-23-2010, 11:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums