Loading Data from R/3 to 3.5 AND 7.0

[Former Member]

Hi,

We have a BW 3.5 that has been extracting Sales data from R/3 for the past few years. We now need to load the same data into a new BI 7.0. I saw that we can load data from one R/3 system to multiple BW systems through note 775568. But the question is, how will we INIT for a new BI system when the data extraction has already been happening for a long time. The other option would be move historical data from 3.5 TO 7.0 But is there any way for loading data from R/3 into the new BI.?

Thanks in advance.

Cheers

AN

[Former Member]

Thanks a lot for your inputs. I am planning to get the history from BW and ongoing delta from R/3.

Cheers

Anand

[Former Member]

HI,

If you have the all teh historical data in BW3.5, it is always better to load the BI7.0 systems from BW3.5.

It is always better not to increase the extraction processes in OLTP systems.

But again, if you do not have all the relevant data in BW, you are left with no other option but to extract from R/3.

Regards,

Anoop P

[Former Member]

>

If you have the all teh historical data in BW3.5, it is always better to load the BI7.0 systems from BW3.5.
>

Can you please explain the process of loading data between different BI systems?

Thanks

Edited by: BI Quest on Aug 5, 2008 10:47 PM

[Former Member]

Hi,

What you have been thinking seems sensible...

Pulling the historic data from the existing BW into BI & then setting up delta in BI through simutlation from R/3... would be the best option available!!!

Otherwise doing Init with data transfer from R/3 would be requiring unnecessary long downtimes of R/3 system again...

Regards,

Habeeb

[Former Member]

Thanks Habeeb. By simulating I suppose you mean, INIT without Data, right?

The other option would be to get all the data from BW 3.5 itself - both history and delta. My only concern is that these are two different versions, and hence might run into some issues.

Cheers

Anand

[Former Member]

Absolutely no issues will be there ... 3.5 and 7.0 are reverse compatible

Cheers!!

Amit

[Former Member]

Hi,

It is possible to have multiple BW/BI systems for one R3/ECC systems. In order for you to load data into both 3.5 and 7.0 systems, you need to difine BI 7.0 logical system in R3/ECC just like your BW 3.5 logical system in R3/ECC. In R3/ECC, the outbound queue (SMQ1) differentiates the deltas based on the logical system name that you have defined (3.5 and 7.0) in R3/ECC system. So, in RSA7 you will see same delta queue name twice but differentiated by logical system name. So you will not have problems loading deltas. Hope this will shed some light.

Regards,

Rao.