22 September, 2020
SAP Deposits Management Transaction History Analysis with SAP HANA: Configuration Guide
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.
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
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.
In the Navigator view in the SAP HANA Studio, open the Catalog folder.
Select the Authorization folder and right-click.
In the Role Name folder, enter Z_TH_ROLE.
In SQL privileges, make the following entries:
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.
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.
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.
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>.
188.8.131.52. 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.
184.108.40.206. Create a User on the SAP BusinessObjects Server
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.
220.127.116.11. 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:
Procedure Start the process by assigning the SAP HANA user to the SAP Business Objects user in the Central Management Console
<server> is the server for the SAP Business Objects system, and <prot> is the port for the web application server.
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.
|AT_TB_JOIN_ALL_3||Join of CNSP CNLINK and BU T000|
|AN_TB_BCA_ACCTBAL||Latest account balance per contract|
Analytic view Calculation View
|CA_TB_BAL_DETAILS||Balance details for bank account|
|CA_TB_BCA_PAYMITEM||Payment items for bank account|
The following tables are used in the schema SAP_FS_TB as the data source for the views in the package sap.fs.tb.
|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_NT||Payment Notes of a payment item|
|BUT000||BP: General Data ||
|DD02T||SAP DD: SAP Table Texts|
|DD04T||R/3 DD: Data element texts|
|DD07L||R/3 DD: Values for the domains|
|DD07T||DD: Texts for Domain Fixed Values (Language-Dependent)|
|FSPR_PRODUCT_Y||Product, Master Data|
|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.
18.104.22.168. 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
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 HANATM is not included. For more information, see the SAP HANATM Master Guide.
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:
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:
Add an attribute to an analytic view as follows:
Activate the analytic view as follows:
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.
For details about the information design tool, see the Information Design Tool User Guide.
|User Name||<HANA System User Name>|
|Password||<HANA System Password>|
<server>is the server for the SAP Business Objects system, and <port> is the port for the Central Management Server.
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.
|User Name||<HANA System User Name>|
|Password||<HANA System password>|
Check Out Security in SAP HANA