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.
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.
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.
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.