Group Discounts available for 3+ students and Corporate Clients

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 on 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.

 

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:

  1. SAP HANA TM system and SAP Business Objects Dashboards

 

Fore 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

  1. In the Navigator view in the SAP HANA Studio, open the Catalog folder.
  2. Select the Authorization folder and right-click.
  3. Choose New
  4. In the Role Name folder, enter Z_TH_ROLE.
  5. In SQL privileges, make the following entries:

 

SQL objectPrivileges
SAP_FS_TBSelect
_SYS_BICSelect
_SYS_BISelect
GRNAT_ACTIVATED_ANALYTICAL_PRIVILEGE (_SYS_REPO)Execute
GRANT_PRIVILEGE_ON_ACTIVATED_CONTENT (_SYS_REPO)

 

  1. 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.
  2. 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

  1. In the Navigator view in the SAP HANA Studio, open the Content folder.
  2. Open the folder sap.
  3. Open the folder fs.
  4. Open the folder tb.
  5. In the Analytical Privileges folder, right-click and choose New Analytical Privilege….
  6. Create a new analytical privilege sap.fs.tb/AP_DB_RESTRICTED_<BP>, where <BP> represents the business partner, e.g. 0000004711.
  7. 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)

 

  1. For each information model, choose Add to add it to the list of Associated Attribute Restrictions.
  2. In Associated Attributes Restrictions, make the following entires:
Reference ModelsAttributes
AT_TB_JOIN_ALL3 (sap.fs.tb)PARTNER
AN_TB_BCA_ACCTBAL (sap.fs.tb)CONTRACT_INT

 

  1. 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

 

Screenshot_2

 

OperatorValue
Equal0000004711

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).

  1. 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

  1. In the Navigator view in SAPHANA Studio, open the Catalog folder.
  2. Select the Authorization folder, right-click and choose New

Screenshot_2

 

In Use Name, enter the user’s name.

