SAP Deposists Management Transaction History Analysis with SAP HANA

 

SAP Deposits Management Transaction History Analysis with SAP HANA: Configuration Guide

1. Purpose

The purpose of this document is to describe the general configuration steps required to manually set up the configuration within the system landscape that has already been installed using the corresponding quick guide. The configuration guide provides you with guidance on the contents of the SAP HANA model sap.fs.tb to support you with your decision making process for any modifications you may wish to make to the package. This guide also provides you with guidance on how to make changes to views in the package as well as the reporting objects that use these views.

This configuration guide does not include a full description of how to manually configure the views included in package sap.fs.tb from scratch. You are expected to import these using the process described in the guide for the SAP Deposits Management rapid-deployment solution for transaction history with SAP HANA, which is attached to the SAP Note 1626730. Likewise, you are expected to import the universe and dashboard as described in the quick guide.

The content of this guide is based on SAP HANA ^TM 0.

If you would like to become an SAP Hana Admin certified professional, then visit Tekslate - A Global online training platform:"SAP Hana Admin training and certification course". This course will help you to achieve excellence in this domain.

2. Preparation

2.1. Prerequisites

Before you start the configuration of this scenario, you must install the SAP HANA studio. Furthermore, You must ensure the connection between the following:

SAP HANA ^TM system and SAP Business Objects Dashboards

For more information, see the quick guide for the SAP Deposits Management rapid-deployment solution for transaction history with SAP HANA, attached to the SAP Note 1626730    

3. Configuration

3.1 Configuration for SAP Business Objects Dashboard SAP_FS_TB_SpendAnalysisFin

The following process is required in order to restrict a user’s access to viewing transaction history details for their one account holder’s bank accounts. Due to the scalability of the process described below. SAP recommends that this is used only for trial and evaluation purposes.  

Prerequisites: The dashboard SAP_FS_TB_SpendanalysisFin was imported as described in the chapter import SAP Business Objects Content via Lifecycle Management Console of the Quick Guide.  

3.1.1. Create a Generic Role Z_TH_ROLE for Business partners in SAP HANA Studio

Procedure

In the Navigator view in the SAP HANA Studio, open the Catalog folder.

Select the Authorization folder and right-click.

Choose New

In the Role Name folder, enter Z_TH_ROLE.

In SQL privileges, make the following entries:

SQL object	Privileges
SAP_FS_TB	Select
_SYS_BIC	Select
_SYS_BI	Select
GRNAT_ACTIVATED_ANALYTICAL_PRIVILEGE (_SYS_REPO)	Execute
GRANT_PRIVILEGE_ON_ACTIVATED_CONTENT (_SYS_REPO)

 For each of these SQL objects in the Privileges pane, check that the SELECT or EXECUTE privilege has been set to Yes. No further privileges are required.

Choose Save.

 3.1.2. Create an Analytical Privilege to Limit Data Access per Busines Partner

The analytical privilege restricts access to data within views in the model sap.fs.tb.in this case, the analytical privilege restricts access to an individual business partner, which in this model is the account holder.

This solution means that an analytical privilege is created for each account holder.

    Procedure

• In the Navigator view in the SAP HANA Studio, open the Content folder.
• Open the folder sap.
• Open the folder fs.
• Open the folder tb.
• In the Analytical Privileges folder, right-click and choose New Analytical Privilege….
• Create a new analytical privilege sap.fs.tb/AP_DB_RESTRICTED_<BP>, where <BP> represents the business partner, e.g. 0000004711.
• In Reference Models, select the following information models to apply restrictions from the list of reference models:

Reference Models

AT_TB_JOIN_ALL_3(sap.fs.tb)

AN_TB_BCA_ACTBAL (sap.fs.tb)

CA_TB_BAL_DETAILS (sap.fs.tb)

CA_TB_BCA_PAYMITEM (sap.fs.tb)

•  For each information model, choose to Add to add it to the list of Associated Attribute Restrictions.
• In Associated Attributes Restrictions, make the following entries:

Reference Models	Attributes
AT_TB_JOIN_ALL3 (sap.fs.tb)	PARTNER
AN_TB_BCA_ACCTBAL (sap.fs.tb)	CONTRACT_INT

•  In Associated Attributes Restrictions, mark the model AT­TB­BUT000 (sap.fs.tb)
• To restrict dashboard reporting for the account holder who is assigned to business partner <0000004711>, make the following entry: In Assign Restrictions, add an entry for the business partner

   

