1981340 - Activate SAP HANA content for DDF and UDF

Symptom

• You are following a "Progressive Implementation" scenario for your SAP Customer Activity Repository solution:
• You want to first focus on forecast-related functionalities (phase 1 of this scenario).
• You therefore want to implement only the Demand Data Foundation (DDF) and Unified Demand Forecast (UDF) modules.
• You have successfully installed DDF and UDF and would now like to activate the provided SAP HANA content (SAP HANA views and SQLScript procedures) for only these modules.

or

• You are getting a SQL exception indicating that you are attempting to access inactive or invalid SAP HANA content in your SAP Customer Activity Repository solution.

Other Terms

DDF, UDF, activate, inactive, SAP HANA views, VDM, virtual data model, SAP HANA content, stored procedures, packages, delivery unit, SQLScript procedures, DU, standalone, progressive implementation scenario

Reason and Prerequisites

Caution:

• This note is exclusively applicable to implementation scenarios where only the SAP HANA content for DDF and UDF needs to be activated.
• If your scenario includes additional modules of SAP Customer Activity Repository (for example, POS Data Transfer and Audit or Multichannel Transaction Data Management), do not implement this note. Instead, follow the instructions in the Post-Installation section of the Installation Guide, SAP Customer Activity Repository. You can find this guide on SAP Help Portal at http://help.sap.com/car -> <your release> -> Installation and Upgrade Information -> Installation Guide.

Implementation Scenarios:
For more information on the supported scenarios, see the Preparation, Installation, and Post-Installation section of the Administrator's Guide for DDF and UDF. Depending on your SAP Customer Activity Repository release, you can find this guide at the following locations on SAP Service Marketplace:

• http://service.sap.com/instguides -> Industry Solutions -> Industry Solution Guides -> SAP for Retail -> SAP Customer Activity Repository -> SAP Customer Activity Repository 1.0 SP04 -> Administrator's Guide, Demand Data Foundation (DDF) 1.0 SP04
• http://service.sap.com/instguides -> Industry Solutions -> Industry Solution Guides -> SAP for Retail -> SAP Customer Activity Repository -> SAP Customer Activity Repository 1.0 SP05 -> Administrator's Guide, DDF 1.0 SP 05 with UDF on SAP HANA
• http://service.sap.com/instguides -> Industry Solutions -> Industry Solution Guides -> SAP for Retail -> SAP Customer Activity Repository -> SAP Customer Activity Repository 1.0 SP06 -> Administrator's Guide, DDF with UDF on SAP HANA
• http://service.sap.com/instguides -> Industry Solutions -> Industry Solution Guides -> SAP for Retail -> SAP Customer Activity Repository -> SAP Customer Activity Repository 2.0 <and higher> -> Administrator's Guide, DDF with UDF on SAP HANA

Prerequisites:
You must have successfully completed all the prior steps as listed in the Administrator's Guide for your release.

Solution

This note provides you with a report for activating the SAP HANA content for DDF and UDF. To make this report available on your system, implement the associated correction instructions and manual activities.
Prior to executing this report, follow these steps:

• Ensure that the SAP HANA database user _SYS_REPO has the required authorizations.
  For the successful activation of the SAP HANA content, the user _SYS_REPO requires object privilege SELECT, with option "Grantable to others", on the physical database schema containing your RTLDDF database tables. This schema is typically called SAP<SID>.
  You can use the following example SQL statement to grant the required privilege:
  GRANT SELECT ON SCHEMA <replace with your schema name here> TO _SYS_REPO WITH GRANT OPTION;
• Assign the required privileges as described in the Authorization Requirements for Unified Demand Forecast (UDF) section of the Administrator's Guide for your release.
• Ensure that the ABAP user executing the activation report has the S_DEVELOP authorization for activity type 07 (Generate / Activate) for object type NHDU. For details on the authorization check, see method is_authorized of class /DMF/CL_HCO_ACTIVATOR_NEW.

To execute this report, follow these steps:

1. Execute transaction SE38.
2. Execute program /DMF/DDF_HCO_ACTIVATION_NEW.
3. Verify that the output results contain no errors.

Note:

