on 03-31-2009 5:01 AM
Hello, I am little bit confused in using RSA 3 transaction.
1. As i understand - Datasource never stores data actually. It only use to extract the data and saves the data in PSA by running infopackage. - Plz correct me.
2. In LO extraction - Datasource could extract the data either from Set up table or from Delta Queue.
If you want to delete the data the Best practise is to delete the data from setup tables by LBWG and from delta queue by RSA7
3. What is the exact use of RSA3 transaction. Plz explain.
Thanks
Hi,
1. As i understand - Datasource never stores data actually. It only use to extract the data and saves the data in PSA by running infopackage. - Plz correct me.
Yes DataSource is a Structure and it won't store data, it will pick the data from base tables/Delta Queue
2. In LO extraction - Datasource could extract the data either from Set up table or from Delta Queue.
If you want to delete the data the Best practise is to delete the data from setup tables by LBWG and from delta queue by RSA7
First Time you need to fill setup tables and then load Init in BW using setup tables. After that set V3 job an dthen load deltas in BW, it will pick the data from RSA7 (Delta Queue). If you want to delete an dload data again, then delete setup tables, delete Queues in SMQ1/LBWQ and then RSA7.
3. What is the exact use of RSA3 transaction. Plz explain.
This is the place to test your DataSource, whethere the data is extacting correctly or not?.
Thanks
Reddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ashwin,
1. As i understand - Datasource never stores data actually. It only use to extract the data and saves the data in PSA by running infopackage. - Plz correct me.
--> yes, BI side data initially stores at PSA.
2. In LO extraction - Datasource could extract the data either from Set up table or from Delta Queue.
If you want to delete the data the Best practise is to delete the data from setup tables by LBWG and from delta queue by RSA7
--> For FULL loads and Initialization with data transfer data pulled from Setup tables.
--> For Delta Loads data pulled from delta queue.
3. What is the exact use of RSA3 transaction. Plz explain.
--> To check data, for example after enhancing datasource with newfiels we can and debugg thourgh RSA3.
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Reddy,
Ok tell me one thing .
Say , you are using a standard data source.
so my steps would be -
1. Fill the setup table , Assume that it has 200 records . so by running Infopackage it will transfer 200 records in PSA ....
What will be the entries in RSA3 = ? and how to see them.
2. Then assume i run the delta by infopack and it fetch 300 records from delta queue.
Now what will be the chnage in entries in RSA3 for that data source = ? and how to see them.
So now my PSA will have 500 records.
Which information or confermation i can see from RSA3.
Hi,
1. Fill the setup table , Assume that it has 200 records . so by running Infopackage it will transfer 200 records in PSA .... What will be the entries in RSA3 = ? and how to see them.
200 Records.
Eg: If you are using 2lis_11_vahdr datasource then after filling the setup tables you can check the number of records in MC11VA0HDRSETUP table.
If you have any routines in BW then the records may split.
2. Then assume i run the delta by infopack and it fetch 300 records from delta queue.
Now what will be the chnage in entries in RSA3 for that data source = ? and how to see them.
RSA3 will pick data from setup tables. I think if you select mode = delta in RSA3, you may get the delta records, I'm not sure.
So now my PSA will have 500 records.
Which information or confermation i can see from RSA3.
It may be 500.
Thanks
Reddy
Hello, Sorry i could not get your point.
So i run RSA3 in R/3 Side.
i will get four columns -
1. To enter the name of data source. - I entered the data source name.
2. Setting- i left it as it is.
3. Execution mode - Debug mode , Auth trace - I haven't check any one
4. Selection - I haven't enter any selection.
5. I clicked on extraction button ..
-- A new pop up apperar saying - 190 data records selected -
My question - from where and when it select those data records ? from where they came ?
-
Now i get the button for Display List -when i click on it Its shows me --
2 data packets one with 100 records and another with 90 records.
If i click on any data packet it shows me all the records belong to that data packet.
My Question - Why there is data packets in the data source, From where they come.
-
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.