Thumbnail
Access Restriction
Open

Author Dhillon, Rupinder ♦ Inc, Dhillon Consulting ♦ Droogendyk, Harry ♦ Inc, Stratia Consulting
Source CiteSeerX
Content type Text
File Format PDF
Subject Domain (in DDC) Computer science, information & general works ♦ Data processing & computer science
Abstract As the amount of data that is captured electronically increases exponentially, more and more organizations are turning to OLAP Cubes as a way to surface data in a meaningful way. OLAP, or Online Analytical Processing, provides a multi-dimensional view of aggregated data. It provides quick and easy access to facts, figures and statistics and gives the user the flexibility to change the view of the data to hone in on the aspects that are most pertinent to them. This paper will focus on how SAS Programmers can also take advantage of the benefits of storing data in OLAP cubes. This paper will discuss: Getting familiar with the MDX viewer in SAS EG Creating measures on the fly with SAS EG Creating permanent calculated members using MDX and SAS EG Using PROC SQL and MDX to query cubes Some handy MDX functions Using SAS functions with MDX With some basic knowledge of MDX, along with an understanding of querying OLAP cubes, we’ll show how SAS Programmers can leverage OLAP Cubes in their everyday work.
Educational Role Student ♦ Teacher
Age Range above 22 year
Educational Use Research
Education Level UG and PG ♦ Career/Technical Study
Learning Resource Type Article