The user name for the account holder who is assigned to business partner
<0000004711> could be (FS_TH_BP_0000004711>.

  1. In Authentication, mark internal.
  2. Enter the password in the password and Confirm fields.
  3. Enter the client of the back end system in Session Client.
  4. In Granted Roles, assign the role Z_TH_ROLE to the user.
  5. 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

  1. In the Navigator view in the SAPHANA Studio, open the Catalog folder.
  2. Select the Authorization folder.
  3. Select the Users Folder.
  4. Open User Definition.
  5. In Analytic privileges, assign the analytic privilege sap.fs.tb/AP_DB_RESTRICTED_<BP>.
  6. Choose Deploy (F8).

 

3.1.3.3          Create a User on the SAP BusinessObjects Server

Procedure

URLhttp://<server>:<prot>/BOE/CMC
  1. 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.

  1. Input your username and password and choose Log on.
  2. Choose the Users and Groups link.
  3. Choose Create new user.
  4. Enter the Account Name and Full Name.
    (Image)
    For ease of reference, you may find it easier to user 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.
  5. Enter the password in the Password and confirm fields.
  6. For Connection Type, choose Concurrent User.
  7. 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.13.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

  1. Access the SAP Business Objects Central Management Console through the following address to the BI Launch-pad:
URLhttp://<server>:<port>/BOE/CMC
  1. <server> is the server for the SAP Business Objects system, and <prot> is the port for the web application server.
  1. Input your username and password and choose Log on.
  2. Choose the Users and Groups link.
  3. Choose User list.
  4. Choose the user so that the user is highlighted.
  5. Choose Manage
  6. In the Properties dialog box, select Enable Database Credentials.
  7. Enter the name of the SAP HANA user, for example <FS_TH_BP_0000004711>, in Account Name.
  8. In Password and Confirm, enter the password that you assigned to this user in the SAP HANA System.
  9. Ensure that he alias is enabled, that is, the check-box Enabled: for the Alias: is filled.
  10. Chose Save & Close.
    1. Continue by entering the authentication credentials for the connection in the Information Design Tool.
  11. Open the Information Design Tool.
  12. In the Repository Resources window, choose Insert                 Insert Session.
  13. In the Open Session dialog box, enter <server>: <port> for the Business Objects server and port in system.
  14. Enter the user name form the SAP Business Objects server in User Name.
  15. Enter the password in Password.
  16. Enter Enterprise in Authentication.
  17. Choose OK.
  18. For the created session, open the folder Connection
  19. Open the connection SAP_FS_TB_Connection.
  20. Exchange the user name <username>, password <password> and server <host>:<port> with the SAP HANA system user name, password and server and port information.
    1. 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.
  21. Enter Use Business Objects credential mapping in Authentication mode.
    1. This enables database mapping of the user.
  22. To test the connection, choose Test Connection.
  23. Choose Next.
  24. Choose Finish.
  25. 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 ViewDescription
AT_TB_JOIN_ALL_3Join of CNSP CNLINK and BU T000
Analytic  ViewDescription
AN_TB_BCA_ACCTBALLatest account balance per contract


Analytic view

 

Calculation View

Calculation ViewDescription
CA_TB_BAL_DETAILSBalance details for bank account
CA_TB_BCA_PAYMITEMPayment 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.

TablesDescription
BCA_ACCTBALAccount Balance
BCA_CNSP_ACCTAssignment Table: account Contract Specialization
BCA_CN_LINKAssignment Table: Contract Parts to a contract
BCA_CN_PURPOSEContract Element: Contract Purpose
BCA_CONTRACTAssignment Table: Contract Anchor
BCA_PAYMITEMPayment items
BCA_PAYMITEM_NTPayment Notes of a payment item
BUT000BP: General Data |
DD01LDomains
DD02LSAP Tables
DD02TSAP DD: SAP Table Texts
DD03LTable Fields
DD04LData Elements
DD04TR/3 DD: Data element texts
DD06LPool/cluster structures
DD07LR/3 DD: Values for the domains
DD07TDD: Texts for Domain Fixed Values (Language-Dependent)
FSPR_PRODUCT_YProduct, Master Data
SVERSSAP Release
T000Clients
TCURNQuotations
TCURRExchange Rates
TCURVExchange 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, 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 name space. 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 HANATM  is not included. For more information, see the SAP HANATM Master Guide.

Procedure

  1. Start the SAP HANA Studio.
  2. Go to the attribute view in which the attribute is located
  3. To add an attribute to an attribute to an attribute view, proceed as follows:
    • Select the required field from the table.
    • From the context menu, do the following:
      1. To set a Field as a key attribute, choose Add as Key Attribute.
        1. You have to define at least one key attribute for the output structure.
      2. To set a field as an attribute, choose Add as Attribute.
        1. You can define any number of non-key attributes
  • To define static filter values for a field, choose apply Filter.
    1. In the Apply Filter dialog box, choose the required operator.
    2. 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.
  1. 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 database object.
    • To save the attribute view, choose File Save.
    • From the context menu of the attribute views, choose activate.
  2. Add an attribute to an analytic view as follows:
    • Select the required field from the table.
    • From the context menu, choose 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.
  3. 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
  4. 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

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

 

Field nameDescription
System<Server>:<Port>
User Name<HANA System User Name>
Password<HANA System Password>
AuthenticationEnterprise

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

  1. In the Repository Resources pane, expand the server and go to Universes àSAP SAP.FS.TBàSAP_FS_TB_BL/unx.
  2. Right-Click and select the universe SAP_FS_TB_BL.unx.
  3. Select Retrieve Universe to retrieve the universe to a local project.
  4. Expand the retrieval folder in the local project and open the Data Foundation that you want to enhance: SAP_FS_TB_DF.dfx.
  5. In the Master pane, choose 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.
  6. Open the Business layer (SAP_FS_TB_BL.blx) that is the basis of the Data Foundation to be enhance
  • 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.
  1. Right-click the Business Layer 9SAP_FS_TB_BL.blx) that you enhance and choose Publish To a Repository. In the dialog box choose Check all and choose Check integrity. Choose Next and go to SAP à SAP.FS.TB folder and choose Finish t overwrite the universe (SAP_FS_TB_BL. Unx).

 

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 use the Dashboard Design, see the Dashboard and Presentation Design User’s Guide.

 

Procedure

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

 

 

Field NameDescription
System<Server>:<Port>
User Name<HANA System User Name>
Password<HANA System password>
AuthenticationEnterprise

 

 

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

 

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on SAP Deposists Management Transaction History Analysis with SAP HANA"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6