Making Detail Data Available to an OLAP Server for Drill-Through

You can drill through an OLAP report to the underlying detail data only after you make the detail data available to the OLAP Server. In order for the OLAP server to make detail data available for a cube, the library for the table that contains the detail data must be registered so that the OLAP server can identify the library to use. Also, the library permissions must allow ReadMetadata permission. The simplest way to register the library to the server is to pre-assign it and store the library in a folder that grants ReadMetadata permission to PUBLIC.

To specify a library as pre-assigned for an OLAP server, perform the following steps:

In Data Library Manager (in SAS Management Console), find the Libraries folder and perform one of the following tasks to get to the dialog box that lets you select advanced options:
- For a new library, right-click the Libraries folder and select New Library to start the New Library wizard. Then navigate to the page that enables you to specify the libref.
- For an existing library, open the Libraries folder and right-click the desired library. Select Properties from the drop-down menu, and then select the Options tab in the properties dialog box.
  
  Library Properties
Click Advanced Options.
Select the Library is pre-assigned check box on the Pre-Assign tab in the Advanced Options dialog box.
On the Assign tab of the properties dialog box or the server selection page of the New Library wizard, ensure that the selected application server is the server container that contains your OLAP server.

Specifying an Assigned Server
Click OK in the properties dialog box, or finish entering information in the wizard.
Restart the OLAP server.

The selected library is assigned after the selected OLAP server starts. After the OLAP server starts, ensure that the library is pre-assigned to the correct SAS OLAP server. The OLAP server also generates a record in the log file stored at SAS-config-dir\Lev1\SASApp\OLAPServer\Logs\.

The following example shows how pre-assigned libraries are identified in the log file:

2008-08-04T13:00:13,068 WARN  [00000010] :SYSTEM@host - NOTE: Libref odbc  successfully assigned from logical server.
2008-08-04T13:00:13,068 WARN  [00000010] :SYSTEM@host - NOTE: Libref wrstemp successfully assigned from logical server.
2008-08-04T13:00:13,068 WARN  [00000010] :SYSTEM@host - NOTE: Libref wrsdist successfully assigned from logical server.
2008-08-04T13:00:13,068 WARN  [00000010] :SYSTEM@host - NOTE: Libref stpsamp successfully assigned from logical server. 
2008-08-04T13:00:13,068 WARN  [00000010] :SYSTEM@host - NOTE: Libref SASDATA successfully assigned from logical server.