on 08-13-2009 2:04 PM
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
...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.