15 附录2 HANA 工作室与BO4.0等客户端安装操作手册_20120309(字数2957,20页)

合集下载

SAP-HANA-安装配置操及备份恢复测试报告

SAP-HANA-安装配置操及备份恢复测试报告SAP HANA 安装配置及备份恢复测试报告2015/12/29目录一、安装备份软件客户端 (5)二、SAP HANA 的配置 (6)2.1、 ................... 配置客户端参数及备份脚本文件62.2、 ...................... 配置SAP HANA客户端72.3、 .......................... 创建backupset122.4、 ........................... 配置子客户端132.5、 ....................... 配置SAP HANA参数17三、HANA 备份 (19)四、HANA 恢复 (21)一、安装备份软件客户端安装软件时选择SAP HANA进行安装，具体安装过程略，下面只列出主要的安装步骤。

1）选择要安装的模块2）配置SAP HANA 用户组3）配置HANA 的执行路径说明：其中HRP 为HANA 数据库的实例名称，hdb目录下面的opt 目录可能并不存在，需要自己手工进行创建。

二、SAP HANA 的配置2.1、配置客户端参数及备份脚本文件rtpdb01:~ # cd /opt/simpanaRTPDB01:/opt/simpana #mkdir HANA_BAK_ScriptsRTPDB01:/opt/simpana # cd HANA_BAK_ScriptsRTPDB01:/opt/simpana/HANA_BAK_Scripts # vi HRP.sh#!/bin/bashTIMESTAMP="$(date +\%F\_%k\%M)"BACKUP_PREFIX="SCHEDULED"BACKUP_PREFIX="$BACKUP_PREFIX"_"$TIMESTAMP"su - hrpadm -c "hdbsql -i 0 -U BACKUP \"backup data using backint ('$BACKUP_PREFIX') ASYNCHRONOUS \""RETURN_CODE=$?exit $RETURN_CODE说明：注意上面的-U BACKUP 要自己创建user key具体如下：hdbuserstore set BACKUP rtpdb01:30015 system test123其中system 为HANA 数据库中的用户RTPDB01:/opt/simpana/HANA_BAK_Scripts # chmod 777 HRP.shRTPDB01:/opt/simpana/HANA_BAK_Scripts # cd /opt/simpana/iDataAgentRTPDB01:/opt/simpana/iDataAgent # vi paramCvInstanceNameInstance001CvClientNamertpdb01RTPDB01:~ # cd /usr/sap/HRP/SYS/global/hdbRTPDB01:/usr/sap/HRP/SYS/global/hdb # mdkir optRTPDB01:/usr/sap/HRP/SYS/global/hdb # cd optRTPDB01:/usr/sap/HRP/SYS/global/hdb/opt # ln -s/opt/simpana/iDataAgent/backint hdbbackintRTPDB01:/usr/sap/HRP/SYS/global/hdb/opt # mkdir hdbconfig RTPDB01:/usr/sap/HRP/SYS/global/hdb/opt # cd hdbconfigRTPDB01:/usr/sap/HRP/SYS/global/hdb/opt # ln –s/opt/simpana/iDataAgent/param param2.2、配置SAP HANA客户端以下显示一个案例新建SAP HANA客户端设置名称、数据库名、用户名添加物理客户端配置命令行存储策略配置日志备份存储策略压缩选项使用存储策略设置在客户端重删2.3、创建backupset说明：针对HANA的备份，创建备份集仍然通过文件系统模块进行，文件系统模块通过配置预扫描脚本，执行SAP HANA 上的备份脚本，实现对HANA数据库的备份。

14 附录1 HANA系统服务器安装操作手册_20120309(字数1739,10页)

附录1 HANA 系统服务器安装操作手册一、系统总体架构辽宁公司HANA 1.0版的POC 系统环境简单示意如图A1.1.1，包括： ∙ 数据源: ERP ECC 服务器、BW 服务器；∙ 数据复制引擎：SLT 服务器（SAP NetWeaver7.0 EHP2）、Data Service ； ∙ 内存计算服务器：HANA 服务器； ∙ 数据展示服务器：BO4.0服务器。

图A1.1.1 辽宁公司HANA 1.0版的POC 系统环境其中，由于硬件资源限制，所以HANA 服务器与BO4.0、DATA Service 装在同一台服务器上（注：一般都会将BO4.0、DATA Service 装在同一台服务器上，但与HANA 服务分开装）。

辽宁公司HANA 1.0验证时的服务器配置情况请参考下图A1.1.2图A1.1.2 辽宁公司 HANA 1.0 服务器配备图二、ECC Server安装HANA实施过程中，ECC Server作为数据源，需要在上面安装DMIS组件，以便将数据库中的数据发布出去。

DMIS安装方式采用Add-On方式安装，安装步骤如下：1.首选将DMIS组件和四个DMIS相关的补丁用SAPCAR解压，然后存放到操作系统/usr/sap/trans/EPS/in路径下；2.在000集团，用DDIC用户，使用SAINT事务码。

安装界面如下图A1.2.1所示：图A1.2.1 ECC服务器端安装DMIS组件程序界面然后从Installation Package->Load packages->From Application Server中将DMIS组件导入列表，然后点击start，接着一直使用continue，中间会出现选择补丁界面，选择DMIS的sp4补丁，然后继续，提示需要密码，按照提示的SAP Note，到SAP官网查找相关note，并根据系统的版本选择相应的密码，填入密码后，再次点击continue，最后点击运行，强烈建议将其设置为后台运行，然后用SM37检查对应的Job，等Job运行完成后，DMIS升级成功。

使用说明和安装说明说明书

