To complete the upgrading of Oracle's Essbase® Integration Services, see Chapter 6, “Post-Installation Tasks,” Chapter 5, “Configuring Data Sources,” and Chapter 7, “Creating,
Upgrading, and Deleting OLAP Metadata Catalogs.” To work with the sample application, see Chapter 8, “Setting Up the Sample Applications.”
For detailed information about installed files, directories, environment changes made by the installation program, and uninstalling the software, see Chapter 9, “Completing Advanced Installation Tasks,” and Chapter 10, “Uninstalling Integration Services.”
Tip:
During updating, configuration, and testing, keep a list of all user names and passwords that you use to create or modify the system, including the applications with which they are associated and their purpose.
Completing the Upgrade 117
Index
accessing, servers and databases, 48 adding data source to odbc.ini, 35, 44 AIX
Batch directory, contents of, 96 batch files
for loading TBC database, 74 installing, 23
batch scripts, for sample application, 97 BCP utility, 69
bin directory, contents of, 96, 98 building
OLAP Metadata Catalog, 57 sample application, 67
C
calculation scripts, location of, 97 changes
installing with server software, 98 RDBMS, required, 31
columns, viewing in sample application, 92 Command Center, 63
Command Window, DB2, 69 components of product, 10
computers, where components can reside, 11 configuring
data sources on UNIX, 33
database client software for Oracle OCI, 33 environment on UNIX, 47
ODBC (Open Database Connectivity) data sources, 31
ODBC computer location, 32 ODBC data sources on UNIX, 33 odbc.ini file, 33, 34 to OLAP Metadata Catalog, 48 to relational data sources, 48, 51 to servers and databases, 48 Control Panel dialog box, 101 creating
database for TBC, 72, 90 database for TBC_MD, 75
ODBC server software data sources, 31 OLAP Metadata Catalog automatically, 59 OLAP Metadata Catalog manually, 60, 64 OLAP Metadata Catalog tables, 58 OLAP Metadata Catalogs, 57, 58 sample application, 67
tables for TBC database, 73 TBC database, 72
cron scheduling daemon, 47, 106
A B C D E H I J L M N O P Q R S T U V W X
Index 119
D
daemons, cron, 106 data files, installing, 23 data loads
enabling scheduled loads, 101, 106 log file location, 97
with TBC sample application tables, 74 data migration
information, 113
OLAP Metadata Catalog, 61 data sources
adding to odbc.ini (UNIX), 35, 44 configuring, 31
configuring on UNIX systems, 33 connecting to, 48, 51
setting up TBC, 72 database client software
configuring for Oracle OCI, 33 environment variables, 105 information, 31
relationship to other components, 11 database scripts
for OLAP Metadata Catalog, 62 for TBC database, 73
for TBC_MD database, 76
database servers, relationship to other components, 11
databases
configuring for ODBC, 31 connecting to, 48
OLAP Metadata Catalog, requirements, 58 TBC, creating, 72, 90
TBC, requirements, 72, 75, 90 TBC_MD, creating, 75 TBC_MD, requirements, 75 user aliases and synonyms, 106 DataDirect Text driver
odbc.ini file example (UNIX), 36 DB2 OS/390
configuration parameter in eis.cfg (for UNIX), 44 odbc.ini file example (UNIX), 37
DBAccess, 63, 69 OLAP Metadata Catalog tables, 62 TBC database tables, 73
TBC_MD database tables, 76 dialog boxes
Control Panel, 101 Login, 49, 79
OLAP Metadata Catalog Setup, 59 Sample Application Setup, 70 Set Login Defaults, 51 directories
created during installation, 96, 98 sample application scripts, 71, 82
TBC data load script, 71, 81, 83, 85, 87, 90 TBC table creation script, 71, 81, 82, 85, 87 TBC_MD data load script, 72
TBC_MD table creation script, 71, 81, 83, 85, 87, 90
disk space requirements Windows client, 18
docs directory, contents of, 96, 98 documentation
directory location, UNIX, 96, 98 directory location, Windows, 99
DB2 OS/390 configuration parameter (for UNIX), 44
eis.cfg file, 46
JDBC data source mapping, 24 location of, 96
enabling
scheduled loads on UNIX, 47, 106 scheduled loads on Windows, 101
A B C D E H I J L M N O P Q R S T U V W X
environment variables
for database client software, 105 for ODBC on UNIX, 34, 105 list of, for UNIX, 103 migration, 114
scripts, setting with, 103
updating manually on UNIX, 103 error.txt file, location of, 96, 98 Essbase
Essbase Server, connecting to, 50
installation in Essbase Integration Services workflow, 9
library files, location on UNIX, 97 relationship to other components, 11 supported release, 17, 115
Essbase Integration Server installing, 23
relationship to other components, 11 running in background, 46
Essbase Integration Services Console, relationship to other components, 11
Essbase Integration Services Shell installing, 23
Essbase Integration Services, uninstalling, 109 Essbase Server
connecting to, 50
connection defaults, setting, 51 setting connection information for, 50 ESSCMD scripts, location of, 97
esscript directory, contents of, 97 esslib directory, contents of, 97
examples, odbc.ini files, 36–43, 37, 41, 42, 43
H
high-availability environment considerations, 103 HOME
variable on UNIX systems, 114 HP-UX
enabling in manual sample application setup, 67 required utilities for sample application setup, 80 sample application for DB2, 81
sample application for Oracle, 82 sample application for SQL Server, 85 sample application for Teradata, 87 sample application setup, 80 viewing the metaoutline, 93 viewing the OLAP model, 93
hyperion user name, permissions required, 47 HYPERION_HOME variable manual steps, UNIX, 47, 103 troubleshooting, 106
workflow, 9 installing
client software on Windows systems, 26 Essbase Integration Services Shell, 23 OLAP Metadata Catalog, 57
OLAP Metadata Catalog scripts, 23 preparation, 17
setting environment variables with, 103 is.sh file
location, 96
A B C D E H I J L M N O P Q R S T U V W X
Index 121
setting environment variables with, 103
jar directory, contents of, 97 JDBC driver
mapping a data source for Oracle OCI, 24 mapping a data source for Teradata, 24 JDBC driver requirements for Teradata, 19
L
language support files, location, 97 lc*.sql files, 78
ld*.sql files, 74, 97
LD_LIBRARY_PATH variable on UNIX, 104 LIBPATH variable on UNIX, 104
library files
Essbase, location on UNIX, 97 library path, settings, 104 Linux, library path variable, 104 loadinfo directory, contents of, 97 loading data
into TBC database, 74
into TBC_MD database using XML Import utility, 78
loads, scheduled, enabling, 47 locale directory, contents of, 97, 99 log directory, contents of, 97, 99 log files, location, 97
logging on, to servers and databases, 48 login defaults, setting, 51
Login dialog box, 49, 79
login scripts, for setting environment variables, 103
M
manual steps, UNIX installation, 47 member loads
enabling scheduled loads, 101, 106 log file location, 97
MERANT
documentation location, 97 ODBC drivers, information, 18
Metadata Catalog, creating Unicode, 60 migration
environment variables, 114 OLAP Metadata Catalog, 61, 116 overview, 113
PATH values, 114
mission critical environment considerations, 103
N
network protocol Windows client, 18
O
oc*.sql files, 97
oc*_upgrd20.sql files, 60, 61, 62 oc_create_*.sql files, 63
ocscript directory, contents of, 62, 97 ODBC (Open Database Connectivity)
configuring data sources, 9, 31 configuring, which computer, 32 data sources, odbc.ini file heading, 35 environment variables on UNIX, 34, 105 relationship to other components, 11 required database client software, 31 ODBC drivers
adding data source to odbc.ini file on UNIX, 35 configuring DataDirect Text driver on UNIX, 38–
40
configuring DB2 OS/390 on UNIX, 37
configuring DB2 UDB Wire Protocol on UNIX, 36
configuring Informix Wire Protocol on UNIX, 37 configuring on UNIX, 33–43
configuring Oracle Wire Protocol on UNIX, 38 configuring SQL Server driver on UNIX, 41 configuring Sybase Wire Protocol on UNIX, 41 configuring Teradata driver on AIX, 41
configuring Teradata driver on HP-UX, 42 configuring Teradata driver on Solaris, 42 configuring the odbc.ini file on UNIX, 34
A B C D E H I J L M N O P Q R S T U V W X
preserving existing, 113 odbc.ini file
adding a data source to, 35, 44 bracketed headings, 35 Teradata example on AIX, 41 Teradata example on HP-UX, 42 Teradata example on Solaris, 42
odbc\merant41 directory, contents of (UNIX), 97 OLAP Metadata Catalog
connecting to, 48
connection defaults, setting, 51 creating, 57
creating automatically, 59
creating tables for manually, 60, 64 data migration, 61
OLAP Metadata Catalog Setup dialog box, 59 OLAP metaoutlines, viewing in sample application,
92, 93
OLAP models, viewing in sample application, 92, 93 OLAP_TBC, scripts for, 97
olapisrv.log file, 46 onames, 112
open database connectivity. See ODBC (Open Database Connectivity)
Oracle
odbc.ini file example, 38
Oracle Call Interface (OCI), 11, 12 SQL*Loader, 73
SQL*Plus, 63, 69
Oracle Call Interface (OCI), 11, 12
connecting to a data source at login time, 33 database client software for, 33
mapping a JDBC driver, 24
P
PATH variable on UNIX, 104
settings, migration, 114 PDF documentation
directory location, UNIX, 96, 98 permissions
required for hyperion user, 47 required for Windows installation, 26 preparing to install, 17
privileges, required for Windows installation, 26 product components, 11
Q
Query Analyzer utility (SQL Server), 63, 69
R
rebuilding tables, 62
reconnecting to Integration Server, 54 registered software, removing, 109 relational databases
client software required, 31 user aliases and synonyms, 106 removing
OLAP Metadata Catalog, 66 OLAP Metadata Catalog tables, 62 server software, 109
rights, required for Windows installation, 26 running
creating for Hybrid Analysis, 80
Sample Application Setup dialog box, 70 sample database, TBC, 68
samples directory, contents of (UNIX), 97 samples\\tbDVDbase directory, contents of, 73 samples•\;spreadsheets directory, contents of (UNIX),
97
samples•\;tbcmodel directory, contents of (UNIX), 97
samples•\;tbDVDbase directory, contents of (UNIX), 97
scheduled loads, enabling on UNIX, 47 scheduler scripts, location of, 96 scripts
calculation scripts, 97
ESSCMD, directory location, 97 for loading Hybrid Analysis data, 74 for loading TBC database, 74 for loading TBC_MD database, 78 for OLAP Metadata Catalog, 62 for setting environment variables, 103 for TBC database, 73
for TBC_MD database, 76
location, sample application, 71, 82 SQL, location of, 97
server log file, location of, 97, 99 server software
installation changes on UNIX, 96 installing on Windows systems, 23, 26 installing with client software, 98 removing, 109
servers, connecting to, 48 Set Login Defaults dialog box, 51 setting
connection defaults, 51
connection information for Essbase Server, 50 environment variables on UNIX, 103
setup program
for loading TBC database, 74
for setting environment variables, 103 SHLIB_PATH variable on UNIX, 104 software components
SQL script files, location, 97 SQL scripts
for loading TBC database, 74
for OLAP Metadata Catalog, 62, 63, 97 for TBC database, 73
for TBC_MD database, 76
location, sample application, 71, 82 SQL Server
example odbc.ini file on UNIX, 41 Query Analyzer utility, 63, 69 SQL*Loader, 73
SQL*Plus, 63, 69 starting
Integration Services Console, 47 schedule services on UNIX, 106 schedule services on Windows, 101 Sybase
creating for OLAP Metadata Catalog manually, 60, 64
A B C D E H I J L M N O P Q R S T U V W X
creating for TBC database, 73 creating for TBC_MD database, 76 rebuilding tables, 62
upgrading for OLAP Metadata Catalog, 61 tables, viewing in sample application, 92 Task Scheduler service
Windows 2000, starting, 101 Windows 2003, starting, 102 Windows XP, starting, 102 TBC
data load script location, 71, 81, 83, 85, 87, 90 database requirements, 72, 75, 90
database, creating tables for, 73 database, viewing, 92, 93 loading data into, 74 sample database, 68
setting up relational data source, 72
table creation script location, 71, 81, 82, 85, 87 viewing columns in, 92
viewing metaoutline in, 93 viewing OLAP model in, 93 viewing tables in, 92
data load script location, 72 database requirements, 75 database, creating, 75
database, creating tables for, 76
loading data into using XML Import, 78 sample OLAP Metadata Catalog, 68
table creation script location, 71, 81, 83, 85, 87, 90
TBC_Model_Unicode.xml, 91 tbcmodel directory, contents of, 97 tbDVDbase directory, contents of, 97 TEMP variable
on UNIX, 104 Teradata
example odbc.ini file for AIX, 41 example odbc.ini file for HP-UX, 42
example odbc.ini file for Solaris, 42 mapping a JDBC driver, 24
odbc.ini file example, 41, 42
Teradata JDBC driver requirements, 19 Text driver
configuring on UNIX, 38–40 troubleshooting, installations, 106
U
Unicode
creating OLAP Metadata Catalog, 60
required utilities for sample application setup, 89 sample application for DB2, 90
sample application setup, 89 viewing the metaoutline, 93 viewing the OLAP model, 93 UNIX
configuring environment, 47 environment variables, 103
environment variables for ODBC, 34, 105 environment variables, configuring, 34 environment, updating manually, 103 installation changes, 96
library files, shared, 96 manual installation steps, 47
ODBC data sources, configuring, 33 ODBC environment variables, 34 removing software, 109
scheduled loads, enabling, 47, 106 updating
environment variables for ODBC, 105 environment variables on UNIX, 103 upgrading
migration information, 113 OLAP Metadata Catalog, 61 user aliases, 106
user privileges, required for Windows installation, 26 user synonyms, 106
V
verifying path variables, 114 verifying product components, 10 vi program, 35
viewing sample application, 92, 93
A B C D E H I J L M N O P Q R S T U V W X
Index 125
W
wide area network (WAN), 49 Windows
client requirements, 18 installing client software, 26 installing server software, 23, 26 Windows 2000
Task Scheduler service, starting, 101 Windows 2003
Task Scheduler service, starting, 102 Windows service
Task Scheduler, starting, 101, 102 Windows XP
Task Scheduler service, starting, 102 workflow, installation, 9
X
XML files for loading TBC_MD database, 78 XML Import for loading TBC_MD database, 78
A B C D E H I J L M N O P Q R S T U V W X