on 03-20-2009 6:39 AM
Hi Gurus,
To resolve some LIS Structure problem I need to implement the part of note which is the following
Ensure that the tables SnnnBIW1 and SnnnBIW2 are empty and that the
relevant data is loaded from the delta queue to the BW system. If there
is still data in these tables, you can empty them by requesting a delta
request (-> the content of the first table is deleted), and then
requesting a delta repeat request (the content of the second table is
deleted) during a posting-free period.
Can you please suggest me what the steps to be taken to complete this are
Thank you
Please elaborate on the need to implement the OSS note and the note number so that we can better understand the need and the requirement .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Arun and Rahul,
Actually the issue is while trying to do some object at ECC side there is an option to activate the BW LIS info structures if this option is disabled then no problem but when the option is enabled it is giving error like u201CUpdating terminationu201D
Searched for a note on this and the note number is 115192
We have to implement the part of the note
Can you please let me know the steps
To delete the entries from the table S001BIW1 I need to schedule the Delta info package of the corresponding target in BW to get the deltas from RSA7 (Delta queue)
And again repeat the same info package (Delta repeat request) to empty the second table entries S001BIW2
Please clarify if I am wrong
Thank you
Run a delta load into SAP Bi and this should ideally empty your setup tables . then stop the collection job or take downtime of your ECC system to avoid records being populated into the setup tables.
Now check using SE11 if records exist in your setup tables - if they do then run a delta once again into SAP BI. Then apply the note... open the ECC system for users and you should be good to go...
Thank you Arun,
Can you please explain in detail
First I will Schedule the Delta info package then stop the collection job using LBWE tcode and then check in the SE11 tcode for any table entries if the table still contains data then again run the delta info package to get the deltas to BI.
Is this steps are enough or as you mentioned again I have to apply the note
Awaiting response
Thank You
Your sequence is right...
In the productive system - if you have a V3 update - then the update tables and setup tables get populated with the delta data even after clearing the queue - you will have to take downtime of the ECC system to be able to apply this note else - some data might get populated in the delta queue when you are applying the note and you might have issues applying the note or end up losing some data...
it means that you empty the setup tables by wither emptyng the tables from ECC or by bringing in the data in BI...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
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.