Issues found while installing Performance management and Talent management reports via BI content

Applies to:

SAP BW 3.5 /Business Intelligence 7.3.

Summary

This document will help readers who are using standard BI content objects for HR projects. It will show the issues faced during implementation of Performance Management, Headcount and Talent Development reports in BI.

Author(s):    Ravi Prakash Rawat

Company:    Infosys Limited

Created on:  20 September 2012

Author Bio

Ravi Rawat works as a Senior System Engineer in Infosys Limited.  He has rich experience of more than 3.2 years and has worked on various BW Implementation/Support Projects in both SAP BW 3.5 and SAP BW 7.0/SAP BW 7.3.

Table of Contents

1. Introduction:………………………………………………………………………………………………………………………………………… 2
2. How to Install objects from BI content………………………………………………………………………………………………………… 3
3. Issues faced while installing PM and TD/SM flow………………………………………………………………………………………….. 6

       Copyright…………………………………………………………………………………………………………………………………………… 19

1.    Introduction:

We had a requirement to implement Performance Management reports and Talent Development Report from BI content (SAP NetWeaver 7.30 BI Content Extensions Add-On 7.35). In this document I would be briefly talking about how to install objects from BI content and will explain the issues faced during the process.

The details of Objects to be installed can be accessed from below link:

http://help.sap.com/saphelp_bic735sp05/helpdata/en/2a/77eb3cad744026e10000000a11405a/frameset.htm

For Performance Management, Headcount and Talent Development reports below needs to be installed in BI.

2. How to install objects from BI content

I will be taking an example of objects used in Performance management report which can be seen under “Objective Setting and Appraisals (PA-PD-PM)”

http://help.sap.com/saphelp_bic735sp05/helpdata/en/90/86e8f5a8eb7645b03b0b7ac107740a/frameset.htm

A. Click on datasources to see the list of data sources

B. The first data source is Appraiser (0HR_PA_HAP_1). Click on Appraiser to get the technical name of the data source

C. We will be activating the data source in ECC system. Go to RSA5

D. Click on SAP and then click on expand button.

E. Click on find and enter the technical name of the data source

F. After getting the data source activate it by clicking on “Activate Datasources”. Similarly, activate all data sources in source system

G. In BI system replicate the data sources from the source system.

H. Now we can install the objects in BI from BI content. Let us take an example of installing DSO –0PAH_DS01, whose details are available in below link:

http://help.sap.com/saphelp_bic735sp05/helpdata/en/90/86e8f5a8eb7645b03b0b7ac107740a/frameset.htm

Click on object types when you don’t get the above screen shot showing all objects grouped separately.

J. On the right pane, “Grouping” make sure to take “Only Necessary Objects”. Else it may happen that some of the objects may get overwritten.

K. On the same pane, “Collection Mode”, Select “Collect automatically”.

L. Go to DSO and double click on “Select Objects”. List of DSO appears in popup screen. Find the DSO 0PAH_DS01 and click on “Transfer Selections“. Then Click on install

Objects shown with green status are already installed. When you drill down further there will be objects which will be automatically selected and are inactive. After clicking on install the objects get activated.

M. Similarly install all the objects present in Objective Setting and Appraisals(PA-PD-PM) given on help.sap.com.

3. Issues faced while installing PM and TD/SM flow

3.1  Hierarchy issue in running BEX query

After running some of the reports (i.e. 0PA_C01_Q016) in BEX Web we get error related to hierarchy.

Solution:

• Check whether the hierarchies are loaded .You can re-load the hierarchies (0ORGUNIT) and activate it again. 
• If above method is not working then Open the above in query designer–>Click on hierarchy –>click on the box shown in below figure

• Popup screen appears–> click OK–>save the query and execute it.
• If still there is an error because of some other hierarchy for which you are not loading it in BI, then follow the above steps b & c.
• The above steps can be used in cases where hierarchy is not displayed in reports (Only values are shown).

3.2 Transfer rule not active

There will be cases where transfer rule may be inactive, no matter how many times they are installed from BI content.

1. Open the transfer rule in edit mode
2. Change transfer method to IDOC
3. Activate
4. Change transfer method to PSA

3.3 Portal -issue: Headcount and Headcount FTE throws template missing error

Error message

Solution

1. Activated the roles given below screen shot

3.4 Update rule does not contain mappings 0PA_DS02

The mappings are not available in the BI content release. Here we need to manually add the mappings.

0TCTADTO

Map it to 0DATETO

0TCTIOBJNM

We need to write a routine for this. Below is the code:

