Author

Angela Hall
RSS
Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Angela Hall 0
Running SAS Task on Small Dataset - Workaround

Last week was incredible! The amount of activity from training, supporting and related system administration kept me very busy. The next few posts are my backlog of findings & tidbits. My boss was running into a problem with using a SAS Task from the SAS Add-in to Microsoft Office Excel

Angela Hall 0
Viewing OLAP Cubes outside of the Web

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

Angela Hall 0
BISUG Article

BISUG September News Article highlights the new SAS BI-ogsource! Providing a high-level summary of what the Blog's purpose and vision are, it also provides more information about the Blog creator Angela Hall and her employer Tekelec. BISUG is a great resource for anyone looking to use SAS BI products with

Angela Hall 0
Fallacy of Measures

When developing the business intelligence measures, you have to be entirely cognizant of the behaviors you could promote. For instance, in measuring and setting business objectives for number of defects per line of code, developers could write more lines of code to reduce the calculated result or they could document

Angela Hall 0
VB or Stored Process - Why is SAS better?

I have been attending a quality conference this week & found a gentleman who wrote 20,000 lines of VB code to allow users to generate graphs through an Excel GUI interface. After the presentation on his Visual Basic analytic system, I approached him to obtain the detail of his 8

Angela Hall 0
AMO Install says Office Products Running

Two users yesterday claimed that during the SAS Add-In to Microsoft Office (AMO) installation, an error message appeared stating that Microsoft Office Products were still running on their machine. When looking at the task bar AND the Task Manager Applications window, only the Installshield was up. Workaround - choose the

Angela Hall 0
Answering the Business Question AD-HOC OLAP

I was presented a business problem today. Seemed simple enough, however the users didn't know how they wanted to present the data. Whether it was by customer, region, order type, product, quarter, and there were four multiple measures available to analyze. I tried to program all of these options into

Angela Hall 0
Drill-through to Detail on OLAP Cubes

Well, the drill-through to detail was giving me a nasty error today. Go figure. Turns out the Library must be preassigned in SAS Management Console (SMC). Right click on the Library Name in SMC, choose Properties. On the options tab, click 'Advanced Options'. Then check the box next to 'Library

Angela Hall 0
Installing SAS Add-in to Microsoft Office

Well, setting up a SAS Installation Depot is one thing, but how then do you get users to install the SAS Add-in to Microsoft Office. After attempting to point them to the directory … root folderclient9cdmsofficeintsetup.exe some of my users received error messages such as: COM object with CLSID {C97B3405-B0CA-4B1A-9B90-C334554D81BC}

Angela Hall 0
The great analogy of SAS BI Products

There has been a lot of confusion at my company on what all of these different products from SAS are about. However, during a training session yesterday I was able to convey the variations of the SAS products by creating an analogy with Television stations and products. This gave the

Angela Hall 0
Resolution of Text Fields in Stored Processes

So you modified the SAS EG character formatted constraints to resolve automatically with surrounding single-quotes. (Seen below from Stored Process Wizard and Management Console screens.)                 Of course, the pain now is trying to pass dynamic parameters through the %stpbegin & %stpend statements.

Angela Hall 0
SAS OLAP Data Provider Install Tip

Problems connecting to the SAS OLAP Server in MS EXCEL after downloading ONLY the SAS OLAP Data Provider on a virgin SAS Machine? When installing the SAS OLAP Data Provider for use in MS Excel Pivot Tables, be sure to use the Integrated Technologies for Windows download, rather than the

Angela Hall 0
OLAP Values - Size Limit Beware

MDX has a limit to the length of values used to query. Therefore, all OLAP data must maintain a format less than 256 characters in length. You can follow the steps below to reduce the size during PROC OLAP creation (using OLAP Cube Studio) and then regeneration using the PROC

1 9 10 11