网络环境及硬件准备

1.联系网络管理员将域名指向BI所在的IP；

2.联系网络管理员开放BI所在IP的下列端口：

80
8080
8443
8005
6400
6410
6405
2638
5801
5901
6001

3.硬件准备

建议内存最小32GB，CPU最少12核，硬盘1TB。

下载安装文件

1.Redhat enterprise 7.3;

2.SAP BI4.2 SP5 for Linux;

3.MySQL 5.7;

安装Linux操作系统

1.最小化安装；

2.安装分区分三个区，boot分区2GB，SWAP分区32GB，根分区使用其他所有空间；

3.安装过程中要设置主机名、网络（自动启动）、时区（必须为UTC+8）等；

4.安装完后卸载默认的yum及rhn管理组件；

rpm -qa |grep yum

卸载所有列出的包；
rpm -qa|grep yum|xargs rpm -e –nodeps

rpm -qa |grep rhn

卸载所有列出的包；

rpm -qa|grep rhn|xargs rpm -e –nodeps

yum list all | grep subscription

卸载所有列出的包；

5.配置centos的更新yum源（略）

yum clean all

yum makecache

yum -y update

yum -y install epel-release
yum -y install htop

6.编辑/etc/hosts文件，设置主机名、域名绑定关系；

7.关闭防火墙(同时关闭selinux和iptables)：

setenforce 0

编辑/etc/selinux/config，设置SELINUX=disabled

service iptables stop

chkconfig iptables off

8.修改ulimit值

vim /etc/security/limits.d/90-nproc.conf
* soft nproc 10240
* hard nproc 16384
* soft nofile 10240
* hard nofile 65536
* soft stack 10240

9.安装SAP BI4.2需要使用的包

yum install install libstdc++.i686
yum install install libstdc++.x86_64
yum install compat-libstdc++-33.i686
yum install compat-libstdc++-33.x86_64
yum install glibc.i686
yum install glibc.x86_64
yum install libX11.i686
yum install libX11.x86_64
yum install libXext.i686
yum install libXext.x86_64
yum install expat.i686
yum install expat.x86_64
yum install libgcc.i686
yum install libgcc.x86_64
yum install libXcursor.i686
yum install libXcursor.x86_64
yum install libXrender.i686
yum install libXrender.x86_64
yum install libXfixes.i686
yum install libXfixes.x86_64
yum install libxcb.i686
yum install libxcb.x86_64
yum install libXau.i686
yum install libXau.x86_64

10.重启系统

reboot

安装MySQL

注意MySQL编码必须是UTF8或者UTF8MB4.

创建两个数据库:BI_AUDIT和BI_CMS;

准备BI安装包

1.将下载的安装包解压后再压缩成zip文件，然后上传到linux。例如放在/sapteamn

cd /sapteamn

unzip abc.zip

cd /

chmod -R 777 /sapteam

2.配置ODBC

<BIP_INSTALL_DIR>/sap_bobj/enterprise_xi40/odbc.ini

例如：

[ODBC Data Sources]
BI4_CMS_DSN_1362069282=SQLAnywhere 16.0
[BI4_CMS_DSN_1362069282]
UID=dba
PWD=mypassword
DatabaseName=BI4_CMS
ServerName=BI4_1362069282
Host=192.0.2.0:2638
Driver=/opt/sqlanywhere16/lib64/libdbodbc16.so

安装BI

1.到解压文件目录下，执行安装： ./setup.sh

The installation log file is saved to <BIP_INSTALL_DIR>/InstallData/logs/<DATEandTIME>/
setupengine.log.

2.确认安装目录

The use of Unicode characters in the destination folder is not supported.
Ensure that the destination folder name does not contain spaces.
Ensure that the destination folder is not the same folder in which the installation program has been extracted (do not install to the current working directory when running the installation program from the current working directory)

3.语言包选择：English、Chinese和Traditional Chinese

4.安装方式选择

5.注意SVN一定要安装。

相关Notes

1771995 – Incorrect number of hierarchy levels in Design Time
1750788 – BICS metadata service enhancement
1767351 – Missing metadata of characteristics in the fix filter
1776999 – Incorrect hierarchy sorting
1777544 – Metadata missing for node type attributes
1778347 – Attributes for node types are not read
1770434 – Dynamic filter of compound char. is incorrect
1762156 – Nodes in fixed filter in Design Time are incorrect
1776688 – Too many hierarchy levels are read
1798297 – Correction for issue found on Samsung queries
1806813 – Text of characteristic values is not read
1809517 – Correction for invalid variable order when retrieving the list of variables through the design time services
1811124 – This note fixes the sorting of the of drill down characteristics returned by the design-time API so that it matches the runtime sorting
1812142 – This note fixes the sorting of the hierarchies returned by the design-time API so that it matches the runtime sorting
1817482 – This note adds the feature for the Design Time API to choose whether members should be read initially or not. By default, there are not read; this provides a performance enhancement for SL.

To configure the odbc.ini file for DataDirect connections

[pdfjs-viewer url=”https%3A%2F%2Fwww.gavindong.com%2Fwp-content%2Fuploads%2F2017%2F12%2Fsbo42sp2_bip_inst_unix_en.pdf” viewer_width=100% viewer_height=500px fullscreen=true download=false print=true]