PROGRAM UPDATE_ROUTINE.
*$*$ begin of global – insert your declaration only below this line  *-*
* TABLES: …
* DATA:   …
*$*$ end of global – insert your declaration only before this line   *-*

FORM compute_key_field
TABLES   MONITOR STRUCTURE RSMONITOR “user defined monitoring
USING    COMM_STRUCTURE LIKE /BIC/CS0HR_PA_2
RECORD_NO LIKE SY-TABIX
RECORD_ALL LIKE SY-TABIX
SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS
CHANGING RESULT LIKE /BI0/APA_DS0200-TCTIOBJNM
RETURNCODE LIKE SY-SUBRC
ABORT LIKE SY-SUBRC. “set ABORT <> 0 to cancel update
*
*$*$ begin of routine – insert your code only below this line        *-*
* fill the internal table “MONITOR”, to make monitor entries

* result value of the routine
case COMM_STRUCTURE-HR_OBJTYPE.
when ‘O’. RESULT = ‘0ORGUNIT’.
when ‘C’. RESULT = ‘0JOB’.
when ‘S’. RESULT = ‘0HRPOSITION’.
when ‘P’. RESULT = ‘0EMPLOYEE’.
when ‘Q’. RESULT = ‘0QUALIFICTN’.
when ‘QK’. RESULT = ‘0QUALIGROUP’.
when ‘BA’. RESULT = ‘0APPRAISAL’.
when ‘A’. RESULT = ‘0HRWORKCNTR’.
when ‘BK’. RESULT = ‘0AP_CRIT’.
when ‘BS’. RESULT = ‘0AP_SCHEME’.
when ‘E’. RESULT = ‘0EVENT’.
when ‘D’. RESULT = ‘0EVENTTYPE’.
when ‘L’. RESULT = ‘0EVENTGROUP’.
when ‘F’. RESULT = ‘0EVLOCATION’.
when ‘G’. RESULT = ‘0RESOU’.
when ‘R’. RESULT = ‘0RESTYPE’.
when ‘H’. RESULT = ‘0EXTPERS’.
when ‘U’. RESULT = ‘0EXTORG’.
when others.RETURNCODE = 4.“RESULT = COMM_STRUCTURE-HR_OBJTYPE.
endcase.

* if the returncode is not equal zero, the result will not be updated
RETURNCODE = 0.
* if abort is not equal zero, the update process will be canceled
ABORT = 0.

*$*$ end of routine – insert your code only before this line         *-*
*
ENDFORM.

0TCTLOW

We need to write a routine for this. Below is the code:

PROGRAM UPDATE_ROUTINE.
*$*$ begin of global – insert your declaration only below this line  *-*
* TABLES: …
* DATA:   …
*$*$ end of global – insert your declaration only before this line   *-*

FORM compute_key_field
TABLES   MONITOR STRUCTURE RSMONITOR “user defined monitoring
USING    COMM_STRUCTURE LIKE /BIC/CS0HR_PA_2
RECORD_NO LIKE SY-TABIX
RECORD_ALL LIKE SY-TABIX
SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS
CHANGING RESULT LIKE /BI0/APA_DS0200-TCTLOW
RETURNCODE LIKE SY-SUBRC
ABORT LIKE SY-SUBRC. “set ABORT <> 0 to cancel update
*
*$*$ begin of routine – insert your code only below this line        *-*
* fill the internal table “MONITOR”, to make monitor entries

* result value of the routine
if COMM_STRUCTURE-HR_OTYOBJ is initial.
RESULT = ‘*’. ” authorizations for all objects of this type
else.
RESULT = COMM_STRUCTURE-HR_OTYOBJ.
endif.

* if the returncode is not equal zero, the result will not be updated
RETURNCODE = 0.
* if abort is not equal zero, the update process will be canceled
ABORT = 0.

*$*$ end of routine – insert your code only before this line         *-*
*
ENDFORM.

0TCTOBJVERS

Map this field with constant “A”

0TCTOPTION

Map this field with constant “EQ”

0TCTSIGN

Map this field with constant “I”

0TCTSYSID

We need to write a routine for this. Below is the code:

PROGRAM UPDATE_ROUTINE.
*$*$ begin of global – insert your declaration only below this line  *-*
* TABLES: …
* DATA:   …
*$*$ end of global – insert your declaration only before this line   *-*

FORM compute_key_field
TABLES   MONITOR STRUCTURE RSMONITOR “user defined monitoring
USING    COMM_STRUCTURE LIKE /BIC/CS0HR_PA_2
RECORD_NO LIKE SY-TABIX
RECORD_ALL LIKE SY-TABIX
SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS
CHANGING RESULT LIKE /BI0/APA_DS0200-TCTSYSID
RETURNCODE LIKE SY-SUBRC
ABORT LIKE SY-SUBRC. “set ABORT <> 0 to cancel update
*
*$*$ begin of routine – insert your code only below this line        *-*
* fill the internal table “MONITOR”, to make monitor entries

