In order to make the OLAP drill through data available as data tables in the Enterprise Guide, all you need to do is change the option to automatically insert the results as a data set in the project. This is extremely useful if part of your workflow includes navigating through
I have recently discovered “mind mapping.” Mind mapping is not a new concept, but since I (re)learned it, I’ve found it to be an excellent tool for analyzing business problems and processes. I thought you might find it interesting too! Here’s an example: The other day, I was thinking about
The SAS office in New York City has one of the best views in the city. Sitting on the 47th floor of a skyscraper on 7th Avenue, the Executive Briefing Room overlooks Central Park and it has a highly distracting view – especially on such a nice sunny day. What
“Our performance last month was 46.” Oh, you don’t have to thank me, I was just doing my job. Not very well, I might add. 46? 46 what? Or 46 who’s? Without context, 46 is just a number, just data. In context, perhaps that’s 46 out of 48 (not too
In SAS 9.2, internal accounts can be created and utilized within the metadata and then do not require host (or domain) accounts defined elsewhere. By default, the sasadm@saspw is one such internal account. Unless you specifically declare an exception, the server-level policies for routine password resetting and locking (such as
SAS procedure SUMMARY is a quick method of converting your detail table to a fully summarized one. Included is a sample. The key option to set is the NWAY - this generates the lowest level of summary for use in the OLAP cube. Essentially - the class statement contains all
In the past couple months, this scenario has occurred twice. So thought I'd share a quick remedy ~ and save for my future reference when this occurs again :). In Star Schemas, there are sometimes occasions where the data quality isn't exactly perfect. And sometimes, for some users/companies, this is
Last week, SAS held its annual analyst conference in Steamboat Springs, Colorado, where SAS leaders and SAS customers spoke to a room full of industry analysts about the direction of SAS products and business strategy for 2011 and beyond. It's a pretty exclusive event, so not many attend. But -
OLAP Calculated Members need to be tested to ensure that the numbers are correct in various tools. What we recently found was that the member tested properly in the OLAP Studio View Cube but then in Web Report Studio, the measure wasn't correct. Essentially, it was calculating the custom measurement
Business Intelligence is a phrase that means many things to different organizations, which is why all BI vendors have their own definition. The term was coined in 1958 by Hans Peter Luhn of IBM*, who described it as “the ability to apprehend the interrelationships of presented facts in such a
When upgrading from an existing 4.2 client install of SAS Add-in to MS Office, you are not prompted to enable the Outlook portion of the Add-in. As SAS points out in the KB Post http://support.sas.com/kb/40/272.html, there is a 'Switcher Utility' available in the client install. When running this, I would
I've written about this topic before, but find that more people are interested in how this works. Hoping to provide more detail below. Let me know if I missed anything! When using the 'GEO' dimension type in SAS OLAP Cubes, users will not see anything new unless the OLAP cube
I've never met Sy Truong face-to-face. (That will be one of the top items on my SAS Global Forum 2011 to-dos.) I’ve talked with him on Twitter and enjoyed his blog so much that I listed it in an edition of the SAS Tech Report. I’ve even talked with him
Okay…I don’t usually do the rah-rah SAS stuff, but it was a really great week here and I wanted to share. The Analytic Cheerleader is getting out her pom-poms and cheering for SAS! Since I’ve been a SAS employee for exactly 3 months, I thought it was a good time
In the latest news from the frontier of Internet technology, the NY Times presented an interesting article about the work that high tech providers are doing to ensure maximum system availability. Companies strive for the "5 nines," or 99.999% availability, although a more realistic number is a "4 nine," or
I think being greedy is a virtue – especially when you are trying to feed your intellectual curiosity! You can satiate that hunger at SAS Global Forum, which offers an unlimited buffet of thought-provoking ideas and discussions. To give you a glimpse of what to expect at Las Vegas this
If I think back to the training, education and networking opportunities in my business intelligence and analytics career that have made the most difference, SAS user groups (SUG) stand out. As a new user to SAS many moons ago local, regional and international groups helped me develop skills that I
The term "analytics" has become so overused that I'm not sure anyone really knows what it means anymore - or at the very least, it means a lot of different things to different people. Sometimes analytics gets blended in with "business analytics" which gets blended in with "business intelligence." What
In our SAS Hartford regional office, there is an annual tradition – the holiday breakfast. This will be my first breakfast with my office mates and I’m looking forward to the famous conference room waffles cooked up by a certain insurance account executive. Thinking about those waffles reminded me of
As I mentioned in an earlier post, having an information strategy and analytic goals tied to key business objectives are critical components of being able to competitively leverage your analytic assets and capabilities. In general, in the insurance industry vertical I support, we don’t see many organizations that have a
If you're like most large organizations, you've got a bunch of business intelligence and analytic applications at your fingertips. In my prior organization, a large insurance company, I believe the magic number of tools that the organization had to support was north of 40. No kidding. Now, this is a
It's webinar time again! This hour session is designed for business analysts, directors of analytics and BI, and business users on the topic of Centers of Excellence. This live "101" webinar will take place live on Aug. 18, and it's the fifth installment in the 2010 Applying Business Analytics Webinar
While reading a datadoodle blog post, Self tracking is business intelligence, I was taken back to my days in the advertising and PR agency world. The blog references Peter Drucker’s book, The Effective Executive that suggests tracking your day (or having your secretary do it) in increments of 15 minutes
The SAS Social Media Analytics product launch was a huge hit with the press at SAS Global Forum. I wrote about it below, a lot of analysts and social media pros are blogging about it too, and it seemed for at least a few hours last Monday that everyone on
It is definitely easier to force single selections for prompts used in SAS Stored Processes, however it isn't very usable when the majority of users need to select multiple values. For example, let us say we create a prompt for region (called 'region_prompt') and then use that in the query
The SAS Business Intelligence suite includes the ability to map data via the ESRI Map Service within various web clients (and even Enterprise Guide). Steps: Create an ESRI Map via ArcMap Publish to ArcGIS Server via ArcCatalog Define a New Map Service in SAS Management Console Set a cube dimension as
Have you seen the new SAS Add-in to MS Office? There are new features worth pointing out & hopefully this will help convince you that now is the time to switch! In SAS Management Console, three built in security roles have been estabilished to accurately assign functionality per user or group.
While working on a SAS OLAP and ESRI project, I was asked about geocoding addresses. Fortunately, Jeff Phillips, one of the SAS presenters at SESUG09 gave a talk about PROC GEOCODE. In SAS 9.2, street addresses can be given x/y coordinates via the geocode procedure using the 5 or 9
With local data highlighted in Microsoft Excel, you can then "Copy to SAS Server" to run SAS analytical tasks. The menu bar ('SAS' -> 'Active Data' -> 'Copy to SAS Server') is also the image below: SAS provides a knowledge base entry at: http://support.sas.com/kb/32/009.html to show how this can be done with a
Bulk editing of multiple data elements An example of this is when you have 10 items that are numerical and therefore are set to allow measures, but should be classified as categorical (such as serial numbers and ids), you can select all of these values, now you can in one