• You should execute this report at least once on all systems where the SAP HANA content for DDF and UDF needs to be activated.
• If you are applying a support package on an existing installation, ensure that you activate the SAP HANA content again.

------------------------------------------------------------------------
|Manual Activity                                                       |
------------------------------------------------------------------------
|VALID FOR                                                             |
|Software Component   RTLDDF                                           |
| Release 100          SAPK-10001INRTLDDF - SAPK-10002INRTLDDF         |
------------------------------------------------------------------------

• Go to transaction SE91 and create the following messages in message class /DMF/MSG_IN_MEMORY

                    006 Content will be activated only for DDF and UDF; see long text
                    007 Dummy view creation failed; contact SAP
                    008 Dummy view created
                    009 First install the Application Function Library (AFL) for UDF
                    010 Application Function Library (AFL) is installed
                    011 Schema mapping failed; contact SAP
                    012 You are not authorized to access the "SYS" schema
                    013 Views already available; contact SAP
                    014 Delivery unit /CAR/HCO_RTLCAR available; contact SAP
                    015 Use report /CAR/ACTIVATE_HANA_CONTENT to activate HANA content
                    016 Missing authorization to activate HANA content
                    017 Report can only be executed in a Development System
                    018 Activation is not possible; system is not on in-memory database
                    019 Schema Mapping creation failed.

• Go to transaction SE11 and select the radio button Data Type, enter /DMF/HCO_ACTIVATION_LOGLINE, press create and create the data element in package
  /DMF/DDF_IN_MEMORY_DB_FACADE,
  Short Description: Log File of Content Activation
  Data Type: Elementary Type  with Domain CHAR255,
  Field Label:
  Short: Length 10 Field Label Log
  Medium: Length 20 Field Label Log File
  Long: Length 30 Field Label Log File (Row)
  Heading: Length 14 Field Label Log File (Row)

• Go to transaction SE11 and select the radio button Data Type, enter /DMF/HCO_ACTIVATION_TS, press create and create the data element in package
  /DMF/DDF_IN_MEMORY_DB_FACADE,
  Short Description: Time Stamp as String for Log Files for Content Activation
  Data Type: Elementary Type  with Domain CHAR30,
  Field Label:
  Short: Length 10 Field Label Time Stamp
  Medium: Length 20 Field Label Time Stamp
  Long: Length 20 Field Label Time Stamp
  Heading: Length 30 Field Label Time Stamp

• Go to transaction SE11 and select the radio button Data Type, enter /DMF/HCO_ACTIVATION_LOG, press create and create the structure in package
  /DMF/DDF_IN_MEMORY_DB_FACADE,
  Short Description: HANA Content Activation Log
  Components:
  TIMESTAMP Types /DMF/HCO_ACTIVATION_TS
  LOG Types /DMF/HCO_ACTIVATION_LOGLINE

• Go to transaction SE11 and select the radio button Data Type, enter /DMF/HCO_DUMMY_VIEW_STY, press create and create the structure in package
  /DMF/DDF_IN_MEMORY_DB_FACADE,
  Short Description: Dummy View Structure - no reuse!
  Components:
  MANDT Component Type MANDT
  Click "Predefined Type"
  ORDERCHANNEL Data Type CHAR Length 2
  SALESORGANIZATION Data Type CHAR Length 4
  DISTRIBUTIONCHANNEL Data Type CHAR Length 2
  LOCATION Data Type CHAR Length 10
  PLANT Data Type CHAR Length 4
  Click "Component Type"
  REPORTINGDATE Component Type DATS
  REPORTINGDATE_E Component Type DATS
  Click "Predefined Type"
  ARTICLE Data Type CHAR Length 18
  OFFER Data Type CHAR Length 36
  PROMOTION Data Type CHAR Length 10
  GROSSSALESAMOUNT_E Data Type DEC Length 26 Decimal 6
  Save changes

                   

Header Data

Released On	23.12.2015 21:19:44
Release Status	Released for Customer
Component	CA-DDF-RT-UDF Unified Demand Forecast
Other Components	CA-DDF-RT Demand Data Foundation for Retail
Priority	Correction with medium priority
Category	Program error