* result value of the routine
CALL METHOD cl_rso_repository=>get_logical_system_self
RECEIVING
r_logsys = RESULT.
* if the returncode is not equal zero, the result will not be updated
RETURNCODE = 0.
* if abort is not equal zero, the update process will be canceled
ABORT = 0.

*$*$ end of routine – insert your code only before this line         *-*
*
ENDFORM.

0TCTUSERNM

We need to write a routine for this. Below is the code:

PROGRAM UPDATE_ROUTINE.
*$*$ begin of global – insert your declaration only below this line  *-*
* TABLES: …
* DATA:   …
*$*$ end of global – insert your declaration only before this line   *-*

FORM compute_key_field
TABLES   MONITOR STRUCTURE RSMONITOR “user defined monitoring
USING    COMM_STRUCTURE LIKE /BIC/CS0HR_PA_2
RECORD_NO LIKE SY-TABIX
RECORD_ALL LIKE SY-TABIX
SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS
CHANGING RESULT LIKE /BI0/APA_DS0200-TCTUSERNM
RETURNCODE LIKE SY-SUBRC
ABORT LIKE SY-SUBRC. “set ABORT <> 0 to cancel update
*
*$*$ begin of routine – insert your code only below this line        *-*
* fill the internal table “MONITOR”, to make monitor entries

* result value of the routine
RESULT = COMM_STRUCTURE-username.
* store only records of R/3 users who have an BW user as well
select count(*) from usr01 where bname = COMM_STRUCTURE-username.
if sy-subrc = 0.
RETURNCODE = 0.
else.
RETURNCODE = 4.
endif.
* if the returncode is not equal zero, the result will not be updated
RETURNCODE = 0.
* if abort is not equal zero, the update process will be canceled
ABORT = 0.

*$*$ end of routine – insert your code only before this line         *-*
*
ENDFORM.

http://forums.sdn.sap.com/thread.jspa?threadID=1872088

3.5 While activating below mentioned transformations, error message were seen.

List of transformations

1. ODSO 0TMC_DS05 -> CUBE 0TMC_C01
2. ODSO 0TMC_DS11 -> CUBE 0TMC_C01
3. TRCS 0PA_TMC_11 -> ODSO 0TMC_DS11
4. CUBE 0PA_C01 -> CUBE 0TMC_C02

Issue Description

ODSO 0TMC_DS05 -> CUBE 0TMC_C01

Error message appears as Info-object 0ACTION_CNT (Version A) is not compounded. 0ACTION_CNT is a key figure.  Also, there are errors in generation, which might be linked to the same issue.

ODSO 0TMC_DS11 -> CUBE 0TMC_C01

While activation, error message appears as End Routine: Syntax error in routine. If we check the end routine standalone, there is no error message.

TRCS 0PA_TMC_11 -> ODSO 0TMC_DS11

While activation, error message appears as End Routine: Syntax error in routine. If we check the end routine standalone, there is an error message.

CUBE 0PA_C01 -> CUBE 0TMC_C02; CUBE 0TMC_C02 -> CUBE 0TMC_C05

While activation, error message appears as End Routine: Syntax error in routine. If we check the end routine standalone, there is an error message.

Solution

We need to implement below notes in sequence:

3.6 The extraction program does not support object 0JOB_ATTR

This object is obsolete. Please refer to below link for details.

http://scn.sap.com/thread/1557312

Here we need use 0EC_CJOB_ATTR datasource instead of 0JOB_ATTR. Activate it in R-3 system     via RSA5 and replicate it in BI. Create the transformation between 0JOB and datasource.

3.7 Issue in generating PDF in HBU for print option

Ask Basis team to correct it.

3.8 Orgunit hierarchy is showing filter values with attributes instead of showing single values

Solution

3.9 We get error while loading master data

You try following method. In my case it worked:

1. Execute program “RS_TRANSTRU_ACTIVATE_ALL”
2. Enter the source system and infosource (infosource is not compulsory)
3. Replicate metadata by right clicking the data source
4. Change info package selection option to “PSA and subsequent data targets”

Related Content

Please include at least three references to SDN documents or web pages.

http://help.sap.com/saphelp_bic735sp05/helpdata/en/2a/77eb3cad744026e10000000a11405a/frameset.htm

http://forums.sdn.sap.com/thread.jspa?threadID=1872088

http://scn.sap.com/thread/1557312

www.google.com