BB Installation Guide

SAP HANA 1.0
June 2015August 2000
EnglishEnglish
Semantic Intelligence Configuration
(EZ2)
SAP SE
Dietmar-Hopp-Allee 16
69190 Walldorf
Germany / Building Block Configuration Guide

SAP Best Practices Semantic Intelligence Configuration (EZ2): Configuration Guide

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company.

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Please see http://global.sap.com/corporate-en/legal/copyright/index.epx#trademark for additional trademark information and notices.

Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors.

National product specifications may vary.

These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions.

Revision / Change Date / Description
0 / June 6, 2015 / Initial

Icons

Icon / Meaning
/ Caution
/ Example
/ Note
/ Recommendation
/ Syntax

Typographic Conventions

Type Style / Description
Example text / Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths and options.
Cross-references to other documentation.
Example text / Emphasized words or phrases in body text, titles of graphics and tables.
EXAMPLE TEXT / Names of elements in the system. These include report names, program names, transaction codes, table names, and individual key words of a programming language, when surrounded by body text, for example, SELECT and INCLUDE.
Example text / Screen output. This includes file and directory names and their paths, messages, source code, names of variables and parameters as well as names of installation, upgrade and database tools.
EXAMPLE TEXT / Keys on the keyboard, for example, function keys (such as F2) or the ENTER key.
Example text / Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation.
<Example text> / Variable user entry. Pointed brackets indicate that you replace these words and characters with appropriate entries.

Content

Semantic Intelligence configuration for SAP HANA Big Data Intelligence rapid-deployment solution 7

1 Purpose 7

2 Preparation 7

2.1 Prerequisites 7

2.2 Assumptions 7

3 Configuring Semantic Intelligence 8

3.1.1 Deploy the semantic Intelligence foundation delivery unit 8

3.1.2 Execute the seeding process (SQLScript) 8

3.1.3 Deploy the Semantic Intelligence business layer delivery unit 9

4 Creating Operational and Administrative Users 11

4.1 Creating a Solution Admin User 11

4.2 Creating a Solution Business User 12

5 Configuring SAP Data Services 13

5.1 Configuring Data Service Server 13

5.1.1 Install Python patch 13

5.1.2 Create Datastore Users to Connect to SAP HANA 13

5.1.3 Create Local Repository and Configure Job Server 14

5.1.4 Register Local Repository in SAP BusinessObjects BI platform Central Management Console 16

5.2 Apply for Authorization to Social Media Channels 16

5.2.1 Edit Request URL for Channels 17

5.2.2 Apply Authorization for Twitter API 1.1 18

5.2.3 Apply Authorization for SAP Jam 18

5.2.4 Apply Authorization for Google Plus 19

5.2.5 Apply Authorization for YouTube 20

5.2.6 Apply Authorization for Klout 20

5.2.7 Apply Authorization for Facebook (New v2.2 version) 21

5.2.8 Apply Authorization for GNIP 21

5.3 Import and Configure Data Services ATL File 22

5.3.1 Import Data Services ATL File 22

5.3.2 Configure Datastore to SAP HANA Target Database 22

5.4 Executing Data Service Jobs to Retrieve Social Media Data 24

5.4.1 Executing Data Service Jobs to Retrieve Data 24

5.4.2 Scheduling Data Service Jobs to Retrieve Data 25

5.5 Configuring Notifications 26

6 Appendix 28

6.1 SAP HANA Models 28

6.1.1 Configuration UI 28

6.1.2 Attribute Views 29

6.1.3 The underlying SAP HANA Catalog objects 30

6.1.4 Calculation Views (Optional) 32

6.1.5 Troubleshooting 32

6.2 Additional Resources 32

6.2.1 SAP HANA Guides 32

6.2.2 Important SAP HANA Security Notes 33

6.2.3 SAP Data Services 33

SAP Best Practices Semantic Intelligence Configuration (EZ2): Configuration Guide

Semantic Intelligence configuration for SAP HANA Big Data Intelligence rapid-deployment solution

1 Purpose

The purpose of this document is to describe the general configuration steps required to manually set up the semantic intelligence scope item for SAP HANA® Big Data Intelligence rapid-deployment solution. The configuration steps are within the system landscape you have already installed using the corresponding installation or configuration guides for installation.

2 Preparation

2.1 Prerequisites

Before you start installing this scenario, your system landscape must meet the prerequisites for the scope item. For more information about prerequisites, see the SAP Note 1956985 and the Quick Guide attached to that note.

