Unlike prior versions of SAS OLAP technology, 9.2 provides more options for maintaining and refreshing OLAP cubes. With this comes some discussion about what each one does alone, and how pairing these techniques really provides SAS OLAP Server Administrators and cube developers a cornucopia of OLAP options. PROC OLAPOPERATE Remember
Drill-through to detail is the ability to right click within a cell of a web report or OLAP viewer and request the detail source records that make up that specific cell's measure. The maximum number of records, by default, is set to 300,000. Feasibly the report user could download all
SAS allows for three different cube storage mechanisms: 1. MOLAP The traditional SAS OLAP Cube will all aggregations / nway stored on a physical file structure accessible by the SAS OLAP Cube Server. 2. ROLAP A relational OLAP cube - where no aggregations are stored and SAS points to the
I was struggling with a calculated member that completes a distinctcount of members in a dimension, the performance was simply unacceptable. After attempting several other measures such as count(), processing changes on the source data, etc, I sent out a msg on Twitter asking for advice. Once again, why aren't
Enterprise Guide has a wonderful OLAP Viewer if you don't/can't use the web stuff. I went to the SAS Course 'Creating and Exploiting OLAP Using the SAS System' which has in the Course Notes some great steps on using EG for OLAP Viewing. Basically, the 'Tasks by Category' menu has
SAS software supports two kinds of procedures: interactive and non-interactive. Most SAS procedures are non-interactive. They begin with a PROC statement, include one or more additional statements, and end with a RUN statement. When SAS encounters the RUN statement, the procedure executes all statements, then exits. On the other hand,
Have you ever submitted a stored process, and instead of the expected output, you saw errors or no output at all? Depending on how you submit the stored process, various logs are available to assist you with debugging. This article provides guidance for understanding which situations call for which logs, where to find each log, and what you should look for in each log.
Have you ever needed to run code based on the client application that you are using? Or have you needed to know the version of SAS® software that you are running and the operating system that you are running it on? This blog post describes a few automatic macro variables
Many larger SAS deployments have multiple instances of similar SAS-related servers. For example, a distributed SAS Enterprise BI environment may have several machines running instances of the object spawner or the OLAP server. Similarly, all of your distributed SAS Visual Analytics deployments have worker nodes that are typically dedicated Linux
As we have seen my previous post "Seeing SAS data through metadata", there is a fundamental difference between accessing a SAS library using a physical reference or a metadata reference to that library. By now, you should now be an expert on the nuances of physical references to SAS data
SAS programmers will immediately recognize the importance of reviewing the SAS log to provide insights into what’s going in a SAS program. As a SAS Administrator, however, you rarely have the luxury of being able to sit down with a cup of coffee and read through the server logs to
BASE SAS users are already familiar with the autoexec file. This is a .sas file that typically resides in the installation folder of the SAS executable. Instructions for setting it up in UNIX, Windows, and other environments is readily available on the SAS website. In SAS BI configurations there are
In order to support a SAS Server Architecture, administrators must know where all the log files from the various SAS Business Intelligence services are located. By default, each service that generates a log will create it within the services' own configuration folder structure. For example, the metadata server log is
Many people mistakenly assume that just because you want to use a SAS program to access a protected resource (such as a database table), you must include the credentials for the resource inside your program. Few things cause a database administrator to lose more sleep than coming across this within
SAS Vice President of Technical Support Annette Harris announced the features that will be added to SAS software and solutions as voted on by users through the SASware® Ballot. “Jim Goodnight always stresses the importance of listening to you, our users, and to be receptive to your ideas and suggestions,”
If you deploy the SAS 9 environment on Windows, you may have multiple SAS processes running on a single box (metadata process, OLAP server, multiple workspace servers). Windows Task Manager doesn't provide a great way to distinguish one sas.exe process from another, but Process Explorer does. Process Explorer lets you
Editor’s note: This is the third article in a series by Conor Hogan, a Solutions Architect at SAS, on SAS and database and storage options on cloud technologies. This article covers the SAS offerings available to connect to and interact with the various database options available in Microsoft Azure. Access
Editor’s note: This is the first article in a series by Conor Hogan, a Solutions Architect at SAS, on SAS and database and storage options on cloud technologies. This article covers the SAS offerings available to connect to and interact with the various database options available in Amazon Web Services.
Let’s say that you are administering a SAS 9.4 environment that is working just fine. You’ve checked that your full backups are indeed happening and you’ve even tried restoring from one of your backups. You are prepared for anything, right? Well, I’d like to propose a scenario to you. You
A colleague and I were looking for a good example of how analysts used to use graphics to report data, a data visualization before and after, so to speak. We needed a good "before" screenshot for a “before and after” comparison for our SAS Global Forum 2015 paper, Visualizing Clinical Trial Data.
SAS System software supports a wide variety architecture and deployment possibilities. It’s wild when you think about it because you can scale the analytic power of SAS from the humblest single CPU laptop machine all the way up to hundreds-of-machines clusters. When SAS deployments involve many machines, it’s natural to
As SAS administrators, I know you are as excited as I am by the ability of SAS Environment Manager to monitor, in detail, the performance of their SAS environments. Now, we have a robust tool to monitor, measure and report on the performance of the various SAS components. An added
In den letzten Jahren hat sich einiges getan im Business Intelligence und Business Analytics Umfeld. Big Data - also der zeitnahe Umgang mit großen und polystrukturierten Daten - ist in aller Munde und zeigt vielen gewachsenen BI-Installationen die Grenzen auf. Aber auch die Art wie BI daher kommt hat sich
➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in
My journey to SAS Global Forum each year resembles a Gartner “Hype Cycle”. Every year, I leave the conference with a million ideas about how I can take what I’ve learned back into my own practice and think (foolishly) that I should write a paper on this or that. Then there
Big Data ist in aller Munde und beflügelt vom aktuellen Hype werden damit hohe Erwartungen verknüpft. Das bloße Sammeln bzw. Speichern großer Datenmengen ist jedoch nicht zielführend. Obwohl viele Unternehmen heute über eine gewaltige Menge an Daten verfügen, steht deren effektive Nutzung oftmals erst am Anfang. Die zentrale Herausforderung besteht
Last time we discussed the fundamentals of SAS data and how we reference that data in SAS Foundation. Now, we will turn our attention to how you access and protect data when you want to expose data through SAS clients versus the traditional LIBNAME method.
So let’s get down to it, what exactly do we mean by data in SAS? We hear all about “big data”, tiny data, datasets, metadata, OLAP, relational data, but what do I really need to know when it comes to SAS?
It's not too early to think about what presentations and pre-conference training to attend while at SAS Global Forum 2012. Tutorials are an extra-fee that is only available as additions to a conference registration. But you can get a deal: Registration package 3 includes your choice of one Sunday Pre-Conference Tutorial.
Jessica Dunn, a Bank of America Vice President, helps coordinate the planning, forecasting and performance of the bank's credit card services. In January 2010, the credit card services division began investigating new business intelligence products to help provide more efficient forecasting and more informed business decisions in general. The decision
