on 02-13-2012 4:47 PM
Hi expert
i use an ancien version of BW (V3.5 i think) and i can get to change the filters in an infopackage.
Can you help me on that,
Thanks a lot
Hi,
You can first do init without data transfer so it will create time stamp..
if you have DSO in between and no question of loosing records in delta..you can do full repair for 3 years..
you can start with parallel loads depending on system performance..if it referes to same table in R/3 there is a possibility to make the load slow due to selflocking the query..if load is within BW you can run them in parallel..
you can start with latest year..
if there is no DSO and chances of loosing some delta you can first load one fiscal year period for latest year and then you can run load for other periods as well..
then you can load previous years..
Once full repair complete..normal delta IP can run..
Thanks and regards
Kiran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Search the Infopackage in RSA1 or the way as suggested by Anindya.
Change the filters in Selection tab of the IP as per your requirement
Selections will be enabled for Full (Full load / Full Repair) and Init loads only.
But keep in mind that, if Init is run with some filters, further deltas will run for these selections only
Regards
Chandu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Reid,
Filters cannot be set for Delta IPs. Possible only for Full / INIT.
Running full repair wont affect delta mechanism.
If the data is huge, full repair in splits would be a better idea as system performance will be affected. I suggest running split by year. If you face issue/failure with years too, run the loads by Quarters
Regards
Chandu
Hi,
You can actually change the delta selections but it should not overlap with existing initialization (basically creating a new IP with new selection).
If you want to change current selection and you can simply delete the existing initialization and do a new INIT. Here if you are already doing a full load then you can go for init without data load or you can go for init with data load as well.
But make sure that you have DSO in between, otherwise directly loading data to infocube might double the records. For infocubes it is better to delete the existing contents and then do the complete init, do the data consideration also.
Regards,
Durgesh.
Hi Reid
Below example should clarify your doubt.
You can change your filters in Init Info-Package. Let' s say you have initialized your Init InfoPackage with only one company code
1001.
So, your Delta InfoPack is bringing delta records related to company code 1001 only.
Now , you added two more company codes 1002 and 1003 in the init selection. Subsequent deltas will bring data for 1001 , 1002 and 1003. So, its the upper maximum of all your delta inits.
But you do not have old data for 1002 and 1003. If you are doing Repair full request then you can get old data of 1002 and 1003.
But things to check here , whether you have all the Key Figure as overwrite here before pulling repair full, else KF values will be doubled. In that case you can do repair full request with selection to avoid duplicate values there.
Regards
Anindya
Hi Reid
Go to RSA1 --->InfoProvider -
>give your Target name -
> Gradually come downwards untill you see InfoPackage.
But my question would be here , are you trying to change filter for Delta InfoPackage? this is not possible
you can change filter only in Full or Init
Check the update tab of your InfoPackage.
Regards
Anindya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.