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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- SASMAN
- Post #3
- Forum: Data Warehousing/Big Data
-
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...- SASMAN
- Post #4
- Forum: Data Warehousing/Big Data
-
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...- SASMAN
- Thread
- Replies: 1
- Forum: SAS Institute, Inc. solutions
-
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... -
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... -
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...- SASMAN
- Post #7
- Forum: Data Warehousing/Big Data
-
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...- SASMAN
- Post #5
- Forum: Data Warehousing/Big Data
