OLAP reports can let you drillthrough to the input data being used for the cube (assuming the cube was built to offer drillthrough), and they can offer Drill and Expand buttons to show different levels of the cube. Cascading filters appear in the prompt window before the relational report is rendered. Each prompt displays a list of values depending on the selections made in the previous filter. So, Filter 2 displays values based on selections made for Filter 1, and Filter 3 displays values based on selections made for Filter 2. ... View more

EGuide only displays a portion of the impoted data, so it can handle very large datasets.  Sounds like a problem that you may want talk to tech support about. ... View more

transpose might like to hold the entire file in memory. That will cause problems for very large data. If you know the data structure, you are that step ahead of proc transpose and will probably make a more successful transpose in a data step. ... View more