Modifying and Maintaining Cubes

Adding SAS System Options to a Cube

When you build an OLAP cube, it is often necessary to include additional SAS code that must run prior to the creation of the cube. This includes the creation of user-written formats, PROC statements, and format search paths for the formats that are used on input tables. The Advanced Cube Options dialog box is accessed from the Cube Designer - General dialog box. It provides two entry tabs, Submit SAS Code and Format Search Path. Both tabs provide entry fields for SAS code. You can enter any text in the fields. There is no validation of the text that is entered. However, error messages are sent to the SAS log.

The text is saved to the cube metadata in the SAS Metadata Repository and is used every time the cube is created. You can edit or remove the text after it is initially entered. Highlight the text and make any needed changes, or use the DELETE key to remove the text. Select OK to save your changes.

Submit SAS Code

You can use this tab to enter a PROC statement or any SAS code that you want to submit before the cube is created. SAS code is submitted before any format search path.

Format Search Path

You can use this tab to enter names of catalogs or libraries for the format search path. The catalogs and libraries must be separated by a blank and will be searched in the order in which they are listed. You use the SAS system option FMTSEARCH= here.

Note: For more information about SAS formats, see "Formats" in SAS Language Reference: Dictionary. [cautionend]

Note: When you build a cube with SAS OLAP Cube Studio, the format search path is saved with the cube metadata in the SAS Metadata Repository and used every time the cube is recreated. However, if you submit PROC OLAP code through a SAS session, outside of SAS OLAP Cube Studio, the format search path is ignored. PROC OLAP does not read the information from the SAS Metadata Repository or write the information to the SAS Metadata Repository. [cautionend]

Top of Page