Transcription
SAS Activity-Based Management 7.2Installation, Migration, and Configuration Guidei27 April 2012
Copyright NoticeThe correct bibliographic citation for this manual is as follows: SAS Institute Inc., SAS ActivityBased Management 7.2 Installation, Migration and Configuration Guide, Cary, NC: SAS Institute Inc.,2011-2012.SAS Activity-Based Management 7.2 Installation, Migration and Configuration Guide isCopyright 2011-2012 SAS Institute Inc., Cary, NC, USA.All rights reserved. Printed in the United States of America. No part of this publication may bereproduced, stored in a retrieval system, or transmitted, by any form or by any means, electronic,mechanical, photocopying, or otherwise, without the prior written permission of the publisher,SAS Institute Inc. Limited permission is granted to store the copyrighted material in your systemand display it on terminals, print only the number of copies required for use by those personsresponsible for installing and supporting the SAS programming and licensed programs for whichthis material has been provided, and to modify the material to meet specific installationrequirements. The SAS Institute copyright notice must appear on all printed versions of thismaterial or extracts thereof and on the display medium when the material is displayed.Permission is not granted to reproduce or distribute the material except as stated above.U.S. Government Restricted Rights Notice. Use, duplication, or disclosure of the software by thegovernment is subject to restrictions as set forth in FAR 52.227-19 Commercial ComputerSoftware-Restricted Rights (June 1987).SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513.SAS and all other SAS Institute Inc. product or service names are registered trademarks ortrademarks of SAS Institute Inc. in the USA and other countries. indicates USA registration. Other brand and product names are trademarks of their respectivecompanies.ii
Table of ContentsChapter 1 – Using These Instructions. 7Audience . 7Outline . 7Technical Support . 7Reference Documents. 8Release Notes . 8One Final Word before You Begin . 9Chapter 2 – Deployment Options . 10Two Computer Deployment . 11Three Computer Deployment . 11Four Computer Deployment . 12Five Computer Deployment . 12Other Deployment Possibilities. 12Server Prerequisites . 12Deployment Information . 13Chapter 3 – Migrating from Previous Versions . 14Important Changes from Previous Versions of Activity-Based Management. 14Backing up the System . 14Upgrading from SAS OLAP 9.1.3 . 15Upgrading from SAS OLAP 9.2 . 15Upgrading from Microsoft Analysis Services 2000 or 2005 . 15Upgrading from Microsoft SQL Server 2000 or 2005 . 15Upgrading from Oracle 10g . 16Running the SAS Migration Utility . 16Chapter 4 – Setting Up Users, Groups, and Ports . 17Types of Accounts . 17Internal Accounts . 17External Accounts . 18Accounts Summary . 18Calculation Server and OLAP Server Accounts . 18Creating External User Accounts . 18Windows . 19UNIX . 20SAS First User Account (Optional) . 20Creating External Groups . 20Windows . 20UNIX . 21Designating Ports . 22About Ports and Multicast Addresses . 22Chapter 5 – Installing Third-Party Prerequisites . 24iii
User ID for Installations . 25Java JDK for Servers . 26Windows . 26UNIX . 26Web Application Server . 26JBoss . 27Oracle WebLogic . 27IBM WebSphere . 27After Installing JBoss, WebLogic, or WebSphere . 27All Web Application Servers .27Relational Database . 28Installing Microsoft SQL Server Database . 28Background .28Install Microsoft SQL Server 2008 .28Configure Microsoft SQL Server 2008 .29Install Oracle Database . 29Install MySQL Database . 29OLAP Server . 29Microsoft SQL Server Analysis Services 2008 .29ODBC Drivers . 29Microsoft SQL Server Database . 30Oracle Database. 30MySQL Database . 30JUnit for SAS Activity-Based Management Server Diagnostic . 30Required Software for SAS Activity-Based Management Surveys . 30Adobe Flash Player . 30Required Software for SAS Activity-Based Management Client . 31Adobe Reader .Adobe Flash Player .Microsoft .NET Framework .Microsoft Internet Explorer .DHTML Editing Control for Microsoft Internet Explorer .Microsoft XML Core Services .OLEDB for OLAP Drivers .31313131313132Special Combinations . 32Oracle WebLogic and MySQL Database. 32Windows MySQL Database . 32Microsoft SQL Server Database and Microsoft Analysis Services . 33Chapter 6 – Installing SAS Prerequisites . 34SAS Software. 34SAS Software Installation . 35Important Deployment Questions . 35Run as Windows Services (Windows Only) .Allow Anonymous Web Access .Automatically Configure Your Web Application Server .Configure Multiple Managed Servers .35363636SAS Software to Install . 36Metadata Server . 37OLAP Server . 37Chapter 7 – Installing SAS Activity-Based Management . 39Installing on UNIX .39Interactive Prompting Levels . 39iv
Installing the SAS Activity-Based Management Calculation Server. 40Installing the SAS Activity-Based Management Mid-Tier . 42Deployment Errors . 50Installing the SAS Activity-Based Management Client . 51Chapter 8 – Post-Installation. 53Validating the Installation . 53Windows Chinese Traditional Localization (Client Only) . 53Allocating Memory for the Java Virtual Machine . 53Managing External Users . 54Creating Data Source Names (DSNs) . 5432 Bit Windows . 54Microsoft SQL Server .54MySQL .55Oracle .5664 Bit Windows . 57UNIX . 57Persisting Results from the Contributions Viewer . 57The Oracle Bulk Data Loader . 58Importing and Exporting Model Data . 59Microsoft Office . 60OLAP Permissions. 60SAS OLAP Server . 60Windows .61UNIX .61Windows Services . 62Migrating From Version of SAS Activity-Based Management . 62Migrating from Version 7.1 . 62Migrating from Version 6.x . 62Database.63Microsoft SQL Server and Oracle Databases .64Microsoft SQL Server .64Oracle .65Users . 65Microsoft SQL Server .66Oracle .66Published Reports. 67Recalculating Models . 67Data Import and Export Configurations . 67Published Reports Permissions . 68Windows .68UNIX .69Creating SAS Activity-Based Management Users . 69Configuration-Created Metadata .Creating an Activity-Based Management Role .Creating an Activity-Based Management Group .Adding a Group to the Activity-Based Management Users Group .69707171Setting Up Metadata Users for Mixed Architecture Environments . 72Validating the SAS Activity-Based Management Solution . 72Client Diagnostics . 73Server Diagnostics . 73Appendix A – Installing Microsoft SQL Server . 76v
Installing Microsoft SQL Server 2008 . 76Verification of an Existing Version. 76Installation . 76Installing Microsoft SQL Server Analysis Services . 80Installation . 80Configuration . 80Validation . 80Configuring Microsoft SQL Server 2008 . 81JDBC Driver . 81Create the SAS Activity-Based Management User . 81Environment Variables . 83Appendix B – Installing Oracle 11g . 84Installing Oracle on Windows . 84Configuring Oracle . 88JDBC Driver .
On UNIX SASHOME should be replaced by the path where you installed SAS. If you installed the SAS on the /opt path, then replace SASHOME with /opt/SASHOME/. Likewise, CONFIGHOME is the folder name you chose to store your configuration data during SAS installation appended with the con