The SAP Note and the Latest Information and Configuration Guide: Getting Started document are available on the SAP Service Marketplace for rapid-deployment solutions, http://service.sap.com/rds-bdi

2.2 Assumptions

The following assumptions are made about the configuration of the technical components for this solution:

1. SAP HANA platform is installed and configured.

The installation and configuration of SAP HANA is not in scope for this solution. An installed and configured SAP HANA environment is a prerequisite for this rapid-deployment solution. For more information about the installation and configuration of the SAP HANA platform, see the SAP Help Portal http://help.sap.com/hana_platform

2. Ensure that SAP HANA® Info Access mobile app is installed and configured. Contact your system administrator in case it is not installed. For more information about SAP HANA Info Access, see the SAP Store http://store.sap.com

3. Ensure InformationAccess and libxsauthenticator entries are included in the xsengine.ini configuration.

4. Ensure automatic_language_detection is set to value of Yes in the preprocessor.ini area of the SAP HANA instance configuration.

5. SAP Data Services is installed and configured.

The installation and configuration of SAP Data Services is not in scope for this solution. The rapid-deployment solution was designed with the assumption that data integration and delivery is performed by SAP Data Services. For more information about the installation and administration of SAP Data Services, see the SAP Help Portal, http://help.sap.com/bods

All other technical installation and configuration prescribed in preceding configuration guides is completed.

3 Configuring Semantic Intelligence

To implement the semantic intelligence scope item available with this rapid-deployment solution, you must configure the solution following the steps:

1. Deploy the semantic foundation delivery unit

2. Execute the seeding process.

3. Deploy the semantic business layer delivery unit

The steps are described in detail in the following sections.

3.1.1 Deploy the semantic Intelligence foundation delivery unit

The following steps are used to load the semantic intelligence foundation delivery unit.

The semantic intelligence foundation delivery unit can be imported using either Server or Client as source of delivery unit file location. If an import from the server is required, contact your system administrator for the server path. This step must be executed using the SAP HANA Deployment User that you created previously.

Procedure

1. Ensure the semantic intelligence foundation delivery unit (HCO_RDS_BDI_SEM_SE_FND) is downloaded into desired location. If it is not available, contact your system administrator.

For more information about acquiring and downloading the delivery units, see the Getting Started Implementing Sentiment Intelligence for the SAP HANA Big Data Intelligence rapid-deployment solution guide attached to the SAP Note 1956985.

2. Choose the Quick Launch window

3. Select the SAP HANA deployment instance

4. Select Import Option.

5. Choose Delivery Unit

6. Select Next.

7. In the Select file section, choose the import location (Server or Client) and specify the location of HCO_RDS_BDI_SEM_SE_FND.tgz

8. Choose Finish to import the content of the delivery unit.

Result

The HCO_RDS_BDI_SEM_SE_FND is successfully deployed. The Job Log shows the status of the package as it loads. If the load is successful, then the status displays Success. Navigate in the SAP HANA studio to the Catalog section and ensure SAP_RDS_BDI_SEMANTIC schema is visible.

3.1.2 Execute the seeding process (SQLScript)

Use

The following process must be executed to ensure that the solution is configured properly and establishes references required to complete deployment:

Procedure

Execute the following SQL in the SQL Console:

CREATE FULLTEXT INDEX "INDEXLOCATION_POST" ON "SAP_RDS_BDI_SEMANTIC"."sap.rds-bdi.semantic.model::tables.SOCIALDATA_POST" ("LOCATIONNAME") CONFIGURATION 'EXTRACTION_CORE' ASYNC LANGUAGE DETECTION ('EN') PHRASE INDEX RATIO 0.200000 FUZZY SEARCH INDEX OFF SEARCH ONLY ON FAST PREPROCESS OFF TEXT MINING OFF TEXT ANALYSIS ON TOKEN SEPARATORS '\/;,.:-_()[]>!?*@+{}="&'

;

CREATE FULLTEXT INDEX "XIDX_SOCIALDATA_5_POST" ON "SAP_RDS_BDI_SEMANTIC"."sap.rds-bdi.semantic.model::tables.SOCIALDATA_POST" ("CREATIONUSERNAME") ASYNC PHRASE INDEX RATIO 0.200000 FUZZY SEARCH INDEX OFF SEARCH ONLY ON FAST PREPROCESS ON TEXT MINING OFF TEXT ANALYSIS OFF TOKEN SEPARATORS '\/;,.:-_()[]>!?*@+{}="&'

;

