Posts Tagged ‘ OLAP Cube Studio ’

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

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

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

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

SAS OLAP Cube Studio 9.3: New screen layouts

November 2, 2011
By

I installed the updated SAS Business Intelligence package (version 9.3), but mostly I have been playing with the stored process interface where there were some major changes (more about that in future posts).  This morning I opened SAS OLAP Cube Studi...
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.