The METASVR statement in the OLAP procedure allows you to specify the
connection options for your metadata environment.  However, even if the
SAS Metadata Server options are defined at initialization of the server
or before the PROC OLAP code is submitted, the DEFINE statement within
the OLAP procedure does not honor the settings. Errors will be generated
when the DEFINE statement is encountered in the code.

The SAS code and log output listed below illustrate the error received
when the PROC OLAP code is submitted with metadata server connection
options predefined, but no METASVR statement has been specified.

   options metaserver = host.name.com;
   options metaport = 8561;
   options metauser = "userid";
   options metapass = "password";
   options metaprotocol=bridge;
   option metarepository="Foundation";

   PROC OLAP;
      METASVR olap_schema="SASMain - OLAP Schema";

      define member '[Cubename].[Measures].[double]' AS
         '[Measures].[Quantitysum]*2';
   run;

   NOTE: The default repository "Foundation" will be used.
   NOTE:    The Data Cache is inactive
            COM Remote Server: host.name.com.
   ERROR:   COM CoCreateInstanceEx() failed: (HRESULT=80080005).
   ERROR:   Metadata error - A connection to the metadata server cannot
      be established
   ERROR: The server options failed to set during DEFINE and UNDEFINE
      statement processing.
   ERROR: DEFINE and UNDEFINE statement processing failed.
   NOTE: The SAS System stopped processing this step because of errors.

Operating System and Release Information