cancel
Showing results for 
Search instead for 
Did you mean: 

0PA_CO1 Extraction procedure

Former Member
0 Kudos

hi all,

iam trying to extract data into 0PA_CO1 cube.i activated data source in rsa5,replicated in BI end,activated transfer structures and loaded data into PSA to all datasources which belongs to 0PA_CO1 cube.i dont what to do next.do i have to DTP data to directly to cube or to the infosource 0HR_PA_1(personal actions),0HR_PA_0(employees).iam very much confused in this issue.

help me what is the next step i have to take.provide me with a step wise document please.

thanx

Vamshi D Krishna

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

...

former_member190390
Participant
0 Kudos

Hi Vamshi,

We are using BI 7.0, Can you please tell me about the following?

1. I have installed indataflow before with routines and all datasources also, whether all the darasources have to migrate and load the data into datasources like 0HR_PA_0 and 0HR_PA_1, 0REGION_TEXT, 0COUNTRY_ATTR etc.

2. In start routine, the code specified above is not accepting at global declaration, it's giving error "E:You cannot use the current statement between "CLASS ... DEFINITION" and "ENDCLASS" ".

Any help?

Thanks,

Venky

former_member190390
Participant
0 Kudos

Hi,

Can you please give code for the start routine in BI 7.0 version?

PROGRAM UPDATE_ROUTINE.

$$ begin of global - insert your declaration only below this line -

DATA: employee_md LIKE /bi0/memployee,

employee_wa LIKE /bi0/memployee,

person_md LIKE /bi0/mperson,

person_wa LIKE /bi0/mperson.

DATA: g_record_no LIKE sy-tabix.

INCLUDE rs_bct_hr_update_rules_general.

INCLUDE rs_bct_hr_papa_update_rules.

$$ end of global - insert your declaration only before this line -

  • The follow definition is new in the BW3.x

TYPES:

BEGIN OF DATA_PACKAGE_STRUCTURE.

INCLUDE STRUCTURE /BIC/CS0HR_PA_0.

TYPES:

RECNO LIKE sy-tabix,

END OF DATA_PACKAGE_STRUCTURE.

DATA:

DATA_PACKAGE TYPE STANDARD TABLE OF DATA_PACKAGE_STRUCTURE

WITH HEADER LINE

WITH NON-UNIQUE DEFAULT KEY INITIAL SIZE 0.

FORM startup

TABLES MONITOR STRUCTURE RSMONITOR "user defined monitoring

MONITOR_RECNO STRUCTURE RSMONITORS " monitoring with record n

DATA_PACKAGE STRUCTURE DATA_PACKAGE

USING RECORD_ALL LIKE SY-TABIX

SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS

CHANGING ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel update

*

$$ begin of routine - insert your code only below this line -

  • fill the internal tables "MONITOR" and/or "MONITOR_RECNO",

  • to make monitor entries

  • if abort is not equal zero, the update process will be canceled

CLEAR G_SOURSYSID.

ABORT = 0.

$$ end of routine - insert your code only before this line -

*

ENDFORM.

Thanks,

Venky

dennis_scoville4
Active Contributor
0 Kudos

I couldn't tell if you have installed and activated the Update Rules for 0HR_PA_0 -> 0PA_C01 and 0HR_PA_1 -> 0PA_C01. If those two objects haven't been installed and activated on BW, that should be done first.

After that, create a DTP for each Update Rule and execute in the following order

0HR_PA_0 -> 0PA_C01

0HR_PA_1 -> 0PA_C01 (execute after successful completion of 0HR_PA_0 -> 0PA_C01)

Former Member
0 Kudos

hi dennis,

thanx for ur answer,it really helped me.now i have loaded data successfully to infocube,now the question is iam unable to see data in info cube fields NUMBER OF ACTIONS,AGE IN YEARS,HEAD COUNT FTE,NUMBER OF EMPLOYEES,CAPACITY UTILISATION LEVEL%,LENGHT OF SERVICE (IN YEARS).please guide me how to do that final step.when iam opening queries in analyser iam unable to see any data except zeors.please help me in this issue.

