Sitemap

Amicuk Programming Answers

Extracting data into two ODS at same time

2015-10-11   Views:1

Advertisement

Hi experts, I am on BW 3.5, and was wondering if the possible scenario is possible; We are extracting 6.5 million recs from our R/3 system into ODS 1. But the records should split up and either go into ODS 1 or ODS 2 depending on its company code. I

Hi experts,
I am on BW 3.5, and was wondering if the possible scenario is possible;
We are extracting 6.5 million recs from our R/3 system into ODS 1.
But the records should split up and either go into ODS 1 or ODS 2 depending on its company code.
I know this can be done by creating two datasources and using two different Modules we could decide what goes and what doesn't, but this would require two extractions, one per module.
I want to know if there is a way this can be done with one extraction,
e.g. the extraction would be to ODS 1, and in the update rules start routine is it possible to decide if the record belongs in ODS 1 or ODS 2,
if it is ODS 2 can we write from this update rule to another ODS????
Thanks,
Shane.

The replay answer
Advertisement
Hiya Santhosh,
currently I have created two update rules one to each ODS. The problem is the load to ODS 1 is 6.5 million + recs, while the load to ODS 2 is 20,000 recs.
The extraction from R/3 takes about 4 + hours, so I would have to perform the extraction twice to populate them both, which is a waste of time for the 20,000 recs.
Is it possible to get all the recs in in one extract and then dictate what ODS it populates without creating a third ODS to initially populate????
Thanks,
Shane.

Go to See the other 5 answers

Extracting data into two ODS at same time

Category:DefaultRelease time:2015-10-11Views:130

Hi experts, I am on BW 3.5, and was wondering if the possible scenario is possible; We are extracting 6.5 million recs from our R/3 system into ODS 1. But the records should split up and either go into ODS 1 or ODS 2 depending on its company code. I[More]

Error while extracting data from ODS using Infospokes - URGENT

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I am extracting data from an ODS using infospokes and nothing fancy, no selection criteria but I am getting an error message saying Syntax error in row3(-> long text) Msg id = "RG" and msgno is 102 Any ideas on how I can see what is t[More]

Can not extract data into BW from SQL SERVER

Category:DefaultRelease time:2015-10-11Views:130

Dear All,   I meet a problem to extract data from database(MS SQL Server 2000(sp3)) into BW now and can not extract data into BW ODS, even PSA, In the monitor, display yellow light(0 from 0 record), detail message just display message "data request a[More]

How to extract data from ODS to non-SAP system

Category:DefaultRelease time:2015-10-11Views:130

Hi, Can anybody tell me, step by step, how to extract data from ODS to a non-SAP system? Is it possible to do it without programming effort? And is there volume limits for this kind of extraction? The non-SAP system is an unix system. Thanks in advan[More]

Error While Extracting Data in ODS

Category:DefaultRelease time:2015-10-11Views:130

can anyone help me out i have created an ODS ZMM_OD81 but i got the following error messaged while extracting the data, pl. help me asap. 1. SIDs determined successfully for request REQU_3YGDERK275SLEUNKLGWOR30GZ from ODS object ZMM_OD81 2. Request R[More]

Unable to extract data from R/3 into BW 3.5

Category:DefaultRelease time:2015-10-11Views:130

I have just started learning BW. I am currently trying to upload data from R/3 into BW. I have tried uploading data into InfoCube , ODS, InfoObjects from R/3 and in all cases I am getting error messages. Please shed some light as the what am doing wr[More]

Extracting data directly from a datasource to a flat file

Category:DefaultRelease time:2015-10-11Views:130

My requirements are to extract data from a SAP standard profit center accounting data extractor 0EC_PCA_1 directly to a flat file. Can this be done in a standard way or is custom ABAP development required ? I have tried the RSA3 based extractor, but[More]

How to Extract  data from a transaction..

Category:DefaultRelease time:2015-10-11Views:130

Hi All There are some transactions and report programs which are used daily to produce some results and the requirement is to extract that data into BW so how can we extract information from a transactions and programs Any help will be really appreci[More]

Error while loading data in data storage object(ODS)

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am extracting data from data base with help of DB connect.I can see number of records are added into ODS.but when I try to activate data in ODS, its going to red.When I see error message as followes.Its is saying invalid char,when i see data in[More]

In Which R/3 Table, the Extraction Date should be RESET to Limit DELTA ???

Category:DefaultRelease time:2015-10-11Views:130

Hi all,   We have a daily delta extraction setup for DataSource 0FI_GL_4 from R/3 into ODS. I think there is a table on R/3 side where we could RESET the extraction date (?) to limit the delta reload incase something goes wrong with delta process. Wi[More]

Hot
How do I add page numbers to a document in Pages on the iPhone?When I tap the spanner I don't see Document set up. I see this:Read other 5 answers [More]
Why don't For-Loops have a premature exit capability --- i.e. why didn't NI include the exit capability that exists in other languages? Is it a dataflow thing? I don't see how. Just curious.Jay, I have to say I`m no programming Guru, but isn`t a Stat [More]
Hi All,   I was using the FF 3.0.10 came with ArchLinux pacman. Recenty I downloaded the latest FF from mozilla website and put that in /opt/firefox. I am able to do all other things in it except watching the full screen flash video from Youtube. The [More]
Ok, I'm not sure if these two issues are related but here goes. I am a training developer, and a lot of what I do is editing screen captures. I have Production Premium that I use to edit my screen captures. The screen captures I get using the free Mi [More]
My MBP (running 10.6.8) just his 3 yrs this month (so of course just out of applecare) and a couple days ago the laptop froze while I was using it and would beep 3 times continually. I was able to do a hard reboot and get back to my desktop but after [More]
I have searched this subject and found one thread that touches on the topic. It says that I should be able to "connect" five Apple TVs to my single iTunes library. I have on original Apple TV that connects to my iTunes library just fine. I just [More]
i have some some main problems with this phone . the browser is not good . i want opera or uc browser in store . i not able to copy or paste any text msgs ,this is a problem. i have seen that when i try to update my phone , it showing error . i seen [More]
Hi, I'm writing a a parameterised cursor and I need to decode the value of the parameter to a list of values but I'm not able to find and elegant solution. The line I currently have in the WHERE clause are: AND (bes_ps_s_id = DECODE (UPPER(p_act_or_r [More]
hi all, I implemented a code (using the Labview example) to save and read cluster data (see attached file). The write part works properly but when I want to read the file, there is an error : "Error 4 occurred at Read from Binary File in main_save_da [More]
this other day liek a week ago i plug in my ipod video 30GB with software 1.1.2 and iTunes recognises it as a Silver iPod mini.. so then when it finishes updating as an iPod mini i have no more videos/photos/song photos/etc. but when i re-plug it its [More]