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 »
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 »
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 »
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 »
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 »