Show TOC

 App Implementation: Database Table Growth

System Landscape Requirements

Before you can start to implement the app, ensure that your system landscape has been set up to enable SAP Fiori and that this system landscape already includes the front-end components and back-end components for your app:

SAP Fiori System Landscape Options

Setup of SAP Fiori System Landscape with SAP HANA XS

Configuration of Front-End Server

Configuration of SAP Fiori Infrastructure

Back-End Components (Product Version Stack)

not applicable

SAP HANA Content Component Delivered with (Product Version Stack)

SAP Smart Business 1.0 for SAP Information Lifecycle Management SPS 1

(Technical name: SAP SMART BUSINESS FOR DTG 1.0)

VDM Contained (Product Version Stack)

not applicable

Front-End Components Delivered with (Product Version Stack)

SAP Smart Business 1.0 for SAP Information Lifecycle Management SPS 1

(Technical name: SAP SMART BUSINESS FOR DTG 1.0)

Instance: Frontend Serv. Cont DTG

Software Component Version: Frontend Server Content for Analytic DTG Apps 100

(Technical name: UISDTG01 100)

Tile Type for Launching App

The Database Table Growth analytical app uses an app launcher tile to launch the app.

Required SAP Notes

For the Database Table Growth app, the following SAP Notes must be implemented:

Back-End/Front-End Server

SAP Note Number

Description

Back-End Server

2016072Information published on SAP site

OData entity "Relationship Table / DataAgingObject" for Database Table Growth App

Back-End Server

1917938Information published on SAP site

Migration of statistics Server for Revision 74 or higher

Release Information Note

2063973Information published on SAP site

ILM Fiori Application Database Table Growth

Implementation Tasks

The following sections list tasks that have to be performed to implement the Database Table Growth app. The list contains the app-specific data required for these tasks.

  • You have to switch on the statistics server for SAP HANA. The statistics server provides the information that is needed for the Database Table Growth app.

  • On the statistics server, you have to define thresholds for the resource usage of database tables. They are relevant for providing the alerts displayed in the app.

  • On the statistics server, you have to define the retention time for data. The standard retention time is 42 days. This app can only display information within the retention period.

  • You have implemented the social collaboration platform SAP JAM to use the collaboration function.

    Note Note

    For more information about how to configure SAP JAM, see Social Media Integration in the documentation of SAP NetWeaver at http://help.sap.com.Information published on non-SAP site

    End of the note.

You can find the data required to perform these tasks in the SAP Fiori apps reference library at Start of the navigation path https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/index.html?appId=F0756Information published on SAP site End of the navigation path

HANA Server: Assign SAP HANA Roles to Users and Roles

You can find the data required to perform this step in the SAP Fiori apps reference library at https://www.sap.com/fiori-apps-libraryInformation published on SAP site.

SAP HANA Role

Needed for ...

sap.hba.apps.dtg.roles::DatabaseTableGrowth

Read access to app data (views and XS OData services)

Note Note

The business user should have SELECT privileges for _SYS_BIC schema.

End of the note.
HANA Server: Generate and Assign Analytic Privileges to Users and Roles

You can find the KPI data required to perform this step in the SAP Fiori apps reference library at https://www.sap.com/fiori-apps-libraryInformation published on SAP site.

Needed for

How to generate?

Access to business data (only views)

To be generated by the customer using SAP HANA Live Authorization Assistant.

Note Note

Create and assign analytic privileges to users for granting access to the following query views from the package sap.hba.apps.dtg.s.v:

  • DatabaseTableAlertQuery

  • DatabaseTableQuery

  • StatisticsServiceSettingQuery

End of the note.
Front-End Server: Activate SAP UI5 Application

SAP UI5 Application

Technical Name

Database Table Growth

/sap/bc/ui5_ui5/sap/FND_DTG_MON

For more information about how to activate the SAP UI5 application (ICF service), see Front-End Server: Activate ICF Services of SAP UI5 Application.

Front-End Server: Enable App for Access in SAP Fiori Launchpad

The SAP Fiori launchpad is the entry point to SAP Fiori apps. From a user perspective, it displays those SAP Fiori apps that have been assigned to the catalog designed for this user's role.

This presupposes that an administrator has made the necessary assignments in the launchpad designer to enable a user's access to the respective SAP Fiori apps in the SAP Fiori launchpad. For more information, see Setup of Catalogs, Groups, and Roles in the SAP Fiori Launchpad.

SAP delivers technical catalogs for groups of SAP Fiori apps as repositories to create your own catalogs in the launchpad designer. Along with these catalogs, more technical content is delivered for each SAP Fiori app. You can find the delivered technical content for each SAP Fiori app in the SAP Fiori apps reference library.

Front-End Server and Back-End Server: Assign OData Service Authorizations to Users

You must assign OData service authorizations for the KPI to your users.

Caution Caution

Several authorization default values are connected to the OData service. To ensure that all these default values are assigned to a user, you have to follow the instructions given under the documentation links provided.

End of the caution.

Make the assignment on the back-end server and on the front-end server:

OData Service (Version Number)

Back-end Server: Delivered Authorization Role (PFCG Role)

Front-End Server: AuthorizationRole

/sap/hba/apps/dtg/s/odata/dtg.xsodata/ (1)

sap.hba.apps.dtg.roles::DatabaseTableGrowth

Note Note

In addition, this role contains authorizations to display the related business data.

End of the note.

Use an existing role or create a new one.