Operator	Value
Equal	0000004711

• Check the no entries are made for the other models. In the column Count in Associated Attributes Restrictions the value should be 0 for all model names except for AT_TB_BUT000 ( sap. Fs.tb).
• Choose Save and Activate.

3.1.3. Create Users for Individual Account Hodlers0

To ensure that a user views transaction history details using the SAP Business Objects Dashboard for only one bank account holder, a connection has to be set up between the dashboard and the SAP HANA system, which is restricted to a single business partner.

This approach means a separate user is created in the SAP HANA system and on the SAP Business Objects server for each account holder.

Prerequisites The user that carries out the following steps in the SAP HANA Studio must have administration rights to create roles and further users.  

3.1.3.1. Create a User in the SAP HANA Studio Procedure

Procedure

In the Navigator view in SAP HANA Studio, open the Catalog folder.

Select the Authorization folder, right-click and choose New

 

In User Name, enter the user’s name. The user name for the account holder who is assigned to the business partner <0000004711> could be (FS_TH_BP_0000004711>.

• In Authentication, mark internal.
• Enter the password in the password and Confirm fields.
• Enter the client of the back end system in Session Client.
• Granted Roles, assign the role Z_TH_ROLE to the user.
• Choose Deploy (F8)

 3.1.3.2. Assign the Analytical Privilege to the SAP HANA User

In this step, you assign the newly created analytical privilege to the Sap HANA user associated with the Business Partner.

Procedure

• In the Navigator view in the SAP HANA Studio, open the Catalog folder.
• Select the Authorization folder.
• Select the Users Folder.
• Open User Definition.
• In Analytic privileges, assign the analytic privilege sap.fs.tb/AP_DB_RESTRICTED_<BP>.
• Choose Deploy (F8).

 3.1.3.3. Create a User on the SAP BusinessObjects Server

Procedure

URL	http://<server>:<prot>/BOE/CMC

Access the SAP BusinessObjects Central Management Console through the following Address to the BI Launch-pad:

<server>is the server for the SAP Business Objects system, and <port> is the port for the web application server.

Input your username and password and choose Log on.

Choose the Users and Groups link.

Choose to Create a new user.

Enter the Account Name and Full Name. (Image) For ease of reference, you may find it easier to use the identical name for both the user in the SAP HANA system and on the SAP Business Objects server. However, this is not required and in either case, the connection between the two users is only achieved by creating the mapping as described below.

Enter the password in the Password and Confirm fields.

For Connection Type, choose Concurrent User.

Choose Create and Close.

You must ensure that the mapping between the user in the SAP HANA system and the user on the SAP Business Objects server is correctly made. Otherwise, the dashboard shows data that belongs to another account holder.    

3.1.3.4. Create Mapping between the User in the SAP HANA System and the User on SAP Business Objects Server

In this step, you create the mapping between the user that you have created in the SAP HANA system and the user you have created on the SAP Business Objects server. To accomplish this, you have to do the following:

• Assign the SAP HANA user to the SAP Business Objects user in the Central Management Console
• Enter the authentication credentials for the connection in the information Design Tool

Procedure Start the process by assigning the SAP HANA user to the SAP Business Objects user in the Central Management Console

• Access the SAP Business Objects Central Management Console through the following address to the BI Launch-pad:

URL	https://<server>:<port>/BOE/CMC

<server> is the server for the SAP Business Objects system, and <prot> is the port for the web application server.

• Input your username and password and choose Log on.
• Choose the Users and Groups link.
• Choose the User list.
• Choose the user so that the user is highlighted.
• Choose Manage
• In the Properties dialog box, select Enable Database Credentials.
• Enter the name of the SAP HANA user, for example <FS_TH_BP_0000004711>, in Account Name.
• In Password and Confirm, enter the password that you assigned to this user in the SAP HANA System.
• Ensure that the alias is enabled, that is, the check-box Enabled: for the Alias: is filled.
• Chose Save & Close.
• Continue by entering the authentication credentials for the connection in the Information Design Tool.
• Open the Information Design Tool.
• In the Repository Resources window, choose Insert                 Insert Session.
• In the Open Session dialog box, enter <server>: <port> for the Business Objects server and port in system.
• Enter the user name form the SAP Business Objects server in User Name.
• Enter the password in Password.
• Enter Enterprise in Authentication.
• Choose OK.
• For the created session, open the folder Connection
• Open the connection SAP_FS_TB_Connection.
• Exchange the user name <username>, password <password> and server <host>:<port> with the SAP HANA system user name, password and server and port information.
• The port is defined as 3<HANA_SYSTEM_NUMBER> 15, for example, if the SAP HANA system number is 50, the port number is 35015.
• Enter Use Business Objects credential mapping in Authentication mode.
• This enables the database mapping of the user.
• To test the connection, choose Test Connection.
• Choose Next.
• Choose Finish.
• Choose Save.

Result You have set up a connection that restricts access to the dashboard to the accounts for an individual account holder.  

4. Extension of the Delivered Package sap.fs.tb and Associated Reporting Objects

4.1. Extension of Package sap.fs.tb in the SAP HANA Studio        

4.1.1. Data Model Overview

To make extensions to the delivered package sap.fs.tb, the following list provides an overview of the objects that are included in the package.

Attribute Views

Attribute View	Description
AT_TB_JOIN_ALL_3	Join of CNSP CNLINK and BU T000

Analytic  View	Description
AN_TB_BCA_ACCTBAL	Latest account balance per contract

Analytic view   Calculation View

Calculation View	Description
CA_TB_BAL_DETAILS	Balance details for bank account
CA_TB_BCA_PAYMITEM	Payment items for bank account

4.1.1.1. Table

The following tables are used in the schema SAP_FS_TB as the data source for the views in the package sap.fs.tb.

Tables	Description
BCA_ACCTBAL	Account Balance
BCA_CNSP_ACCT	Assignment Table: account Contract Specialization
BCA_CN_LINK	Assignment Table: Contract Parts to a contract
BCA_CN_PURPOSE	Contract Element: Contract Purpose
BCA_CONTRACT	Assignment Table: Contract Anchor
BCA_PAYMITEM	Payment items
BCA_PAYMITEM_NT	Payment Notes of a payment item
BUT000	BP: General Data |
DD01L	Domains
DD02L	SAP Tables
DD02T	SAP DD: SAP Table Texts
DD03L	Table Fields
DD04L	Data Elements
DD04T	R/3 DD: Data element texts
DD06L	Pool/cluster structures
DD07L	R/3 DD: Values for the domains
DD07T	DD: Texts for Domain Fixed Values (Language-Dependent)
FSPR_PRODUCT_Y	Product, Master Data
SVERS	SAP Release
T000	Clients
TCURN	Quotations
TCURR	Exchange Rates
TCURV	Exchange rate types for currency translation

The following description of extensions to the views is based on the precondition that the field for the data source exists in one of the tables listed above. If the field that you require is included in a table not listed above, for example, the text of a particular attribute, this would entail an extension to the schema SAP_FS_TB, which is outside the scope of this document.

4.1.2. Modeling Overview

4.1.2.1. Modeling Overview for Dashboard

The calculation views CA_TB_BAL_DETAILS and CA_TB_BCA_PAYMITEM are used for reporting by the SAP Business Objects dashboard Spend_AnalysisFin. Fig. 1 shows how back end tables in schema SAP.FS.TB and the views in package sap_fs_tb are modeled to provide data for the dashboard.  

Transaction History Modeling Overview for Dashboard  

4.1.3. Add Additional Attributes to Views in the SAP HANA Package

In necessary, it is possible to add additional attributes to a view. When you do this, you must also take into account the customer-specific namespace. Before you start the modeling, make sure you know the business logic of the attribute you want to add. Since this document is a configuration guide, the general installation and deployment process of SAP HANA^TM  is not included. For more information, see the SAP HANA^TM Master Guide.

Procedure

Start the SAP HANA Studio

Go to the attribute view in which the attribute is located

To add an attribute to an attribute view, proceed as follows:

• • Select the required field from the table.
  • From the context menu, do the following:
  • To set a Field as a key attribute, choose Add as Key Attribute.
  • You have to define at least one key attribute for the output structure.
  • To set a field as an attribute, choose to Add as Attribute.
  • You can define any number of non-key attributes

To define static filter values for a field, choose apply Filter.

In the Apply Filter dialog box, choose the required operator.

Enter the filter value.

To set description mapping, select the attribute from the Output pane.

Navigate to the Properties tab page.

In the Description Mapping property, choose the relevant value.

Activate the attribute view as follows:

• Before a view is available for reporting purposes after adding an additional attribute, you have to deploy and activate the view. The activation of the view translates the metadata defined in the information model to the database object.
• To save the attribute view, choose File Save.
• From the context menu of the attribute views, choose activate.

Add an attribute to an analytic view as follows:

• Select the required field from the table.
• From the context menu, choose to Add as Attribute.
• You have to define at least one key attribute for the output structure.
• You can define any number of non-key attributes.

Activate the analytic view as follows:

• Before a view is available for reporting purposes after adding an additional attribute, you have to deploy and activate the view. The activation of the view translates the metadata defined in the information model to a database object.
• To save the attribute view, choose File Save.
• From the context menu of the attribute view, choose Activate.

Once the views have been activated, the attributes also need to be added to the information space or the universe for reporting transaction history analysis using SAP business Objects Explorer or SAP Business Objects Dashboards respectively

 4.2. Extension of SAP Business Objects Reporting Objects

4.2.1. Adjustment of an SAP Business Objects Universe Use

In this activity, you can modify a universe according to attributes added to the underlying calculation and analytic views in the package sap.fs.tb.

Prerequisites

• SAP_FS_TB_Connection must be connected successfully.
• SAP Business Object Information Design Tool must be installed and accessed via Start All Programs SAP Business Objects BI Platform 4.0, SAP Business Objects BI Platform Client Tools, Information Design Tool

For details about the information design tool, see the Information Design Tool User Guide.  

Procedure

• Open the Information Design Tool.
• In the Repository Resources pane, choose the insert session.
• In the Add Session dialog box, make the following choose OK:

Field name	Description
System	<Server>:<Port>
User Name	<HANA System User Name>
Password	<HANA System Password>
Authentication	Enterprise

<server>is the server for the SAP Business Objects system, and <port> is the port for the Central Management Server.

• In the Repository Resources pane, expand the server and go to Universes àSAP SAP.FS.TBàSAP_FS_TB_BL/Unix.
• Right-Click and select the universe SAP_FS_TB_BL.unx.
• Select Retrieve Universe to retrieve the universe to a local project.
• Expand the retrieval folder in the local project and open the Data Foundation that you want to enhance: SAP_FS_TB_DF.dfx.
• In the Master pane, choose to Detect à Refresh structure, (check Missing Tables) à     Next (Check Missing Columns0       à      Next (Added Columns; in this step, all enhanced attributes are displayed; you can select which attributes to add)     à    Next (Modified Columns)     à    Next (Summary of changes)   -- Finish. Save the Data foundation.
• Open the Business layer (SAP_FS_TB_BL.blx) that is the basis of the Data Foundation to be enhanced
• In the Business layer pane, choose Insert à    Enter the Name and Description of the Dimension.
• In the select area, choose SQL assistant.
• In the dialog box, go to the Table pane area. Expand Model (that is, SAP HANA model; for example sap.fs.tb/CA_TB_BAL_DETAILS and sap.fs.tb/CA_TB_BCA_PAYMITEM). Choose the attribute field that should be enhanced in the model. Choose OK and save the Business Layer.

Right-click the Business Layer 9SAP_FS_TB_BL.blx) that you enhance and choose Publish To a Repository. In the dialog box choose to Check all and choose Check integrity. Choose Next and go to SAP à SAP.FS.TB folder and choose Finish t to overwrite the universe (SAP_FS_TB_BL. Unix).

 4.2.2. Adjustment of an SAP Business Objects Dashboard

Use: In this activity, you can modify the dashboard according to changes made to the universe SAP_FS_TB_BL.unx.  

Prerequisites Dashboard Design must be installed and accessed via Start à All Programs à Dashboard Design à Dashboard Design. For details about how to use the Dashboard Design, see the Dashboard and Presentation Design User’s Guide.  

Procedure

• Open Dashboard Design.
• Choose Fileà Open form Platform à Dashboard Design Object.
• In the Log on to the Business Objects Enterprise dialog box, make the following entries and choose Ok:   

Field Name	Description
System	<Server>:<Port>
User Name	<HANA System User Name>
Password	<HANA System password>
Authentication	Enterprise

• Choose SAPà SAP.FS.TBàSAP_FS_TB_Deposits_Spend Analysis. Xlf and choose Open.
• When you have completed enhancing the dashboard report, choose File à Save to Platform.

Check Out Security in SAP HANA