R e g i s t e ry o u rn e w d e v i c eo nM y B o s c h no w a n dg e t f r e e b en e f i t s:b o sc h-h o me.c o m/w e l c o m e Warming drawerBIC510N.0W BID510N.0W[en]User manual and installation instructions2 [zh]使用说明和安装说明11en Safety2Table of contentsINFORMATION FOR USE 1Safety.................................................................... 22Preventing material damage ............................... 33Environmental protection and saving en-ergy....................................................................... 34Familiarising yourself with your appliance........ 45Before using for the first time............................. 46Tableware............................................................. 47Basic operation.................................................... 58Preheating tableware........................................... 59Keeping food warm.............................................. 510Cleaning and servicing........................................ 611Troubleshooting................................................... 612How it works......................................................... 713Customer Service. (814)INSTALLATION INSTRUCTIONS (8)14.4Safe installation ...................................................91 SafetyObserve the following safety instructions.1.1 General information¡Read this instruction manual carefully.¡Keep the instruction manual and the product information safe for future refer-ence or for the next owner.¡Do not connect the appliance if it has been damaged in transit.1.2 Intended useThis appliance is designed only to be built into kitchen units. Read the special installation instructions.Only a licensed professional may connect ap-pliances without plugs. Damage caused by in-correct connection is not covered under the warranty.Only use this appliance:¡To keep food warm and to warm cookware.¡In private households and in enclosed spaces in a domestic environment.¡Up to an altitude of max. 4000 m abovesea level.Do not use the appliance:¡On boats or in vehicles.¡with an external timer or a remote control.1.3 Restriction on user groupThis appliance may be used by children aged 8 or over and by people who have reduced physical, sensory or mental abilities or inad-equate experience and/or knowledge,provided that they are supervised or have been instructed on how to use the appliance safely and have understood the resulting dangers.Do not let children play with the appliance.Children must not perform cleaning or user maintenance unless they are at least 15 years old and are being supervised.Keep children under the age of 8 years away from the appliance and power cable.1.4 Safe useWARNING ‒ Risk of fire!The inside of the appliance gets very hot and may cause flammable materials to ignite.▶Never place flammable objects or plasticcontainers in the appliance.WARNING ‒ Risk of burns!The accessories and cookware become very hot during operation.▶Always use oven gloves when removing hot accessories or cookware from the ap-pliance.The inside of the appliance becomes very hot during operation.▶Never touch the inside of the appliance while it is hot.▶Keep children away from the appliance.The appliance becomes hot during operation.▶Allow the appliance to cool down beforecleaning.WARNING ‒ Risk of electric shock!Incorrect repairs are dangerous.▶Repairs to the appliance should only be carried out by trained specialist staff.▶Only use genuine spare parts when repair-ing the appliance.▶If the power cord of this appliance is dam-aged, it must be replaced by trained spe-cialist staff.Preventing material damage en3If the insulation of the power cord is dam-aged, this is dangerous.▶Never let the power cord come into contact with hot appliance parts or heat sources.▶Never let the power cord come into contact with sharp points or edges.▶Never kink, crush or modify the power cord.An ingress of moisture can cause an electric shock.▶Do not use steam- or high-pressure clean-ers to clean the appliance.If the appliance or the power cord is dam-aged, this is dangerous.▶Never operate a damaged appliance.▶Never pull on the power cord to unplug the appliance. Always unplug the appliance at the mains.▶If the appliance or the power cord is dam-aged, immediately unplug the power cord or switch off the fuse in the fuse box.▶Call customer services. →Page 8WARNING ‒ Risk of suffocation!Children may put packaging material over their heads or wrap themselves up in it and suffocate.▶Keep packaging material away from chil-dren.▶Do not let children play with packaging ma-terial.Children may breathe in or swallow small parts, causing them to suffocate.▶Keep small parts away from children.▶Do not let children play with small parts.2 Preventing material damageATTENTION!Excessive weight may damage the appliance.▶The appliance has a maximum load capacity of 15 kg.Moisture may damage the appliance.▶Do not use the appliance to store food and drinks.The humidity of the food may cause corrosion dam-age.3 Environmental protection and saving energy3.1 Disposing of packagingThe packaging materials are environmentally compat-ible and can be recycled.▶Sort the individual components by type and dispose of them separately.en Familiarising yourself with your appliance44 Familiarising yourself with your appliance4.1 ApplianceYou can find an overview of the parts of your appliance here.4.2 ControlsYou can use the control panel to configure all functions of your appliance and to obtain information about the 5 Before using for the first timeConfigure the settings for initial start-up. Clean the ap-pliance and accessories.5.1 Cleaning and heating up the appliance before using it for the first time1.Clean the appliance.2.Remove the accessories.3.Heat up the appliance at 80 °C for one hour.a Smoke development and odour development arenormal.6 TablewareThese instructions help you to avoid damaging your tableware.6.1 Suitable tablewareThe warming drawer has a maximum load capacity of 15 kg. You can use it to preheat the place settings for 6 or 12 people, for example.Drawer – 14 cm Drawer – 29 cm 6 dinner plates 24 cm diameter 12 dinner plates 24 cm diameter 6 soup bowls 10 cm diameter 12 soup bowls 10 cm diameter 1 bowl 19 cm diameter 1 bowl 22 cm diameter 1 bowl17 cm diameter 1 bowl 19 cm diameter 1 meat platter32 cm1 bowl17 cm diameter 2 meat platters32 cmBasic operation en57 Basic operation7.1 Opening the appliance▶Press on the centre of the warming drawer.a The warming drawer pops open and can be pulledout.7.2 Closing the appliance▶Press on the centre of the warming drawer andpush it back in.7.3 Switching on the appliance▶Press .7.4 Switching off the appliance▶Press .7.5 Setting the temperature▶Set the temperature to any value between , and .8 Preheating tablewareFood does not cool down as quickly on preheated tableware. Drinks also remain warm for longer.8.1 Starting the "Preheat tableware"functionWARNING ‒ Risk of burns!Drinking vessels become very hot at high temperat-ures.▶For drinking vessels, set the settings to .1.Place an anti-slip mat at the bottom of the drawer toprevent the tableware scratching the interior surface of the drawer.2.Place the tableware in the warming drawer.‒Distribute the tableware across the entire bottom of the warming drawer to reduce the preheating time.Do not block the ventilation opening with tall items of tableware or stacks of plates. Keeping the ventila-tion opening clear ensures that hot air can circulate efficiently.3.Turn the temperature selector to set the required temperature.A setting of up to is suitable for tableware. For drinking vessels, the settings from to are suit-able.4.Switch on the appliance.a The operation indicator lights up, the applianceheats up and the fan runs.5.Close the warming drawer.Note: The preheating time depends on the material,thickness, quantity and distribution of the tableware.For place settings for 6 people, the preheating time is approx. 15-25 minutes.8.2 Ending the "Preheat cookware" functionWARNING ‒ Risk of burns!The accessories and/or cookware become very hot during operation.▶Always use oven gloves to remove accessories or cookware from the cooking compartment.1.Open the warming drawer.2.Switch off the appliance.3.Remove the cookware.9 Keeping food warmYou can use the warming drawer to keep food warm for a certain period of time.We advise against keeping food warm for longer than an hour. Suitable food includes meat, poultry, fish,sauces, vegetables, side dishes and soups.9.1 Starting the "Keep food warm" functionATTENTION!Hot cookware from the hob damages the anti-slip mat in the warming drawer.▶Never take hot pots and pans off the hob and place them directly on the anti-slip mat.1.Place an anti-slip mat at the bottom of the drawer toprevent the tableware scratching the interior surface of the drawer.The anti-slip mat is food-safe. Dry food can be heated directly on the anti-slip mat in the warming drawer. The anti-slip mat must then be cleaned.2.Place the tableware in the warming drawer.3.Turn the temperature selector to set the required temperature.4.Switch on the appliance.a The operation indicator lights up, the appliance heats up and the fan runs.5.Preheat the tableware for approx. 10 minutes.6.Place food into the preheated tableware.‒Do not completely fill the tableware with food to prevent any content from spilling out when you open and close the warming drawer.‒Cover food which dries out easily with a heat-res-istant lid or aluminium foil.7.Close the warming drawer.en Cleaning and servicing69.2 Ending the "Keep food warm" functionWARNING ‒ Risk of burns!The accessories and/or cookware become very hot during operation.▶Always use oven gloves to remove accessories or cookware from the cooking compartment.1.Open the warming drawer.2.Switch off the appliance.3.Remove the cookware.10 Cleaning and servicingTo keep your appliance working efficiently for a long time, it is important to clean and maintain it carefully.10.1 Cleaning productsYou can obtain suitable cleaning products from after-sales service or the online shop.ATTENTION!Unsuitable cleaning products may damage the sur-faces of the appliance.▶Do not use harsh or abrasive detergents.▶Do not use cleaning products with a high alcohol content.▶Do not use hard scouring pads or cleaning sponges.▶Only use glass cleaners, glass scrapers or stainless steel care products if recommended in the cleaning instructions for the relevant part.▶Wash sponge cloths thoroughly before use.10.2 Cleaning the applianceWARNING ‒ Risk of electric shock!An ingress of moisture can cause an electric shock.▶Do not use steam- or high-pressure cleaners toclean the appliance.WARNING ‒ Risk of burns!The appliance becomes hot during operation.▶Allow the appliance to cool down before cleaning.Requirement: The appliance is switched off.1.Clean the appliance with a damp cloth and a neutral cleaning agent, such as washing-up liquid and wa-ter.2.Dry with a soft cloth.10.3 Cleaning the stainless steel surfaces1.Always remove limescale, grease, starch or albuminstains immediately.Corrosion may form under such stains.2.Clean with water and some washing-up liquid.3.Dry with a soft cloth.10.4 Cleaning the glass front▶Clean the glass front using a glass cleaning productand a soft cloth.‒Do not use any abrasive sponges that may scratch or any glass scrapers.10.5 Cleaning the anti-slip mat1.Remove the anti-slip mat to clean it.2.Clean the anti-slip mat with washing-up liquid.11 TroubleshootingYou can rectify minor faults on your appliance yourself.Read the troubleshooting information before contactingafter-sales service. This will avoid unnecessary costs.WARNING ‒ Risk of injury!Improper repairs are dangerous.▶Repairs to the appliance should only be carried out by trained specialist staff.▶If the appliance is defective, call Customer Service.WARNING ‒ Risk of electric shock!Incorrect repairs are dangerous.▶Repairs to the appliance should only be carried out by trained specialist staff.▶Only use genuine spare parts when repairing the appliance.▶If the power cord of this appliance is damaged, it must be replaced by trained specialist staff.11.1 MalfunctionsFaultCause and troubleshooting The cookware or food is not heating up.There has been a power cut.▶Check whether the lighting in your kitchen or other appliances are working.The appliance is switched off.▶Switch the appliance on.The warming drawer is not completely closed.▶Close the warming drawer.How it works en7FaultCause and troubleshooting The appliance is not working.The circuit breaker is faulty.▶Check the circuit breaker in the fuse box.The cookware or food does not get warm enough.The cookware or food has not been heated for long enough.▶Heat the cookware or the food for a longer period of time.The warming drawer is not completely closed.▶Close the warming drawer.The warming drawer was open for a long time.▶Close the warming drawer.The warming drawer was not adequately preheated.▶Preheat the warming drawer sufficiently.The ventilation opening has been blocked by tableware.▶Remove tall tableware from the ventilation opening.The operation indic-ator light does not light up.The operation indicator light is defective.▶Call the after-sales service. → "Customer Service", Page 8The fuse in the fuse box has blown.The circuit breaker is faulty.▶Pull out the mains plug.▶Call the after-sales service. → "Customer Service", Page 812 How it worksHere, you can find the ideal settings for various dishes as well as the best accessories and cookware. We have tailored these recommendations to your appliance.12.1 Recommended settingsThe following settings have been specially tested for your appliance.Tableware and drinking vessels DishPreheating thePreheating tableware Level InformationDefrosting frozen foods DishPreheating the Preheating tableware LevelInformationen Customer Service 8Warming DishPreheating thePreheating tableware Level InformationmuffinsKeeping warm DishPreheating the Preheating tablewareLevel InformationMelting DishPreheating the Preheating tableware LevelInformationProving dough Dish Preheating thePreheating tableware Level Information trays13 Customer ServiceDetailed information on the warranty period and terms of warranty in your country is available from our after-sales service, your retailer or on our website.If you contact Customer Service, you will require the product number (E-Nr.) and the production number (FD) of your appliance.The contact details for Customer Service can be found in the enclosed Customer Service directory or on our website.13.1 Product number (E-Nr.) and production number (FD)You can find the product number (E-Nr.) and the pro-duction number (FD) on the appliance's rating plate.You can see the rating plate with these numbers when you open the drawer.Make a note of your appliance's details and the Cus-tomer Service telephone number to find them again quickly.14 Installation instructionsObserve this information when installing the appliance.Installation instructions en914.1 Included with the applianceAfter unpacking all parts, check for any transport dam-age and for completeness of delivery.14 cm29 cm14.2 Installation in the cabinetYou will find the dimensions of the appliance here14 cm29 cm14.3 Instructions for the electrical connectionIn order to safely connect the appliance to the elec-trical system, follow these instructions.¡The appliance must only be connected to a protect-ive contact socket that has been correctly installed.Only a qualified electrician may install a socket or replace the connecting cable, taking the appropriate regulations into account.¡The appliance must only be connected with the power cable provided. Connect the power cable to the back of the appliance.¡Connecting cables with various plug types are avail-able from after-sales service.¡No multi-plugs, multiple connectors or extension leads must be used. Overloading causes a risk of fire.¡If the plug can no longer be reached after the in-stallation, a partition must be provided in the phases in the permanent electrical installation in accord-ance with the installation regulations.Follow these safety instructions when in-stalling the appliance.WARNING ‒ Risk of suffocation!Children may put packaging material over their heads or wrap themselves up in it and suffocate.▶Keep packaging material away from chil-dren.▶Do not let children play with packaging ma-terial.WARNING ‒ Risk of electric shock!If the insulation of the power cord is dam-aged, this is dangerous.▶Never let the power cord come into contact with hot appliance parts or heat sources.▶Never let the power cord come into contact with sharp points or edges.▶Never kink, crush or modify the power cord.en Installation instructions10WARNING ‒ Risk of injury!Sharp-edged parts may be accessible during installation.▶Wear protective gloves.14.5 InstallationFitted unitsThis is where you can find information about safe in-stallation.ATTENTION!Covering the ventilation slots and air intake openings causes the appliance to overheat.▶Do not cover ventilation slots and air intake open-ings.If the appliance is installed behind a decorative panel,this may cause it to overheat.▶Do not install the appliance behind a decorative panel.The built-in unit must not have a rear panel behind the appliance.The minimum distance between the wall and the cab-inet base or back wall of the cabinet that is situated above must be complied with.Observe the installation instructions for the appliance installed above.If no intermediate floor is possible above the appliance or above the oven, install tilt protection for the appli-ance. Suitable tilt protection can be obtained from cus-tomer service, on our website or in the online shop.Installing the applianceWARNING ‒ Risk of electric shock!If the insulation of the power cord is damaged, this is dangerous.▶Never let the power cord come into contact with hot appliance parts or heat sources.▶Never let the power cord come into contact with sharp points or edges.▶Never kink, crush or modify the power cord.WARNING ‒ Risk of injury!After removing the transport lock, the drawer may open suddenly during transport.▶Transport the appliance in such a way that the drawer does not accidentally open.The high weight of the appliance may result in injury when lifted.▶Do not lift the appliance on your own.1.Insert the power cord into a protective contactsocket.The power cord must not touch the rear and base of the appliance after installation.2.Insert the appliance.3.Centre the appliance.4.5.Remove and dispose of the protective padding.安全性 zh 11目录使用说明书1安全性 (11)2避免财产损失 (12)3环境保护和节约 (12)4了解机器 (12)5首次使用前 (12)6餐具 (13)7操作基本知识 (13)8预热餐具 (13)9食物保温 (13)10清洁和保养 (14)11处理故障 (14)12工作原理 (15)13客户服务 (16)14安装说明书 (16)14.4安全安装..............................................................171 安全性请注意以下安全注意事项。

