Results 1 to 3 of 3
\r\n \r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n Hi there, can someone tell me please what kinds of things I should look out for when dsigning my data warehouse, building OLAP Cubes and normalisation? What issues and limitations surround them?\r\n
\r\n
\r\n\r\n \r\n\r\n\r\n
\r\n \r\n \r\n \r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
\r\n
\r\n\r\n'; pd[4522685] = '\r\n
  • \r\n
    \r\n
    \r\n \r\n \r\n \r\n \r\n #2\r\n \r\n \r\n \r\n \r\n \r\n
    \r\n\r\n
    \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n Pat Phelan is offline\r\n\r\n \r\n \r\n Resident Curmudgeon\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    Join Date
    Feb 2004
    \r\n
    Location
    In front of the computer
    \r\n \r\n
    Posts
    15,579
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n\r\n
    \r\n \r\n
    \r\n \r\n \r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n First and foremost, talk with your users. They\'ll often have a lot of vague ideas, many of which are focused on a specific "pain point" for them, that when analyzed will show you a "big picture" problem that is both easier to solve from an OLAP persepctive, and will serve more people in the long run. In other words, you need to talk with your users, but talk lots with all of them, then think through those discussions. The results will often surprise you!
    \r\n
    \r\nThe limitations of each product are specific to that product. I don\'t know of any generic "OLAP Limitations" that apply to every product that is available.
    \r\n
    \r\n-PatP
    \r\n
    \r\n
    \r\n\r\n \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[4523461] = '\r\n
  • \r\n
    \r\n
    \r\n \r\n \r\n \r\n \r\n #3\r\n \r\n \r\n \r\n \r\n \r\n
    \r\n\r\n
    \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n loquin is offline\r\n\r\n \r\n \r\n Super Moderator\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    Join Date
    Jun 2004
    \r\n
    Location
    Arizona, USA
    \r\n \r\n
    Posts
    1,848
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n\r\n
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n \r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n THere\'s also a couple of database installments in these tutorials that may help as well.\r\n
    \r\n
    \r\n\r\n \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n \r\n
    Lou
    \r\n使大吃一惊
    \r\n"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    \r\n"I have my standards. They may be low, but I have them!" - Bette Middler
    \r\n"It\'s a book about a Spanish guy named Manual. You should read it." - Dilbert

    \r\n
    \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; // next/previous post info pn[4522619] = "4523461,4522685"; pn[0] = ",4522619"; pn[4522685] = "4522619,4523461"; pn[4523461] = "4522685,4522619"; // cached usernames pu[0] = guestphrase; pu[136397] = "syed263"; pu[61789] = "Pat Phelan"; pu[75123] = "loquin"; // -->

    Threaded View

    1. #1
      Join Date
      Jan 2006
      Posts
      2

      Limitation of Data warehouses, normalisation and data cubes?

      Hi there, can someone tell me please what kinds of things I should look out for when dsigning my data warehouse, building OLAP Cubes and normalisation? What issues and limitations surround them?

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •