The SAS Web OLAP Viewer for .NET can be used to access any third-party OLAP cubes that support the OLE DB for OLAP (ODBO) standard.

The first step is to specify the server to which you are connecting. Server definitions are made in the Web.config file located in \SAS\SWOVN\1.2. For example: "c:\inetpub\wwwroot\sas\swovn\1.2".

An example of a server definition to a Microsoft Analysis Server is:

   <server
      default="false"
      name="MSAS"
      description="Microsoft Analysis Server"
      provider="MSOLAP.2"
      host="Myserver.domain.com"
      credentialsRequired="true"
    />

Because the items of the web.config file are XML based, be sure that the case of each parameter and value is correct. The provider name is unique for each OLAP provider. Please see the documentation for your particular provider for more information on this value.

In addition to the server definition, ASP.NET applications have some security issues when accessing remote databases through IIS. Microsoft's Knowledge Base document 317012, has detailed information on this topic.

To connect to SAP BW Servers follow these steps:

1. Create a server definition using the SAPLogon tool on the SAS Web OLAP Viewer for .NET midtier server. The SAP provider must be installed on the midtier server.
2. Make sure that the saplogon.ini file is in the Windows installation directory. From the Windows Start menu, open the Run dialog box. In the Open field, type %windir% to open the correct folder. If necessary, copy it from the current location to the Windows installation directory. The midtier administrator should change the location for the saplogon.ini file in their SAPLogon options to the Windows directory. This will make it easier to administer.
3. Add the server and user information to the SAS Web OLAP Viewer for .NET web.config file. Be sure to include the provider config string, which defines the version and language in use. This is covered the documentation for OLE DB for OLAP with the SAP BW client.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS OLAP Server	Windows	n/a
SAS System	SAS BI Server	Windows	n/a

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Type:	Usage Note
Priority:	low
Topic:	Third Party ==> Programming ==> .NET

Date Modified:	2007-10-24 12:34:02
Date Created:	2005-10-03 13:56:54