4Fang安装版操作手册

目录第一章会计帐务处理 (2)1.系统结构 (2)2.凭证的输入和相关操作 (4)3.科目的设置 (9)4.数据初始化 (10)5.辅助核算初始化 (12)6.凭证工具箱 (13)7.辅助核算设置和辅助核算分录输入 (14)8.固定资产 (17)9.月末结转 (18)10.自动凭证 (19)11.结帐 (24)12.从其他系统生成凭证 (25)13.帐簿 (26)14.报表 (29)15.报表设计 (34)第| 页 1第一章会计帐务处理1.系统结构我们先来对比一下会计帐务处理中，传统的财务软件的结构和我们系统的结构：第| 页 2这种设计对比传统的财务软件的设计拥有以下特点：巨大的灵活性，和现在的国内会计的事务操作更为贴近。

操作简单，结构更清晰易懂，无需繁杂的操作步骤。

数据录入更为方便。

碰到问题容易找到问题的所在，有助于快捷的解决问题。

同步实时运算，一经更改，所有改变将马上在帐簿和报表中反映。

同时支持新旧会计制度，同时支持所有不同的行业！设置简单方面。

通过设置，也可以转换为传统的操作模式，以适应一些用户固有的使用习惯。

从上面的对比中我们看到，对于我们的会计帐务处理，数据只来自凭证和初始化数据，也就是说，只要你的初始化数据和凭证正确，帐簿和报表都是全自动整理生成的，而且因为报表和帐簿是动态的，你的任何修改都会立即反映，无需复杂的登帐、结帐过程。

