How to schedule a load job from bi to r3 daily ? What are the available opt

[former_member182467]

I think we can create a PC for the same so should we code an ABAP routine with include to do the process. So can it be scheduled daily, what are the other option in BI7 other than PC ?

[Former Member · Accepted solution]

Hi Manohar,

You can use process chains and in selection conditions give time and check periodic box and schedule the chain.

it trigggers the chain daily at the same time.

Or there is a new concept from BI 7.0 callede RDA

Real time data acquisition.

this automatically detecs data from source system only R/3 and loads it into BW system immediately.

this is recommended if the aplication is real time and requires immediate availability of data from BW for reporting.

if u need more help on RDA, please let me know.

Regards,

Ranjith Kumar

[former_member182467]

still dont know for cube, pls answer anyone.

[former_member182467]

I want it for a cube....whether v can run a single datarequest in a infopackage group.Please clarify sap gurus.

[Former Member]

Sorry, but your problem description is a bit unspecific.

To export data you can use an Analysis Process, you create an Infospoke or you can create a internal table or a file. You can even create an ABAP program which sends the data to R3 by RFC (that is: create a function in R3 which stores data and which can be called by RFC). There are endless possibilities.

So perhaps you can give some more details on your scenario.

Kind regards,

Jürgen

[former_member182467]

I am really sorry guys it was a typo, its from r3 to bi...I mean I should fetch records from a SD datasource to an ODS daily. So how can i schedule the job daily without process chains, can i schedule it daily not manual schedule daily it should go and fetch the records at night, and I should be able to change it on some days. How to do it ?

[Former Member]

Hi Manohar,

Please use RDA which check for data at a partcular time interval specified and u get the data in the next instant when its entered in R/3.

Please revert back if u need any further help on RDa.

Regards,

Ranjith

[former_member182467]

Hi Ranjith,

Please let me know how to schedule a job frm bi to r3, that is i want to load data from a sd ds to a sd cube in bi. I do not want to use a PC and can i schedule a job daily without a PC, which can run daily after 10pm ,remember its not a manual schedule. Do we have any option to schedule in hourly, weekly, daily from bi to r3. If yes HOW ? i know we can do it thru infopackage group but will the infopackage group accept if its only a single load....I think it should have multiple infopackage rite to add it to a group or can it b a single job as well.

[former_member182467]

Ranjith can u please focus more on RDA, does it meet my above requirement.

[Former Member]

Hi manohar,

Please confirm wer r u laoading the data to.

Is it from R/3 to Bi or BI to R/3?

If its from R/3 to BI7.0 u can schedule it automatically using RDA, but u can load only till a DSO. Rts an realtime application which is used when data is used for tactical reporting. This will be running 24 hrs and will fetch whenever there is a data available in delta queue in R/3.

If u r ok with all the above charecteristics and ur requirements need the following, i am sure i can help you.

Please confirm.

Regards,

Ranjith

[former_member182467]

Hi Ranjith,

Please let me know how to schedule a job frm bi to r3, that is i want to load data from a sd ds to a sd cube in bi. I do not want to use a PC and can i schedule a job daily without a PC, which can run daily after 10pm ,remember its not a manual schedule. Do we have any option to schedule in hourly, weekly, daily from bi to r3. If yes HOW ? i know we can do it thru infopackage group but will the infopackage group accept if its only a single data request....I think it should have multiple data request to add to a infopackage group rite or can it b a single job as well. If yes how do you do it.

[Former Member]

Hi manohar,

RDA can be only used for loading from R/3 to Bw and not from BW to R/3.

so wer r u loading fromr/3 datasource to ODs in bw or please clearly explain wer u wanna load the data.

Assign point for each answer for everybody.

Regards,

Ranjith

Edited by: Ranjith Kumar Murugesan on Oct 16, 2008 7:46 PM

[former_member182467]

Yes i want to load from datasource in r3 to a cube & ods in bi. I want to know how to schedule a job for this daily hourly or weekly, without process chains. can we do this. I will assign after i get my doubts cleared.

[Former Member]

Hi,

RDA can be used to load data very minute,hourly, weekly or at any time interval u need.

but u can load it only till an ODS not to an cube thts a limitation with RDA. this technique is not available for Cubes.

first u have to enable the datasource in R/3 as real time and then u need to create new IP, DTP for realtimein BW side.

please go through the following for understanding RDA technique.

This is a live SAP presentation on RDA go through this.

link:[https://www.sdn.sap.com/irj/sdn/event/webinars?rid=/library/uuid/230d95df-0801-0010-4abb-ace1b3d197fd]

Its PPT version:

link:[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3db14666-0901-0010-99bd-c14a93493e9c]

If it suite ur requirement, please confirm me so that i can help u in implementing it.

hope this helps u

Please acknowledge all possible relevant answers as it goes for a worthy cause

Regards,

Ranjith

[former_member182467]

Hi Ranjith,

Ya this is wat i want, thanks a lot.

first u have to enable the datasource in R/3 as real time and then u need to create new IP, DTP for realtimein BW side.

I have seen ur pp't they are really good, gave me a clear picture of wat to do. But i still have some doubts below..n how to enable a ds in r3 as realtime and to do this we should have the ds in r3 as realtime supportable rite, how to find that whether a ds in r3 is reatime capable ...and wat option do we have in case of a cube, we can do for ods its fine. But what can we do if its a cube , i mean do we have any other alternative...if its a cube. Can we do this through a infopackage group, but infopackage group need more than one data request rite ,what other options do we have if its a cube. I got it for ods.

[Former Member]

Hi Manohar,

To make the data source Real-Time enabled you need to run a small program which updates the REALTIME flag in ROOSOURCE table. Program is as below.

report z_rda_flag.

tables : roosource.

parameters : p_oltpsr like roosource-oltpsource.

update roosource set realtime = 'X'

where oltpsource = p_oltpsr

and objvers = 'A'.

Enter the data source name in the selection screen and run the program.

Now go back to SE16 and see the contents of 0FI_GL_4 inROOSOURCE.

You can see that the program has updated REALTIME flag for the datasource 0FI_GL_4.

hope this answer solves ur issue

u can do this only for an ODs and not for a cube. will let u know if there are any other options for a cube.

assign values to the answers as its the way of thanking in SDN.

regards,

Ranjith

[former_member182467]

I am assinging full values to u, but please do reply back to my question how to do it for a cube and can we do thru infopackage group to a cube. Thanks for ur answer.

[former_member181964]

HI,

You are trying to load the data from BW to R/3...

1.Create Infocpoke, it will create a table, once infospoke executed, you can find the data in that Database table in BW, so from that table you can write code and send that data to ECC.

NOte: in this case you can create PC and insert the program

2. Create report and then use RSBAPI_CRM Tcode and dump the data in application server and then take it to ECC.

Thanks

Reddy