topic Re: BW: Modify Info-Cube Input-Table in Application Development and Automation Discussions

BW: Modify Info-Cube Input-Table

Former Member — Mon, 13 Jun 2005 12:27:06 GMT

Hi,

First of all, I am not very well involved with BW,

but I have to solve following problem:

PROCESS:

I have to delete some rows of the importing table

under certain circumstances.

I am doing this within the START-Section.

If I run the import in debug-modus <b>it seems</b> to work fine!

RESULT TEST-MODE:

A message appears, which tells me, that the number of

lines has changed. FINE ==> OK to me

A list of imported lines is displayed on the screen.

The deleted lines don't appear! FINE ==> OK to me

PROBLEM:

But when I run the import in production-mode, the deleting

of the lines is ignored.

All lines are imported. The deletion does'nt work!

QUESTIONS:

Is it in general possible the change the number

of Import-lines?

Or Do I something wrong?

Thanks for any help

Michael

Re: BW: Modify Info-Cube Input-Table

Former Member — Mon, 13 Jun 2005 12:52:39 GMT

Hi Michael,

first of all I think you should post your message in the BW forum. But now back to your issue. The ways to restrict the data import to BW in general is to use the selection criteria in the infopackages or to delete data of the datapackages in the user exit for data extraction.

Once the data is in BW you can restrict the data by deleting records of the datapackage in the start routine of the transfer rules and in the second step in the start routine of the update rules. Additionally you can prevent records from being updated into the datatargets if you set the returncode parameter of the routines for each infoobject to a value <> 0.

Hope this helps

regards

Siggi

PS: In your case I think you try to delete records in transfer or update rules. As this normally works fine, please post your code.

Message was edited by: Siegfried Szameitat

Re: BW: Modify Info-Cube Input-Table

Former Member — Mon, 13 Jun 2005 13:12:57 GMT

Many thanks Siggi,

Sorry, of course you are right. BW-forum should be the beeter place