Change the Options for PROC OLAP

Profitability Management uses PROC OLAP to generate a cube. You can modifiy the way in which cubes are generated by modifying the options to the OLAP procedure. To modify the options:

  1. Edit the file CreateCubeTemplate.sas.

    The file is located at <install_location>\SAS\SASFoundation\9.2\abmprofmva\sasmisc.

  2. Type the PROC OLAP options that you want used during cube generation.

    Type the options between <PROC OLAP OPTIONS BEGIN> and <PROC OLAP OPTIONS END >. You can type the options on a single line or on multiple lines. For example:

      <PROC OLAP OPTIONS BEGIN> 
      INDEXSORTSIZE=512 
  <PROC OLAP OPTIONS END>

    For available options, see "The OLAP Procedure" in the SAS OLAP Server: User's Guide.

  3. Type the SAS general options that you want used during the SAS session.

    Type the general options before the PROC OLAP options. For example: 
    4. /*----------------------------------------------------------------------------+                                                         
|                                                                                                                                       
| CreateCubeTemplate: Pre processing steps can be placed below but must be before the olap code                                         
|                                                                                                                                       
+----------------------------------------------------------------------------*/                                                         
    OPTION NOSYNTAXCHECK; 
    OPTION SORTPGM=SAS;
    OPTION NOOVP;                                                                                                                                    
/*----------------------------------------------------------------------------+                                                         
  Edit the following section to include customized options for PROC OLAP                                                                
                                                                                                                                        
  <PROC OLAP OPTIONS BEGIN> 
     INDEXSORTSIZE=512 
     MAXTHREADS=2 
  <PROC OLAP OPTIONS END>