CREATE FULLTEXT INDEX "INDEXVOICEOFCUST_POST" ON "SAP_RDS_BDI_SEMANTIC"."sap.rds-bdi.semantic.model::tables.SOCIALDATA_POST" ("SOCIALPOSTTEXT") CONFIGURATION 'EXTRACTION_CORE_VOICEOFCUSTOMER' ASYNC FLUSH EVERY 1 MINUTES LANGUAGE DETECTION ('EN',

'FR',

'DE',

'IT',

'PT',

'ZH',

'ES',

'ZF') PHRASE INDEX RATIO 0.000000 FUZZY SEARCH INDEX OFF SEARCH ONLY ON FAST PREPROCESS OFF TEXT MINING OFF TEXT ANALYSIS ON TOKEN SEPARATORS '\/;,.:-_()[]>!?*@+{}="&#$~|';

CREATE FULLTEXT INDEX INDEX_PRODUCT_1 ON "SAP_RDS_BDI_SEMANTIC"."sap.rds-bdi.semantic.model::tables.PRODUCT"("SHORT_TEXT");

CREATE FULLTEXT INDEX INDEX_CAMPTEXT_1 ON "SAP_RDS_BDI_SEMANTIC"."sap.rds-bdi.semantic.model::tables.CAMP_TEXT"("TEXT1");

CREATE FULLTEXT INDEX INDEX_SERVICE_TICKET_1 ON "SAP_RDS_BDI_SEMANTIC"."sap.rds-bdi.semantic.model::tables.SERVICE_TICKET"("DESCRIPTION");

Result

The FULLTEXT index of fields in SOCIALDATA_POST table is created successfully.

3.1.3 Deploy the Semantic Intelligence business layer delivery unit

Use

The semantic intelligence business layer delivery unit deploys the SAP HANA views, procedures, and roles. Perform the following steps to load the semantic intelligence business layer delivery unit for the solution.

The semantic intelligence configuration delivery unit can be imported using either Server or Client as source of delivery unit file location. If an import from the server is required, contact your system administrator for the server path. This step must be executed using the SAP HANA Deployment User that you created.

Procedure

1. Ensure that the semantic intelligence business layer delivery unit (HCO_RDS_BDI_SEM_SE) is downloaded into desired location. If it is not available, contact your system administrator.

2. Choose the Quick Launch window

3. Select the SAP HANA deployment instance (for SYSTEM user)

4. Select Import Option.

5. Choose Delivery Unit

6. Select next.

7. In the Select file section, choose the import location (Server or Client) and specify the location of HCO_RDS_BDI_SEM_SE.tgz

8. Choose Finish to import the content of the delivery unit.

Result

The semantic intelligence business layer delivery unit (HCO_RDS_BDI_SEM_SE) is successfully deployed as indicated by the status in the status window for this job.

Your deployment of semantic intelligence delivery units is now complete. To use the solution, you must create the required administrative and operational users. You also must modify the configuration settings as required for your business needs.

4 Creating Operational and Administrative Users

In this section, you create operational and administrative roles for users of this solution. The functional roles must be created for specific operational purposes. The designated roles are assigned different operational and access permissions that we recommend.

Functional Roles required for operating and administering this solution:

1. Business User for access and operations of the solution.

2. Solution Admin User for full administrative control in managing the solution.

3. Integration Admin User manages SAP HANA content development and deployment.

The SYSTEM user does not have permission to perform all operations for this solution. The following role accounts described must be created for performing specific operations.

Semantic Intelligence is part of a larger domain for SAP HANA Big Data called Semantic Intelligence. Note that the following users that you are creating use SEMANTIC in the naming

The following steps must be performed with the SQL Editor window opened under SYSTEM account. Ensure that the appropriate Client session is set to the following user accounts you create.

4.1 Creating a Solution Admin User

This section must be performed using SYSTEM user account.

Use

The Solution Admin user has permission to manage this solution, and can perform all administrative tasks for this solution within SAP HANA. The following roles are required to perform all administrative tasks for this solution:

· sap.rds-bdi.semantic.roles::RDS_BDI_MFG_SEMANTIC_ADMIN

Procedure

1. Open the SAP HANA studio and logon to your SAP HANA system with SYSTEM user or other user who has sufficient privileges to create new user

2. Expand Security folder

3. Right-click the User node, and choose New User

4. Enter User Name and Password. For example, user name is SEMANTIC_ADMIN

5. Assign following privileges to your administrator user.

Objects / Details
Granted Roles / Public (SYS)
sap.rds-bdi.semantic.roles::RDS_BDI_SEMANTIC_ADMIN
sap.bc.ina.service.v2.userRole::INA_USER

6. Save and activate the user.