June 2015
EnglishEnglish
Configuration for Transformer Load Analytics
(EZ8)
SAP SE
Dietmar-Hopp-Allee 16
69190 Walldorf
Germany / Building Block Configuration Guide
© SAP SE Page 4 of 4
SAP Best Practices Transformer Load Analytics Configuration (EZ8): Configuration Guide
Copyright
© 2015 SAP SE or an SAP affiliate company. All rights reserved.
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 / Description0 / June 6,2015 / Initial
Icons
/ Caution
/ Example
/ Note
/ Recommendation
/ Syntax
Typographic Conventions
Type Style / DescriptionExample 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
Configuration for Transformer Load Analytics 6
1 Purpose 6
2 Preparation 6
2.1 Prerequisites 6
2.2 Assumptions 6
3 Deploying Business Delivery Units 8
3.1 Configuring Transformer Load Analytics 8
3.1.1 Deploy the foundation delivery unit 8
3.1.2 Execute the AFL seeding procedure 9
3.1.3 Deploy the business layer delivery unit 9
4 Configuring SAP HANA 11
4.1 Assign SAP HANA roles for Transformer Load Analytics 11
4.1.1 Assign role with Viewer rights 11
4.1.2 Assign role with Admin rights 12
4.2 Configuring Transformer Load Analytics 12
4.2.1 Application Configuration Settings 12
4.2.2 Set Transformer Characteristics for Loss of Life Calculation 14
5 Loading Data 15
5.1 Sample Data 15
5.1.1 Load Sample Data 15
5.1.2 Unload sample data 15
5.2 Load your own data 16
5.2.1 Load Transformer Master Data 16
5.2.2 Load Transformer Load Data 17
5.2.3 Load Weather Station Master Data 17
5.2.4 Load Weather Data 17
5.3 Generate Weather Data 18
6 Additional Resources 20
6.1.1 SAP HANA Guides 20
6.1.2 Important SAP HANA Security Notes 20
© SAP SE Public Page 20 of 20
SAP Best Practices Transformer Load Analytics Configuration (EZ8): Configuration Guide
Configuration for Transformer Load Analytics
1 Purpose
The purpose of this document is to describe the general configuration steps required to manually set up the transformer load analytics scope item configuration 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 Configuration Guide: Getting Started attached to that note.
The SAP Note is available on the SAP Service Marketplace for rapid-deployment solutions, http://service.sap.com/rds-bdi → SAP HANA Big Data Intelligence rapid-deployment solution → Find Out More → Latest Information
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. SAP HANA Predictive Analytics Library (PAL) functions are installed.
To confirm that the PAL functions were installed successfully, you can check the following three public views:
•sys.afl_areas
•sys.afl_packages
•sys.afl_functions
These views are granted to the PUBLIC role and can be accessed by anyone.
To check the views, run the SQL statements:
SELECT * FROM "SYS"."AFL_AREAS" WHERE AREA_NAME = 'AFLPAL';
SELECT * FROM "SYS"."AFL_PACKAGES" WHERE AREA_NAME = 'AFLPAL';
SELECT * FROM "SYS"."AFL_FUNCTIONS" WHERE AREA_NAME = 'AFLPAL';
The result alerts you to whether the PAL functions were successfully installed on your system
In addition, ensure that the following permissions are in place:
_SYS_REPO user has been assigned EXECUTE rights for the following procedures:
· "SYSTEM"."AFL_WRAPPER_GENERATOR"
· "SYSTEM"."AFL_WRAPPER_ERASER"
If those rights have not been applied, then modify _SYS_REPO user to grant those rights.
For more information about SAP HANA Predictive Analysis Library (PAL) functions, see the SAP Help Portal http://help.sap.com/hana_platform → Reference Information → SAP HANA Library References → SAP HANA Predictive Analysis Library
3 Deploying Business Delivery Units
Setting up SAP HANA technical components for the solution require the following high-level processes:
1. Configure SAP HANA Big Data Intelligence
2. Configure Transformer Load Analytics
3. Define user accounts
4. Loading data to solution space.
The following subsections describe detail steps required and performed using SAP HANA studio.
3.1 Configuring Transformer Load Analytics
To implement the transformer load analytics scope item of SAP HANA Big Data Intelligence, you perform the following steps.
1. Deploy the foundation delivery unit
2. Execute the seeding procedure
3. Deploy the business layer delivery unit
3.1.1 Deploy the foundation delivery unit
The following steps are used to load the transformer load analytics foundation delivery unit.
The transformer load analytics 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 SYSTEM account.
1. Ensure the transformer load analytics foundation delivery unit (HCO_RDS_BDI_UTL_TA_FND) is downloaded into desired location. If it is not available, contact your system administrator.
Instructions for acquiring the configuration delivery unit are provided in the Configuration Guide: Getting Started, attached to SAP Note 1956985.
2. Choose the Quick Launch window and select the SAP HANA deployment instance (SYSTEM) and select Import Option.
3. Choose Delivery Unit and select Next.
4. In the Select file section, choose the import location (Server or Client) and specify the location of HCO_RDS_BDI_UTL_TA_FND.tgz
5. Choose Finish to import the content of the delivery unit.
Result
The HCO_RDS_BDI_UTL_TA_FND should have been successfully deployed. The Job Log shows the status of the package as it loads. If the load is successful, then the status displays Completed successfully. If the deployment fails, then Error appears. Navigate in the SAP HANA studio to the Catalog section of the system where the delivery unit is imported.
3.1.2 Execute the AFL seeding procedure
After deploying the transformer load analytics foundation delivery unit, you must run the AFL seeding procedure to prepare for deploying the business layer delivery unit.
Procedure
1. Grant the required privileges to execute the seeding procedure
CALL "_SYS_REPO"."GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT"('EXECUTE', 'SAP_RDS_BDI_UTL_TRANSFORMER','SYSTEM');
CALL "_SYS_REPO"."GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT"('SELECT','SAP_RDS_BDI_UTL_TRANSFORMER','SYSTEM');
2. Execute the seeding procedure.
CALL "SAP_RDS_BDI_UTL_TRANSFORMER"."sap.rds-bdi.utl.transformer.prep::GENERATE_FORECASTSMOOTH_PROC" ();
Result
The TRANSFORMER_FSMOOTH_PROC procedure is created and is available in the _SYS_AFL. Verify that this procedure appears in the catalog.
3.1.3 Deploy the business layer delivery unit
The transformer load analytics business layer delivery unit deploys the SAP HANA views, procedures, and roles. Perform the following steps to load the transformer load analytics business layer delivery unit for the solution.
The transformer load analytics business layer 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 SYSTEM account.
1. Ensure that the transformer load analytics business layer delivery unit (HCO_RDS_BDI_UTL_TA) is downloaded into desired location. If it is not available, contact your system administrator.
Instructions for acquiring the configuration delivery unit are provided in the Quick Guide, attached to SAP Note 1956985.
2. Choose the Quick Launch window and select the SAP HANA deployment instance (for SYSTEM user) and select Import Option.
3. Choose Delivery Unit and select next.
4. In the Select file section, choose the import location (Server or Client) and specify the location of HCO_RDS_BDI_UTL_TA.tgz
5. Choose Finish to import the content of the delivery unit.
Result
The transformer load analytics business layer delivery unit (HCO_RDS_BDI_UTL_TA) successfully deploys. The Job Log shows the status of the package as it loads. If the load is successful, then the status displays Completed successfully. If the deployment fails, then Error appears. Navigate in the SAP HANA studio to the Catalog section of the system where the delivery unit is imported. Ensure that the required views, procedures, and roles are available.
This completes your deployment of transformer load analytics delivery units. 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 Configuring SAP HANA
The following section describes the SAP HANA configuration settings for transformer load analytics.
4.1 Assign SAP HANA roles for Transformer Load Analytics
Assign SAP HANA viewer and administrator roles with granted privileges for Transformer Load Analytics. For more information, see the SAP HANA Administration Guide section User Provisioning.
To access the latest version of the SAP HANA Administration Guide, see the SAP Help Portal http://help.sap.com/hana_appliance → System Administration and Maintenance Information.
4.1.1 Assign role with Viewer rights
This section must be performed using SYSTEM user account.
The solution user has permission to view this solution within SAP HANA. The following roles are required to perform business operations for this solution:
· sap.rds-bdi.utl.transformer.access::transformerViewer
Procedure
To configure a user to be able to perform all business operations related to this solution, follow these steps.
Replace {TRANSFORMER_VIEWER} and {Password} with your values.
CREATE USER {TRANSFORMER_VIEWER} PASSWORD {Password};
CALL "_SYS_REPO"."GRANT_ACTIVATED_ROLE"
('sap.rds-bdi.utl.transformer.access::transformerViewer','{TRANSFORMER_VIEWER}');
The output window of the SQL Editor notifies when the command is successfully run.
The initial password established for this data scientist user has a change password requirement at first logon.
Verify the creation by opening a SQL Window using your transformer admin account created previously.
· SAP_RDS_BDI_UTL_TRANSFORMER schema is visible in the catalog area of the transformer solution user name
Result
The Viewer role is assigned to the specified user.
The user granted with this role is allowed to logon into the transformer load analytics to view the data and conduct analyses.
4.1.2 Assign role with Admin rights
This section must be performed using SYSTEM user account.
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.utl.transformer.access::transformerAdmin
Procedure
To configure a user to be able to perform all administrative tasks related to this solution, follow these steps.
Replace {TRANSFORMER_ADMIN} and {Password} with your values.
CREATE USER {TRANSFORMER_ADMIN} PASSWORD {Password};
CALL "_SYS_REPO"."GRANT_ACTIVATED_ROLE"
('sap.rds-bdi.utl.transformer.access::transformerAdmin','{TRANSFORMER_ADMIN}');
The output window of the SQL Editor notifies when the command is successfully run.
The initial password established for this data scientist user has a change password requirement at first logon.
Verify the creation by opening a SQL Window using your transformer admin account created previously.
· SAP_RDS_BDI_UTL_TRANSFORMER schema is visible in the catalog area of the transformer admin user name
Result
The Admin role is assigned to the specified user.
4.2 Configuring Transformer Load Analytics
The application includes configurable tables, which can be modified to customize the solution based on your specific business requirements. The following tables include listings of all configurable settings. Modifying the default values is described in the sections.