我们还可以看到，我们对初始化数据和凭证输入是对等关系，不需要你必须先做好数据的初始化才能输入凭证，你完全可以先输入凭证，再慢慢调整和输入初始化的数据，这种设计为你赢得了时间，也给你最大的方便，也为全动态的帐簿和报表提供了可能。

在程序的设计中，全动态的帐簿和报表的意思是说：实际上，我们软件是“没有”帐簿和报表存在的，帐簿都是在你每次需要查询的时候动态的重新登帐生成的帐簿显示给你，报表都是在你每次查询的时候直接在凭证和初始化数据统计生成显示给你。

报表并不像手工做帐或者其他财务软件那样从帐上取数，它是直接从凭证第| 页 3动态汇总而得。

SAPHANA安装手册薄.docx

SAP HANA安装手册1、操作系统安装选择操作系统版本为 SUSE Linux Enterprise for SAP Applications 12 SP1 以下为操作系统安装1、选择安装语言语言默认为English(US)，键盘默认为English(US)，点击 next ；2、选择安装选项本次安装选择SLES for SAP选择 start the sap installation wizard right after the OS installation选择 next3、选择下一步选择下一步选择时区为上海输入 root 密码下一步开始安装，点击Install等待安装进度完成后，安装成功，登陆系统。

二、 SAP HANA数据库安装1、安装前准备在初次安装过程中遇到提示 Libssl.so 错误的问题，因此需要提前检查相关设置在yast 中，安装相关组件，如下图注：在默认安装过程中发现，SAP HANA Server Base 该选项未安装，需要手工选中进行安装。

2、 Sap HANA数据库的安装将安装包上传到服务器本次安装的数据库软件为 51050506 中的 HDB_SERVER_LINUX_X86_64，使用 root 用户进行安装。

进如软件目录后，执行 ./hdbinst 进行安装配置。

TESTHANA:/HDB_SERVER_LINUX_X86_64 # ./hdbinstSAP HANA Database installation kit detected.SAP HANA Lifecycle Management - Database Installation 1.00.110.00.1447753075****************************************************************************Enter Local Host Name [testhana]:（ HANA 默认取服务器主机名）Enter Installation Path [/hana/shared]:（默认安装目录）Enter SAP HANA System ID: HAT（ HANA SID，一般为三位）Enter Instance Number [00]:（设置 Instance 的代码，默认从00 开始）Index | Database Mode| Description-----------------------------------------------------------------------------------------------1| single_container| The system contains one database2| multiple_containers | The system contains one system database and 1..n tenant databasesSelect Database Mode / Enter Index [1]:注：模式 1 ，single 模式，属于在HANA 服务器上使用单实例的模式，公用内存和cpu 模式 2， multiple 模式，属于在HANA 服务器上使用多租户的模式，可以独立设置CPU 和内存的使用量，本次默认选择1Index | System Usage | Description-------------------------------------------------------------------------------1| production| System is used in a production environment2| test| System is used for testing, not production3| development| System is used for development, not production4| custom| System usage is neither production, test nor developmentSelect System Usage / Enter Index [4]: 2（该选项为HANA 系统的标识为那种模式，并无根本的功能上的区别）Enter System Administrator (hatadm) Password: （置服务器中新增HANA 管理员的账户密码）Confirm System Administrator (hatadm) Password:Enter System Administrator Home Directory [/usr/sap/HAT/home]:Enter System Administrator Login Shell [/bin/sh]:Enter System Administrator User ID [1000]:Enter ID of User Group (sapsys) [79]:Enter Location of Data Volumes [/hana/shared/HAT/global/hdb/data]:Enter Location of Log Volumes [/hana/shared/HAT/global/hdb/log]:Restrict maximum memory allocation? [n]:Enter Database User (SYSTEM) Password:（设置 HANA 数据库管理员的用户密码）Confirm Database User (SYSTEM) Password:Restart system after machine reboot? [n]:（设置是否开机启动，建议不要开机启动）Summary before execution:Installation Path: /hana/sharedSAP HANA System ID: HATInstance Number: 00—Database Mode: single_containerSystem Usage: testSystem Administrator Home Directory: /usr/sap/HAT/homeSystem Administrator Login Shell: /bin/shSystem Administrator User ID: 1000ID of User Group (sapsys): 79Location of Data Volumes: /hana/shared/HAT/global/hdb/dataLocation of Log Volumes: /hana/shared/HAT/global/hdb/logLocal Host Name: testhanaDo you want to continue? (y/n): y（开始安装）Checking installation...Preparing package 'Saphostagent Setup'...Preparing package 'Python Support'...Preparing package 'Python Runtime'...Preparing package 'Product Manifest'...Preparing package 'Binaries'...Preparing package 'Installer'...Preparing package 'Ini Files'...Preparing package 'HWCCT'...Preparing package 'Emergency Support Package'...Preparing package 'EPM'...Preparing package 'Documentation'...Preparing package 'Delivery Units'...Preparing package 'DAT Languages'...Preparing package 'DAT Configfiles'...Creating System...Extracting software...Installing package 'Saphostagent Setup'...Installing package 'Python Support'...Installing package 'Python Runtime'...Installing package 'Product Manifest'...Installing package 'Binaries'...Installing package 'Installer'...Installing package 'Ini Files'...Installing package 'HWCCT'...Installing package 'Emergency Support Package'...Installing package 'EPM'...Installing package 'Documentation'...Installing package 'Delivery Units'...Installing package 'DAT Languages'...Installing package 'DAT Configfiles'...Creating instance...hdbparam: Working configuration directory:"/hana/shared/HAT/global/hdb/custom/config"—hdbnsutil: creating persistence ...hdbnsutil: writing initial topology...hdbnsutil: writing initial license: status check = 2Starting SAP HANA Database system...Starting 1 process on host 'TESTHANA':Starting on 'TESTHANA': hdbupdconfStarting 7 processes on host 'TESTHANA':Starting on 'TESTHANA': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengineStarting on 'TESTHANA': hdbcompileserver, hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengineStarting on 'TESTHANA': hdbcompileserver, hdbdaemon, hdbindexserver, hdbwebdispatcher, hdbxsengineStarting on 'TESTHANA': hdbdaemon, hdbindexserver, hdbwebdispatcher, hdbxsengineStarting on 'TESTHANA': hdbdaemon, hdbwebdispatcher, hdbxsengineStarting on 'TESTHANA': hdbdaemon, hdbwebdispatcherAll server processes started on host 'TESTHANA'.Importing delivery units...Importing delivery unit HCO_INA_SERVICEImporting delivery unit HANA_DT_BASEImporting delivery unit HANA_IDE_COREImporting delivery unit HANA_TA_CONFIGImporting delivery unit HANA_UI_INTEGRATION_SVCImporting delivery unit HANA_UI_INTEGRATION_CONTENTImporting delivery unit HANA_XS_BASEImporting delivery unit HANA_XS_DBUTILSImporting delivery unit HANA_XS_EDITORImporting delivery unit HANA_XS_IDEImporting delivery unit HANA_XS_LMImporting delivery unit HDC_ADMINImporting delivery unit HDC_IDE_COREImporting delivery unit HDC_SEC_CPImporting delivery unit HDC_XS_BASEImporting delivery unit HDC_XS_LMImporting delivery unit SAPUI5_1Importing delivery unit SAP_WATTImporting delivery unit HANA_BACKUPImporting delivery unit HANA_HDBLCMImporting delivery unit HANA_SEC_BASEImporting delivery unit HANA_SEC_CPImporting delivery unit HANA_ADMINInstallation doneLog file written to '/var/tmp/hdb_HAT_install_2016-03-01_14.51.03 /hdbinst.log' on host'TESTHANA'.—HDB stopHDB startHDB proc查看系统能够状况：注： 00 代表系统号sapcontrol -nr 00 -function GetProcessList欢迎下载11。

