Show TOC

 Setting Up Database Tables for the KPI Modeler Locate this document in the navigation structure

 

To look up translation keys, currencies, and UoMs, the KPI Modeler requires the following tables:

Schema

Tables

SAP_SSB

sap.hba.apps.kpi.s.db::T002

sap.hba.apps.kpi.s.db::T006

sap.hba.apps.kpi.s.db::T006A

sap.hba.apps.kpi.s.db::TCURC

To make these tables available in the SAP HANA database, you must make sure that they are included in the data replication process between the ABAP back-end system and the SAP HANA system. You must also populate the tables manually.

Prerequisites

You have set up data replication as described in the Administrator's Guide for SAP HANA Live for SAP Business Suite.

Procedure

  1. Check that the required tables are available in the schema that contains the replicated ABAP database tables in the SAP HANA database (SAP <SID>). If they do not yet exist, create the tables as described in the Administrator's Guide for SAP HANA Live for SAP Business Suite.

  2. To fill the database tables in schema SAP_SSB, log on to SAP HANA studio as a SYSTEM user and execute the following SQL statements:

    Syntax Syntax

    1. call "_SYS_REPO"."GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT" ('INSERT','SAP_SSB','SYSTEM');

    2. call "_SYS_BIC"."sap.hba.apps.kpi.s.logic/INITIALIZE_SAP_SSB" ('SAP<SID>', 'SAP<CLIENT>')
    End of the code.

More Information

For more information about data replication, see chapters 6 and 7 of the Administrator's Guide for SAP HANA Live for SAP Business Suite at   http://help.sap.com/hba   Installation, Security, Configuration, and Operations Information   Administrator’s Guide  .