Exploiting OLAP Cubes with SAS 9: A Hands on Workshop

In a related hands-on workshop (Nelson, 2008 - Building OLAP Cubes with SAS 9: A Hands on Workshop), we demonstrated how to use OLAP Cube Studio to build and manage an OLAP cube. In this workshop, we will take those cubes and learn how we can view them in a variety of SAS tools which might include: SAS Enterprise Guide, Microsoft Excel with the SAS OLAP Data Provider, and the SAS Information Delivery Portal. Finally, we will discuss best practices related to delivering cubes to your end users and we will learn how you can build web interfaces to exploit your OLAP cubes. In addition, we will discuss how you can secure your OLAP cubes so that you can restrict what data users/ group can see.