Included are two quick references to tuning OLAP Cubes:

Server Tuning Information ~ http://support.sas.com/documentation/cdl/en/biasag/61237/HTML/default/viewer.htm#a003145996.htm

Cube Tuning Information ~ http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a002605609.htm

Also, you can add aggregations to the OLAP cube to improve performance. As mentioned in my earlier post, you should consider doing Advanced Aggregation Tuning to provide presummarized measures of various dimensional levels (especially those that are frequently used for reporting and analysis). Turn on these logs via SAS Management Console, just remember to turn it off afterwards as it can eat up some filespace.