的安装指南

发布信息本手册进行了以下更改。

更改历史记录日期发行号保密性变更2003 年 9 月A非保密RealView Developer Suite v2.0 版2004 年 1 月B非保密RealView Developer Suite v2.1 版2004 年 12 月C非保密RealView Developer Suite v2.2 版2005 年 5 月D非保密RealView Developer Suite v2.2 SP1 版2006 年 3 月E非保密RealView Development Suite v3.0 版2007 年 3 月F非保密RealView Development Suite v3.1 版2008 年2 月G非保密RealView Development Suite v3.1 Professional 版2008 年 9 月H非保密RealView Development Suite v4.0 版所有权声明除非本所有权声明在下面另有说明，否则带有?或?标记的词语和徽标是ARM Limited 在欧盟和其他国家/地区的注册商标或商标。

此处提及的其他品牌和名称可能是其各自所有者的商标。

本文档描述的产品还将不断发展和完善。

ARM Limited 将如实提供本文档所述产品的所有特性及其使用方法。

但是，所有暗示或明示的担保，包括但不限于对特定用途适销性或适用性的担保，均不包括在内。

本文档的目的仅在于帮助读者使用产品。

对由于使用本文档任何信息出现的遗漏、损坏或错误使用产品造成的任何损失，ARM Limited 概不负责。

Global4.0操作使用手册

上海云速网络科技有限公司Go-Global For Windows操作手册上海云速网络科技有限公司shanghai appacc－Tech Co.,LtdTel:(86)021- 50278021目录第一章安装要求 (3)第二章软件安装 (3)2.1 安装步骤 (3)2.2调试IIS 右击【我的电脑】【管理】 (8)2.3 许可导入 (9)2.4 启动服务进程 (11)第三章操作说明 (12)3.1 Cluster Manager (12)3.2 Go-Global Server状态设定 (17)3.3 Load Balancing (23)3.5安装Windows Client (31)3.6 Global 客户端登录 (32)3.7 客户端打印机设置 (37)第四章外网发布 (39)第一章安装要求系统安装Global 4.0 分32位和64位版本：Windows Server 2008 Standard or Enterprise Edition with Service Pack 2 (x86 and x64) Windows Server 2008 R2 Standard or Enterprise Edition (x64)Windows Server 2003 R2 Standard or Enterprise Edition (x86)Windows Server 2003 Standard or Enterprise Edition with Service Pack 2 (x86) Windows 7 (x64)Windows Vista with Service Pack 2 (x86 and x64)Windows XP Professional with Service Pack 3 (x86)网页要求IIS或者Apache作用：网页登录GLOBAL ；提供下载不同版本系统客户端。

BO服务器安装文档

1.启动安装程序：
2.查看安装的先决条件：
3.安装.net framework 后再重新安装：
4.条件都成功后，点击下一步：
5.进入下一步：
6.选择接受后进入下一步：
7.填写密钥后进入下一步：
8.选择安装语言：
9.默认选择“完整”：
10.根据需要选择安装路径：
11.更改默认选择，选择“配置现有数据库”：
12.选择资料库所在的数据库类型：
13.更改默认选项，选择“无审核数据库”：
14.无需更改，进入下一步：
15.默认选项，进入下一步：
16.默认节点和端口号信息，进入下一步：
17.默认CMS端口号，进入下一步：
18.设置BI登录密码：
19.填写对应数据库的信息：
20.默认选择，若有冲突再更改：
21.默认选择，进入下一步：
22.设置subversion密码：1qaz2wsx
23.默认选择，进入下一步：
24.选择“不配置”，进入下一步：
25.进入下一步：
26.安装完成：。

BO培训手册

1INFORMIX-CLI的安装1.1 启动安装进入INFORMIX-CLI安装目录，如下图所示，双击setup.exe文件：1.2 开始安装1.2.1进入WELCOME页面，1.2.2单击Next，进入SystemRequirements页面1.2.3单击Next，进入Product Regisration页面一1.2.4单击Next，进入Product Regisration页面二1.2.5单击Next，进入Destination Location页面注：单击Browse 按钮可改变安装位置1.2.6单击NEXT，开始安装INFORMIX-CLI安装完毕后，单击OK,，重启计算机进入INFORMIX-CLI的设置。

