Thursday, August 30, 2007

log1.ldf transaction log file ms sql

search SDN for clear log file

Monday, August 13, 2007

End Routine

Calculation of result package via end routine
Note: All not overwritten field values within the routine are transferred from the corresponding source fields. This means, all fields not supplied by the transformation source are send with initial values to the transformation target.

The structure of Result_package is same as target structure and can not be changed.
Be careful when a target supplied data with 2 transformations which both supplied only partial fields of the data target, if you use end routine the data will be overwritten with initial value.

Sunday, August 12, 2007

Delete overlap request in bw 7.0

Hi,
Pls create a process chain.
1. Add Delete Overlapping Requests from InfoCube .
2. In the deletion selection check : Conditions:
mark : Only delete request from same DTP
Only delete full DTP request
Only delete full DTP request from Same source
Then Mark : Overalapping.

In the DTP : Add date in the Filter .(Cal/Year Mth) ..You can use variable also.
Without this it won't work.

According to our developer, please note:
It is not supported to use the 'overlapping deletion process' with
DTP-Requests. It will not work and is not nessessary anymore.