Posts Tagged ‘ OLAP ’

NOTE: Clean Your Cubes

November 19, 2012
By
NOTE: Clean Your Cubes

It's not spring-time, but it's still worth giving a thought to the cleanliness of your environment, for the benefit of reducing complexity and of reducing space usage. Angela Hall posted a great article about Cleaner OLAP Cube Physical Folder Structu...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Use OLAP data sources from SAS Stored Processes

June 21, 2012
By

So are you now dreaming big? Coming up with other ideas for how SAS Stored Processes can be leveraged in your installation of SAS? As I mentioned in last week's post, you could use OLAP cubes as a data source for your SAS Stored Process. Here is how I ...
Read more »

Tags: , ,
Posted in SAS | Comments Off

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

Selecting multiple individual dates in prompted reports

June 8, 2012
By

The date prompt from SAS Prompt Framework provides the options of single selection or a range, however what if you need to select multiple individual dates such as Monday (May 28), Wednesday (May 30), and Friday (June 1) of last week? There are a few a...
Read more »

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

Change your passwords without locking out your connection

June 7, 2012
By

Did you change your LinkedIn password yesterday? (If you didn’t, you should!) But did it happen to be the same as your corporate password? First, tisk tisk. Second, change your corporate password NOW! Ok, now that this is done ~ don’t let your save...
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

MDX: Dynamically Hiding Measures for Compliance

March 21, 2012
By
MDX: Dynamically Hiding Measures for Compliance

OLAP cubes are great for summarizing data very fast – I love them .   In certain environments, HIPAA compliance for personally identifiable data might be a concern.  Even at the lowest grain of a cube it might be possible to identify the specific detail data beneath the surface if the summarized number is small...
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.