2INFORMIX-CLI的设置2.1 INFORMIX SetNet32设置2.1.1启动Informix SetNet32在INFORMIX-CLI的快捷方式文件夹中双击Informix SetNet32的快捷方式2.1.2进入INFORMIX SETNET322.1.3单击Server Information 选项卡，设置服务器信息2.1.4单击Host Information 设置主机信息2.2 ODBC Administrator 322.2.1启动ODBC Administrator在INFORMIX-CLI的快捷方式文件夹中双击ODBC Administrator的快捷方式2.2.2设置ODBC数据源信息2.3.1启动Ilogin3BO的安装3.1 启动安装进入BO安装目录，单击Setup 目录下的setup.exe 文件，开始安装BO3.2 单击开始按钮，进入用户信息对话框按要求输入用户的信息3.3 单击下一步，进入许可标识对话框按要求输入用户的许可标识3.4 单击下一步，选择安装方式在这里我们选择独立安装3.5 单击下一步，选择安装配置文件在这里我们选择默认值：快速安装3.6 单击下一步，选择安装文件夹在这里我们选择默认值3.7 单击安装，开始安装BO选择是，创建安装文件夹单击确定，如果在系统中发现文件DLL更新的版本，则提示用户单击是，是查看自述文件，单击否跳过，在这里我们跳过安装完毕后，创建快捷方式文件夹，如下图所示安装完毕后，出现安装成功提示框单击检查中间件，检查系统是否安装中间键4BO的设置4.1 SUPERVISOR模块的设置4.1.1启动SUPERVISOR模块进入BO快捷方式文件夹，双击Supervisor 快捷方式，启动SUPERVISOR模块输入用户名及口令。

BO安装指南

BO安装指南第一章综述BO应用软件包括服务器和客户端程序，本文档专门描述如何在客户端PC机上正确安装Sybase Open Client和BO软件，以及如何配置。

在安装前，必须准备一台PC机（WIN98或WIN2000操作系统，不推荐WIN2003操作系统）、2张BO 软件安装光盘以及1张Sybase Open Client安装光盘（WIN98版或NT版），下面介绍详细安装步骤（如果顺利半个小时以内可以完成）。

第二章安装步骤1、安装Sybase Open Client1）将标记有Sybase的光盘放入光驱，找到光盘上的Sybase目录，运行该目录下的Setup.exe程序；2）在提示窗口点击NEXT，当出现要求输入CAS序列号的窗口时，打开Sybase 目录下的cas.txt文件，复制CAS序列号到该提示窗口，再点击NEXT；3）依次点击NEXT，当出现选项安装提示窗口时，在所有选项前面的方框内打勾选中，再点击NEXT（注意其中一个选项：选择Ingore for now）；4）在最后提示窗口下点击INSTALL，则开始安装；5）在后面的提示窗口中按其缺省设置点击OK即可，最后提示是否重新启动计算机（可以等BO安装完成后再重新启动）。

2、安装BO1）将标记有BO5.1 DISK1的光盘放入光驱，依次进入目录：BO5.1 vol1/Vol1 /Setup，运行该目录下的Setup.exe程序；2）在提示窗口点击NEXT，出现用户信息窗口时，输入自己的用户名和公司名，再点击NEXT；3）出现许可证信息窗口时，要求输入产品序列号和数据接入序列号（分别为BJ2R-D6RMG-GPKG、K629-54758-PS8B），同样可以打开光盘根目录下的key.txt文件，复制下这两个序列号，然后输入到该提示窗口，再点击NEXT；4）在以下的提示窗口中按其缺省设置点击OK即可，最后点击INSTALL，则开始安装；5）出现要求插入第二张光盘的提示窗口时，从光驱取出BO5.1 DISK1光盘，放入BO5.1 DISK2光盘，在提示窗口点击Browse按钮，选择光盘上的Online Guides目录下的EN目录，点击确定按钮，则开始安装帮助文件；6）在后面的提示窗口中按其缺省设置点击OK即可3、配置Sybase Open Client和BO1）从“开始”菜单的程序里选择Sybase下的Dsedit程序运行，在出现的提示窗口中点击OK；2）选择主菜单Server Object下的Add选项，出现要求输入服务器名称的对话框，则输入自己要接入的BO服务器名称（DHZOMC1）；3）在服务器属性窗口中选择Server Address，按鼠标右键弹出菜单，选择Modify Attributes选项；4）出现服务器地址信息窗口，点击ADD，输入服务器的IP地址和端口号（即：Protocol项选NLWNSCK；Network Address项填132.105.19.1,5025）；5）确认服务器名称和地址正确后点击“OK”退出Dsedit程序；6）要接入服务器的数据库，还需要两个文件，这是从服务器上产生的Bomain.key和Bomain.lsi文件（可以从其它已经安装BO软件的计算机拷贝），将它们拷贝到“c:\Program files\Business Objects\BusinessObjects 5.0\Locdata”目录下即可；7）拷贝现有目录UNIVERSE与USERDOCS至新安装BO软件的计算机相应目录；8）配置完成后，运行Business Objects，输入自己的用户名和密码即可接入BO服务器的数据库，实现数据库查询和报表输出等功能（用户名为eric，密码一般为空，Domain为HZBOMain）。

BO报表全中文安装手册

BO报表全中文安装手册目录第一章系统运行环境 (3)1.1硬件配置 (3)1.2软件环境 (3)1.3产品介绍 (3)1.3.1 Business Objects 客户端分析工具 .. 5 1.3.2 Web Intelligence Web分析工具 (6)1.3.3 InfoView 商业智能信息门户 (6)1.3.4 Designer 语义层设计 (6)1.3.5 Supervisor 商务智能安全管理 (7)1.3.6 BOE Auditor 审计功能 (8)第二章系统安装前准备 (9)1.1 安装机器情况 (9)1.2 配置安全策略 (9)1.3 安装web服务器 (11)第三章BO产品安装 (14)第四章BO系统配置 (19)第一章系统运行环境1.1硬件配置项目配置环境说明计算机最低配置：Pentium II 533M，256M内存，3G剩余硬盘空间建议配置：PentiumIII 1G，512M内存，5G以上剩余硬盘空间最佳配置：Pentium 4 2G以上，1G内存，10G以上剩余硬盘空间互联网连接最低配置：56kV.90Modem 拨号上网访问技术支持网站、查询常见问题和软件升级信息建议配置：宽带互联网连接1.2软件环境项目配置环境说明服务产品WINNT4.0+sp4以上（IE5.0以上）BO服务器必须安装在一台服务器上，不应该和BO桌面产品装在同一台机器上桌面产品WIN98/WINME/WINNT4.0+sp4以上/WIN2000/WINXP/WIN95（IE5.0以上）1.3产品介绍服务器产品产品名称说明Business ObjectsserverInfoViewWebIntelligence BusinessObjects Web InstallerBroadcast Agent Connection Server (CORBA-basedversion)桌面产品产品名称说明BusinessObjects3-tierBusinessObjects BusinessQuery forExcel管理产品产品名称说明DesignerSupervisorSupervisor over theWebAuditorConfiguration ToolAdministrationConsoleBroadcast AgentConsole主要产品介绍如下：1.3.1 Business Objects 客户端分析工具Business Objects可以为您的企业提供完整的咨询，报表制作及分析功能。

HANA服务器安装步骤