thanx

Vamshi D Krishna

mr_v
Active Contributor
0 Kudos

info cube fields NUMBER OF ACTIONS,AGE IN YEARS,HEAD COUNT FTE,NUMBER OF EMPLOYEES,CAPACITY UTILISATION LEVEL%,LENGHT OF SERVICE (IN YEARS)

All above fields filled using standard routines and Start Routine as part of standard transfer rules (3.x content).

So, while installing business content u should install all routines, including the start routine.. (if no start routine installed, u won't get any data to cube)

If u r using BI 7.0 concept of transformation & DTP, then u should convert transfer rules into transformation and created DTPs.

Converting transfer rules from the context menu (transfer rules -> additional functions -> Create Transformation) won't help...

U have to manually change the all routines code.

Former Member
0 Kudos

hi V,

thanx for ur answer,but i dont no how and where to write routines.if u can guide me how to do manual coding it would to very helpful.

thanx

Vamshi D Krishna

Former Member
0 Kudos

hi V,

iam still waiting for ur answer.please guide me in this issue.

Former Member
0 Kudos

Hi Vamshi,

U need to include these part in global section of start routine.

INCLUDE rs_bct_hr_update_rules_general.

INCLUDE rs_bct_hr_papa_update_rules.

DATA: ULTIMO TYPE SY-DATUM,

l_record_no TYPE sy-tabix,

l_record_all TYPE sy-tabix,

l_logical_system TYPE rsupdsimulh-logsys VALUE IS INITIAL,

l_rc TYPE sy-subrc.

DATA: employee_md TYPE /bi0/memployee,

employee_wa TYPE /bi0/memployee,

person_md TYPE /bi0/mperson,

person_wa TYPE /bi0/mperson,

TMP_PAYPCT TYPE I.

And in the transformation rules u need to write the routines for each of the key figures.

Map employee and calmonth to the key figures and write these code in the field routine.

Suppose Age in years.

PERFORM CALCULATE_ULTIMO

using SOURCE_FIELDS-calmonth

l_RECORD_NO

l_RECORD_ALL

l_logical_SYSTEM

CHANGING ULTIMO

l_RC.

PERFORM READ_MD_PERSON

using SOURCE_FIELDS-pernr

SOURCE_FIELDS-calmonth

l_RECORD_NO

l_RECORD_ALL

l_logical_SYSTEM

CHANGING EMPLOYEE_WA

PERSON_WA

l_rc.

EMPLOYEE_MD = EMPLOYEE_WA.

PERSON_MD = PERSON_WA.

IF NOT PERSON_MD-DATEBIRTH IS INITIAL.

RESULT = ULTIMO0(4) - PERSON_MD-DATEBIRTH0(4).

IF ULTIMO4(4) LT PERSON_MD-DATEBIRTH4(4).

RESULT = RESULT - 1.

ENDIF.

ENDIF.

Suppose capacity utilisation in %

clear: employee_md, person_md.

clear: employee_wa, person_wa.

perform read_md_employee

using SOURCE_FIELDS-pernr

SOURCE_FIELDS-calmonth

l_RECORD_NO

l_RECORD_ALL

l_logical_SYSTEM

changing employee_wa

l_rc.

employee_md = employee_wa.

RESULT = EMPLOYEE_MD-PAYPCT.

Regards

vamsi

Former Member
0 Kudos

hi vamsi,

thanx for ur code,it is really helpful.one thing i need to ask u that i have to map manually employee and calmonth to all key figures and write code for each key figure ?.iam bit confused with that step.please explain me bit detailed .

thanx

Vamshi D Krishna

mr_v
Active Contributor
0 Kudos

Hi,

U should have installed standard content as it is, along with all the routines and start routine. This will give an idea where all u need to write routines.

Once u r confident that R/3 data matching with BW data, then is the good time to convert to 7.0 concept of transformations & DTPs.

Converting routines (3.x to 7.0) would be tough task, where u should need skilled ABAPer's help