SAS/Warehouse Administrator Software

OLAP Data Store Enhancements

The code that SAS/Warehouse Administrator generates for OLAP Table Load Steps is now more efficient.

Level 2.0 code generation can now take advantage of recent PROC SUMMARY enhancements to maximize performance for OLAP Tables with multiple crossings. You can specify different sort orders for each class variable. To specify more than 32 class columns in an OLAP Table, use character _TYPE_ columns (instead of numeric _TYPE_ columns, which can support a maximum of 32 class columns).
The Load Options tab for Load Steps has a new option for OLAP Tables: Single Pass Summarization. Use this option to either maximize performance or minimize memory use.
To maximize performance. If the Load Step for an OLAP Table is generated by SAS/Warehouse Administrator, and the Single Pass Summarization option is set to Yes, data for all crossings is produced by a single PROC SUMMARY step.
To minimize memory use. If the Load Step for an OLAP Table is generated by SAS/Warehouse Administrator, and if the Single Pass Summarization option is set to No, data for each crossing is produced by a separate PROC SUMMARY step.
On the Columns tab of the OLAP Table Properties window, you can now assign a role of _FREQ_ to an OLAP Table column. For an OLAP Table, a _FREQ_ column gives the number of observations (whether any column values are missing or not) for each crossing and combination of class column values.