Order
Backlog"
DM_PROJEC
T_TOTAL
Kxen.Connector;Kxen.
ODBCStore; <HANA
ODBC DSN>
3
ConnectorsTable
1
2015-06-25 10:51:26
"Project
Transaction
Date -
Aggregated
to Project
Level"
DM_TS_PRO
JECT_TOTAL
Kxen.Connector;Kxen.
ODBCStore; <HANA
ODBC DSN>
3
ConnectorsTable
1
2015-06-25 15:27:08
"Project
Transaction
Data -
Selected
Project
Transaction
Data for
Time
Series"
Replace string “<HANA ODBC DSN>” with your HANA ODBC DSN. For example HDB_ODBC and
save
Configure to use local metadata repository
Launch SAP Predictive Analytics.
Open
File
menu.
Choose
Preferences
.
Choose
Metadata Repository
Select
Store the metadata in a single place
and enter as follows:
Data Type: Text Files
Folder: <location where metadata repository files are stored> for example, c:\MDR_PPM.
Select
OK
Project Profitability Analysis
In this use case, we focus on identifying what projects profitable to be picked up and how they can increase or
contribute to the bottom line revenues based on a lot of external and internal factors.
Automated Analytics
Manipulating the Data
Launch SAP Predictive Analytics
Choose the
Data Manager
section
Select
Load an existing Data Manipulation
In the Load existing
Data Manipulation window, select your SAP HANA instance and connect using
the <Domain User> account via the
Browse
button
Ensure that the following data manipulations are available
Name
Comment
DM_PROJECT_TRANSACTION
Project transaction
DM_PROJECT_TRANSACTION_ACTIVE
Active project transaction
DM_PROJECT_TRANSACTION_CLOSED
Closed project transaction
DM_PROJECT_TRANSACTION_CUSTOMERID
Project transaction with customer prompt
DM_PROJECT_TRANSACTION_PROJECTID
Project transaction with project prompt
