When using drill-through or individual aggregation tables for an OLAP
cube, the library associated with the tables must be defined to the SAS
OLAP Server instance. This can be accomplished by one of four options:

  1. Hard-code the LIBNAME statement in an autoexec file.
  2. Hard-code the LIBNAME statement in the SASMain configuration file.
  3. Pre-assign the library through SAS Management Console starting
     in SAS 9.1.2.
  4. Dynamic assignment from metadata libraries, starting in SAS 9.1.3 Service Pack 4.
     When the OLAP server encounters a drill through library that is not assigned,
     it will attempt to assign the libname based on the library definition in metadata.

If the library has not been assigned, you might receive error messages
in your client application when drill-through is selected or when
navigating through your cube. In SAS Enterprise Guide, for example, when
you attempt to drill-through, you will receive an error message similar
to:

   Enterprise Guide cannot find the data file: OrionStar-Detail for
   (Europe, All YQM)

To assign a libref in an autoexec:

   1. Create an autoexec.sas file that contains the LIBNAME statement to
      the underlying data.

   2. In the SAS OLAP Server Configuration file (sasv9_OLAPServer.cfg)
      or shell script (OLAPServer.sh), you need to comment out the
      -NOAUTOEXEC option and add the -AUTOEXEC option as follows:

      /* -noautoexec */
     -autoexec "your-path\autoexec.sas"

To assign a libref in your config file or shell script:

   1. The file can usually be found in your SAS environment under
      SASMain or SASMain\OLAP Server.

   2. Add the SET option to define a library in the necessary
      location. For example:

      -set drilldat ("c:\SAS\OLAP\Lev1\data\OrionStar")

To pre-assign the libref in SAS Management Console (SAS 9.1.2 or
later):

   1. Define the library as usual in the Data Library Manager of
      SAS Management Console.

   2. On the Properties page of the New Library Wizard, click "Advanced
      Options."

   3. In the Advanced Options window, on the "Pre-Assign" tab, select
      the check box to pre-assign the library.

      You can also enter the Advanced Options window from the Options
      tab of a library's properties.

To use dynamic assignment, the library must be defined in SAS Management
Console. The server will attempt to assign the library at the first request. 
See SAS Note 16869 for details. This feature is useful 
for libraries created after the OLAP Server has been started, or in instances where you
would prefer to not preassign the library.

Please note that it is recommended that you restart your SAS Metadata
Server for any of the above changes to be applied. It is required that
you restart the SAS OLAP Server to pick up the changes.

Please see SAS Integration Technologies Server Administrator's Guide
with regards to the use of pre-assigned libraries. The guide is
available on the external Web at the following URL:

   http://support.sas.com/documentation/onlinedoc/inttech/index.html

Most connections to the data are performed using the OLAP Server's
process ID. The exception to this is a SAS/ACCESS library against a
third-party RDBMS when the USER option has been specified.

Operating System and Release Information