SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 20823: Viewing SAS® Activity-Based Management Cubes in SAS® Web OLAP Viewer

DetailsAboutRate It

The SAS Web OLAP Viewer is a standalone Web application that enables you to view data which is stored in an OLAP cube. There are two types of SAS Web OLAP Viewers that you can use to view SAS Activity-Based Management cubes:

  • SAS Web OLAP Viewer for .NET is based on ASP.NET technologies.
  • SAS Web OLAP Viewer for Java is based on Java and is a component of SAS® Enterprise BI Server.

There are two ways to view cubes that are created in SAS Activity-Based Management in SAS Web OLAP Viewer:

  1. Viewing Cubes in SAS Web OLAP Viewer for Java:

    Note that you must have SAS Web OLAP Viewer for Java installed and have all required software and services installed and properly configured.

    The server security in your SQL Server must be set up properly. SAS Open Metadata Respository will access the public views through the SQL Server.

    In SAS® Management Console, register the public views. You will use SAS® OLAP Cube Studio to build the SAS cube from the tables. Use SAS Web OLAP Viewer for Java to view the cubes.

  2. Viewing Cubes in SAS Web OLAP Viewer for .NET

    Note that you must have SAS Web OLAP Viewer for .NET installed and and have all required software and services installed and properly configured.

    You will be required to modify the server list in the Web configuration file. You can find the Web configuration file in the following location (the path will vary according to the version of SAS Web OLAP Viewer and your setup selections):

    C:\Inetpub\wwwroot\SAS Institute Inc\SASWebOLAPViewer\1.X\web.config
    
    

    Modify the server list in the Web configuration file to include the following:

       <server
             default="true"
             name="ABM OLAP Viewer"
             description="ABM OLAP Cubes in MSAS"
             provider="MSOLAP.2"
             host="http://yourabmserverurl:8090/SASSolutions/ABM/Services"
             configString=""
             port=""
             credentialsRequired="true"
         />
    

    Copy the host address into the Web browser. You can now use SAS Web OLAP Viewer for .NET to view the cubes directly.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Activity-Based ManagementMicrosoft Windows NT Workstation6.0
Microsoft Windows XP Professional6.0
Microsoft Windows Server 2003 Standard Edition6.0
Windows Millennium Edition (Me)6.0
Microsoft Windows 95/986.0
Microsoft Windows Server 2003 Datacenter Edition6.0
Microsoft Windows Server 2003 Enterprise Edition6.0
Microsoft Windows 2000 Server6.0
Microsoft Windows 2000 Advanced Server6.0
Microsoft Windows 2000 Datacenter Server6.0
Microsoft Windows 2000 Professional6.0
* 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.