Posts Tagged ‘ MDX ’

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

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: Letting SAS Enterprise Guide Write MDX Code

January 4, 2012
By
Best Practices: Letting SAS Enterprise Guide Write MDX Code

SAS Enterprise Guide is a VERY useful client tool for SAS development and data analysis.  One the best features is the ability to see the SAS code generated from different tasks.  In addition to viewing the Base SAS code used to perform different tasks, you can also view MDX code written to create certain...
Read more »

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

SAS 9.2 OLAP Cube Identity Driven Member Level Security

January 26, 2011
By
SAS 9.2 OLAP Cube Identity Driven Member Level Security

Identity-driven member level security for SAS 9.2 OLAP cubes, as the name suggests, uses the identity of the requesting user to restrict access to specific members of a dimension, and in so doing control the subset of cube data that the user has access to. Imagine that you have an OLAP cube containing sales...
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.