HANA服务器安装步骤HANA服务器安装步骤一、硬件环境两台电脑，一台为服务器装跑HANA虚拟机，一台为客户端运行HANA_STUDIO服务器：内存至少需要16G windows server 2003 64位客户端：windows 7 64位二、软件环境服务器：VMware 9.0 HANA虚拟机镜像客户端：jdk sapcar SAP_HANA_CLIENT SAP_HANA_STUDIO 软件的下载地址如下：HANA虚拟机镜像：/doc/3c15197120.html,/share/link?sh areid=529008&uk=553730487sapcar，HANA_STUDIO和HANA_CLIENT：/doc/3c15197120.html,/share/link?sh areid=546348&uk=553730487三、安装服务器：安装虚拟机软件VMware 9.0客户端：1.安装JDK，HANA_STUDIO安装需要JDK以下步骤可以参考HANA Academy - Installing the SAP HANA Studio and SAP HANA Client tools视频2.使用sapcar解压缩HANA_CLIENT和HANA_STUDIO在命令行模式下，用CD命令进去到sapcar，HANA_CLIENT和HANA_STUDIO的下载目录输入命令：sapcar -xvf "I*.SAR" 来解压缩HANA_CLIENT和HANA_STUDIO解压缩完成后会产生两个文件夹SAP_HANA_CLIENT和SAP_HANA_STUDIO3.安装SAP_HANA_CLIENT进入SAP_HANA_CLIENT文件夹，双击hdbinst.exe在出现的窗口中直接按回车，以默认路径安装安装完成后显示 Installation done 在管理工具-数据源(odbc)-系统dns-添加可以看到HDBODBC4.安装SAP_HANA_STUDIO进入SAP_HANA_STUDIO文件夹，双击hdbinst.exe在出现的窗口中直接按回车，以默认路径安装安装完成后显示 Installation done，在开始菜单-程序里面可以找到HANA_STUDIO四配置服务器：1.解压缩HANA虚拟机镜像SUSE Linux Enterprise 11 64-bit HANA SP4.7z2.进去虚拟机文件夹,用记事本打开SUSE Linux Enterprise 11 64-bit.vmx文件,修改ethernet0的connectionType由"NAT"改为"bridged" ,这样客户端电脑才能连接。

15 附录2 HANA 工作室与BO4.0等客户端安装操作手册_20120309(字数2957,20页)

附录2 HANA工作室与BO4.0等客户端安装操作手册一、HANA Studio（建模工作站）客户端程序安装现在您正处在下图A2.1.1第3步骤，HANA Studio（建模工作站）的安装。

安装完HANA Studio 工作站，您可以操作第6步配置ECC数据复制以及第9步HANA建模操作。

图A2.1.1 辽宁公司HANA1.0版验证步骤地图1.检查及安装JAVA Development Kit（JDK）(1)安装HANA STUDIO之前必须确认本机安装了JDK(JAVA Development Kit)1.6版本，点击“开始”→“运行”（快捷键：Windows+R），输入【CMD】，如下图A2.1.2所示：图A2.1.2Windows“运行”窗口(2)输入指令：java –version（小写）。

回车，查看JDK版本，若返回‘JAVA’不是内部或外部指令…….说明JDK没有被安装，至少JDK环境变量没有设置，如下图图A2.1.3所示：图A2.1.3 cmd通过命令查询JAVA版本截屏(3)下载HANA STUDIO以及JDK1.6安装文件。

(4)运行JDK1.6文件夹下的安装文件，一直点击“下一步”，直到完成安装（建议使用默认路径，这样下面操作你可以直接按照本操作手册完成）。

JDK安装程序界面如下图A2.1.4所示：图A2.1.4 JDK1.6安装程序界面(5)再次运行CMD，输入指令java –version查看JDK版本。

如下图所示：图A2.1.5 cmd通过命令查询JAVA版本截屏2.配置JDK操作系统环境变量(1)右击桌面“我的电脑”，点击“属性”，如左下图A2.1.6所示：图A2.1.6 我的电脑系统属性界面(2) 进入“高级”标签页，点击“环境变量”按钮，如上右图：(3) 新建环境变量“JAVA_HOME ”。

JAVA_HOME 指向的是JDK 的安装路径，在该路径下你应该能够找到bin 、lib 等目录。

hana 配置安全基线标准与操作指南

hana 配置安全基线标准与操作指南下载提示：该文档是本店铺精心编制而成的，希望大家下载后，能够帮助大家解决实际问题。

文档下载后可定制修改，请根据实际需要进行调整和使用，谢谢！本店铺为大家提供各种类型的实用资料，如教育随笔、日记赏析、句子摘抄、古诗大全、经典美文、话题作文、工作总结、词语解析、文案摘录、其他资料等等，想了解不同资料格式和写法，敬请关注！Download tips: This document is carefully compiled by this editor. I hope that after you download it, it can help you solve practical problems. The document can be customized and modified after downloading, please adjust and use it according to actual needs, thank you! In addition, this shop provides you with various types of practical materials, such as educational essays, diary appreciation, sentence excerpts, ancient poems, classic articles, topic composition, work summary, word parsing, copy excerpts, other materials and so on, want to know different data formats and writing methods, please pay attention!Title: Hana配置安全基线标准与操作指南一、引言在网络安全日益突出的今天，保障数据系统的安全已经成为各行各业的一项重要任务。

HANA STUDIO 安装使用手册

一、HANA STUDIO 安装下载安装包(32bit/64bit)
点击hdbsetup.exe，开始安装
选择保存的路径，然后点next
点install
等待中，大概3-4分钟
提示安装成功，点Finish
二、系统配置及登录
在开始菜单-.所有程序->SAP HANA->SAP HANA STUDIO，启动程序，
点击Open Modeler 进入SAP HANA Modeler视图，在左侧Systems区域点击右键，开始添加系统，连接HANA服务器。

点击Add System 之后弹出以下对话框，填写服务信息。

如上图所示，
填写Host Name, 一般指服务器的IP。

填写Instance Number ，默认填写 00
Description, 可不填。

填写完成后，点击Next, 进入下一步，
如上图，填写用户名和密码，点击Finish, 如果填写的服务器信息和用户名信息正确，则可成功连接。

连接成功后，可看到左侧system区域会显示已经连接成功的HANA system,
三、数据查询
点击Catalog , 展开目录，可以看到如下结构，
类似于其他常用数据库系统，其中有Schema、表、视图、存储过程等等。

在相应的表或视图上，右键，选择Open Data Preview菜单，即可查询表或视图的数据。

在左侧区域选中任意表或视图，在点击上面图标，即可以在右侧区域打开SQL 查询窗口，写相应的SQL 查询语句。

SQL 语句写好后，点击绿色箭头图标或按F8键，即可以开始执行查询。

SAP_BO安装手册

