Posts Tagged ‘ SAS OLAP Cubes ’

SAS OLAP Cubes: Automatically Collect ARM Performance Logs

June 18, 2012
By
SAS OLAP Cubes: Automatically Collect ARM Performance Logs

Collecting ARM logs can be extremely useful when tuning OLAP cubes for faster response.  The ARM log (which stands for Application Response Measurement) collects vital usage information for OLAP cubes using the SAS OLAP Server logging facility.  SAS OLAP Cube studio can analyze these logs to assist with aggregation building to make OLAP cubes...
Read more »

Tags: , ,
Posted in SAS | Comments Off

SAS OLAP Cubes: Viewing Member Properties in Excel and Enterprise Guide

May 7, 2012
By
SAS OLAP Cubes: Viewing Member Properties in Excel and Enterprise Guide

As a follow-up to my earlier post on taking advantage of OLAP member properties, you can also display OLAP member properties through the Add-in for Microsoft Office as well as SAS Enterprise Guide.  I’m a huge fan of Enterprise Guide, so it’s nice to have that ability but even nicer when the more common...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

SAS OLAP Cubes: Taking Advantage of OLAP Member Properties

May 2, 2012
By
SAS OLAP Cubes: Taking Advantage of OLAP Member Properties

Have you ever had a requirement to display additional details about data in a report but couldn’t find a good way to do so?  Showing OLAP Member Properties in a SAS Web Report could be a useful way to sneak more details about data into a crosstab table. Crossing Multiple Dimensions with High Cardinality...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

OLAP Cube Studio: Looking at PROC OLAP Code

March 5, 2012
By
OLAP Cube Studio: Looking at PROC OLAP Code

If you have never worked with OLAP code – then you might be curious how it works and what it looks like. Some developers use SAS OLAP Cube Studio to start their cube building process since it saves some of the typing required. Let’s review some of the code. [Adv Users: check out Steve's...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

Excel and OLAP Viewer: Not enough room for the Cube!

February 29, 2012
By
Excel and OLAP Viewer: Not enough room for the Cube!

When you use the OLAP Viewer in Microsoft Excel you may have run into the window borders – literally.  Your cube and analysis needs more space!   Scroll, Scroll, and Scroll to See the Cube Data  When you open the OLAP cube in the MS Excel OLAP Viewer the default cube size dictates the...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Peek Inside SAS BI Book: Building Business Intelligence with SAS

February 4, 2012
By
Peek Inside SAS BI Book: Building Business Intelligence with SAS

You may be aware by now, our new SAS BI book Building Business Intelligence with SAS:Content Development Examples launched last week on the SAS Press site. That’s right, SAS Press or Amazon will be delighted to bring a copy of this SAS BI book to your door. When Angela and I set out to write...
Read more »

Tags: , , , , , , , , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off

SAS OLAP Cubes: Using PROC SQL and MDX to Query OLAP Cubes

January 11, 2012
By

SAS PROC SQL has a lot of neat ways you can extract and manipulate data.  In my experience, SAS users typically write PROC SQL to query SAS datasets or relational tables in databases.  You can also... [[ This is a content summary only. Visit my webs...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

Best Practices: To Write or Not to Write PROC OLAP… That is the Question

December 28, 2011
By

There are 2 ways to develop OLAP cubes in the SAS EBI platform: using SAS OLAP Cube Studio or by writing the PROC OLAP statement by hand and submitting the SAS program.  There are pros and cons for both that I will go through in this post.  Personall...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.