Usage Note 20823: Viewing SAS® Activity-Based Management Cubes in SAS® Web OLAP Viewer
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:
- 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.
- 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
| SAS System | SAS Activity-Based Management | Microsoft Windows NT Workstation | 6.0 | | | |
| Microsoft Windows XP Professional | 6.0 | | | |
| Microsoft Windows Server 2003 Standard Edition | 6.0 | | | |
| Windows Millennium Edition (Me) | 6.0 | | | |
| Microsoft Windows 95/98 | 6.0 | | | |
| Microsoft Windows Server 2003 Datacenter Edition | 6.0 | | | |
| Microsoft Windows Server 2003 Enterprise Edition | 6.0 | | | |
| Microsoft Windows 2000 Server | 6.0 | | | |
| Microsoft Windows 2000 Advanced Server | 6.0 | | | |
| Microsoft Windows 2000 Datacenter Server | 6.0 | | | |
| Microsoft Windows 2000 Professional | 6.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.
| Date Modified: | 2007-12-07 14:52:50 |
| Date Created: | 2007-08-17 13:24:51 |