系统server2003 enterprise edition sp20.建立表空间，创建3个用户开始菜单------运行-----CMD-----输入：Sqlplus /nologConn /as sysdba建立一个表空间，创建4个用户DW：数据仓库BO：产品CMSDI：资料作用BOW：数据审核仓库--(暂时不建)CREATE TABLESPACE DW_DATA01 DATAFILE 'F:\ORACLE\ORADATA\ORA9I\dw_data01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ; CREATE TABLESPACE DW_INDEX01 DATAFILE 'F:\ORACLE\ORADATA\ORA9I\dw_index01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;CREATE TABLESPACE BO_DATA01 DATAFILE 'F:\ORACLE\ORADATA\ORA9I\bo_data01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ; CREATE TABLESPACE BO_INDEX01 DATAFILE 'F:\ORACLE\ORADATA\ORA9I\bo_index01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;CREATE TABLESPACE DI_DATA01 DATAFILE 'F:\ORACLE\ORADATA\ORA9I\di_data01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ; CREATE TABLESPACE DI_INDEX01 DATAFILE 'F:\ORACLE\ORADATA\ORA9I\di_index01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;CREATE USER DW IDENTIFIED BY sap DEFAULT TABLESPACE dw_DATA01 TEMPORARY TABLESPACEtemp;GRANT connect,dba to DW;CREATE USER DI IDENTIFIED BY sap DEFAULT TABLESPACE di_DATA01 TEMPORARY TABLESPACE temp;GRANT connect,dba to DI;CREATE USER BO IDENTIFIED BY sap DEFAULT TABLESPACE bo_DATA01 TEMPORARY TABLESPACE temp;GRANT connect,dba to BO;1.装好oracle数据库后，安装BOE平台产品序列号：BOE2:BOE智能平台：CC20D-8GG4Z2S-ER0100J-VAUY仪表盘：CG206-HNTKW28-ERMSGFE-D8YT模拟分析：CN51C-8FG4Z2S-ERU0J8N-KKNU智能报表：B6W6G-31CSJV5-000A030-0CB0DI数据整合：CH21C-F5VKW24-ERUFBDN-05RF智能分析：不需要licenseE:\BO_2X-3X\BOE2-ENTERPRISE_1全名为计算机用户名然后一直下一步就开始安装了直到安装完成2.安装DI 产品(E:\BO_2X-3X\Data_services_XI_3.1\12.1.1.1\Win32\cdroot) 计算机名tt-biServer name是计算机名一直next 等待安装3.安装水晶易表(E:\BO_2X-3X\BOE2-CX\Xcelsius_2008_SP1\SP1)然后一直下一步，直到安装完成。

17 附录4 基于HANA的BO与Excel操作手册_20120309(字数378,5页)

附录4 基于HANA的BO与Excel操作手册
1.打开Excel，进入“数据（Data）”标签页，选择“来自数据连接向导（From Data Connection Wizard）”，如下图A4.1.1所示：
图A4.1.1 MS Excel 数据来源选择界面
2.数据源选择“其他/高级”（Other/Advanced），如下图A4.1.2所示：
图A4.1.2 数据连接向导选择数据源类型
3.连接口规范“SAP HANA MDX Provider”，如下图A
4.1.3所示：
图A4.1.3数据连接属性选择界面
4.填写连接属性，点击“Test Connection”，测试成功后，点击确定。

图A4.1.4测试连接成功画面
5.选择您的Package，自动更新package下的视图，如下图A4.1.5所示：
图A4.1.5 选择HANA开发包6.选中一个视图，点击“下一步”，如图A4.1.6所示：
图A4.1.6选择开发包下模型名称
7.保存数据连接文件，点击“完成”，如下图A4.1.7所示：
图A4.1.7 数据连接命名界面
8.选择数据输出范围和显示方式，点击“确定”，如下图A4.1.8所示：
图A4.1.8 选择数据展现区域
9.再次连接，输入用户名和密码，如下图A4.1.9所示：
图A4.1.9 数据库连接界面
10.勾选需要输出的字段，如下图A4.1.10所示：
图4.1.10 Excel查询HANA数据库界面示例。

Hana建模入门

安装hana studio之后需要打上必要的补丁一，补丁安装
选择补丁路径
二，添加系统
选择hana modeler，添加系统
输入ip和序列号
点击下一步
输入用户名密码
三，界面简介进入hana studio界面
1.catalog
Catalog下是hana数据库实际表，视图等
在hana studio能看到sap的表，视图等，但在hana studio创建的表和视图在BW 系统中是不可见的。

通过创建虚拟提供者连接hana视图或者表才能读取。

2 content
我们用hana studio创建的属性视图，分析视图，计算视图都放在content下面的包
四，创建表
在catalog->table下面右键选择new table 如下图，创建了供应商主数据表
创建区域主数据表
创建公司主数据表
创建订单业务数据表
查看数据
插入数据
用sql语句插入数据
同时完成其他数据插入
五，建属性视图
在自己的包下创建属性视图
以建公司代码的属性视图为例
在catalog中自建表拉到data foundation里，激活需要的字段
Data foundation里可以放多个catalog里的表和视图，字段直接拉线就能关联。

双击关联线可以编辑连接关系
多个表连接需要确定key
六，建分析视图
在自己的包下建分析视图
将业务表ORDER_DATA拉到data fundation里将主数据视图拉到data foundation里
业务数据同主数据连接
激活分析视图
预览结果
..。

HANA安装指南

HANA安装指南1.1 安装前准备步骤 1 将SAP HANA的数据库软件和SAP加压缩工具通过winscp复制到服务器上，如图1-1所示，IMDB_SERVER100_52-10009569.SAR是SAP HANA的数据库软件，SAPCAR_5-20002089.EXE是解压缩工具。

图1-1 复制文件1.2 SAP HANA DATABASE安装步骤步骤 1 以root用户名登录，打开“terminal”窗口。

步骤 2 执行“TMOUT=0”。

步骤 3 用“vi /etc/hosts”打开该文件，并在文件最后一行添加“127.0.0.0 新的hostname”，增加新的hostname解析，如图如图6-2图1-2 增加新的hostname解析步骤 4 用“cd”命令切换目录到SAP HANA数据库文件夹拷贝所在的目录下面，本例是“cd /hana/shared/”。

步骤 5 执行“chmod +x *”命令，增加可执行权限，如图1-3所示。

图1-3 增加可执行权限步骤 6 执行“./SAPCAR.EXE -xvf IMDB_SERVER100_52-10009569.SAR”命令，将数据库文件进行解压，如图1-44所示。

图1-4 将数据库文件进行解压得到一个SAP_HANA_DATABASE目录。

图1-5 SAP_HANA_DATABASE目录步骤 7 进行安装SAP HANA数据库操作。

1. 先执行“cd SAP_HANA_DATABASE/”命令，进入SAP_HANA_DATABASE目录，执行“chmod +x �CR *”命令，如图1-6所示。

图1-6 执行命令步骤 8 执行“./hdbinst”命令，显示如图1-77所示界面。

图1-7 执行“./hdbinst”命令，修改参数为/usr/sap步骤 9 按“Enter”，输入System Id为S00，按两次“Enter”。

步骤 10 按照客户需求输入数据库的System Admin密码，按“Enter”再次输入该密码，按“Enter”（要求大小写数字与特殊字符，如用户名S00，密码：Huawei_123）步骤 11 继续按“Enter”一直到出现Location of Data Volumes、Location of LogVolumes，分别输入“/hana/data”、“/hana/log”，按“Enter”，输入“User System”密码，按“Enter”，再次输入该密码，按“Enter”，输入y，按“Enter”，结果显示如图1-8所示。