Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SASMAN

    Differences between OLAP and Data warehousing concepts?

    Bironman,<br> Good question,<br> Short answer:<br> The information delivery environment in most organisations involves extracting data out of the OLTP (operational) databases, manipulating and transforming this data a bit and then storing it along with data from many other disparate sources...
  2. SASMAN

    Data Mining what are its uses

    Hunch,<br> Amen brother check out www.sas.com.<br> <br> Data mining is discovering previously unknown patterns in large volumes of data. These patterns reveal wisdom that has real business significance and when acted upon make a measurable impact to a business's bottom line.<br> <br> You better...
  3. SASMAN

    SAS tip of the day.

    Have you used the data step debugger?<br> If not, the next time you submit a data step that gives you those ugly ERRORs in the log or maybe when your data step gives you unexpected results, try the DEBUG option in the data step to envoke the debugger. There are a bunch of commands available...
  4. SASMAN

    Which OLAP tools allow attributes as row headers

    Buddy, Have I got good news for you.<br> If you think about multidimensional databases and OLAP what you have is a bunch of dimensions or qualitative attributes. These dimensions define your crossings in the MDDB (MultiDimensional DataBase). Generally these attributes are of character or date...
  5. SASMAN

    What is olap?

    Hi folks,<br> "Online Analytical Processing (OLAP) - enables better decision making by giving business users quick, unlimited views of multiple relationships in large quantities of summarized data. OLAP offers high-performance access to large amounts of summarized data for complex...
  6. SASMAN

    Star Schema and Technical Keys

    WHArchitect,<br> At last, someone who understands.<br> Just to clear up some misperceptions.<br> <br> The Subject Area Model is not specifically an ERD in the traditional sence of the word. It is a highly abstracted model representing the subject areas in an enterprise and the relationship...
  7. SASMAN

    Star Schema and Technical Keys

    Kalyan,<br> When you do the analysis and design of your DWH, a good tip would be to start by interviewing all the stake holders in the project to determine which business units will ultimately use the DWH.<br> Once you've identified these areas, speak to representatives from each area to...

Part and Inventory Search

Back
Top