How to Delete Records From Transaction Cube

[Former Member]

Hi Experts,

I want to delete records from transaction cube after executing my repost function. Currently it deletes by posting 'Negative' value however I want to remove it permanently from Infocube.

I don't want to use selective Delete.

Requirement:

Transaction cube has '#' posting period which I want to convert to '13th' period and after Repost, I want to delete '#' period from database using BPS functionality.

Thanks,

Best Regards,

Santosh.

[Former Member]

Since you don;t want to do a selective deletion..

1. Do the standard delete function..which will create negative records.

2. Create a process chain..

a. Call FM RSAPO_CLOSE_TRANS_REQUEST, which will close any open requests on your plan cube.

b. Then do a cube compression with zero elimination option checked, this will completely remove all the deleted records from the cube, which is what you wanted..

Let me know if you need more information.

• Plan cube can also be compressed as well..no need of switching..atleast that is how I remember.

Edited by: Rajesh A on Jan 10, 2008 5:30 PM

[Former Member]

Delete functions will add negative lines to the fact table and hence the table data will grow.

Selective delete will just delete and no records will be added with negative values.

Ravi Thothadri

[Former Member]

Hello,

The REPOST function creates a copy of the original record with the new values on the char you have reposted. The original record is then "deleted" via the creation of its negative.

==> you had 1 record in the cube and the execution of the function results in 3 records in the cube :

1- Original record

2- Annulation of the original record

3- Reposted record

The DELETE function deletes the original record via the creation of its negative.

==> you had 1 record in the cube and the execution of the function results in 2 records in the cube ;

1- Original record

2- Annulation of the original record

The only way to really remove these records (then the old record and its negative) is to make a compression of the cube with zero elimination. The compression must occur on a cube that is not in planning mode : you will therefore have to switch the cube in a process chain or via a function module which may not be feasible depending your scenario (i.e. just after the reposting).

Remark that BPS itself does not take into account the old record and its negative. In case your issue is in the BW reporting, just set the query to suppress zero rows and/or columns.

rgds,

[Former Member]

hi,

use DELETE function after REPOST function.

create DELETE function, put posting period in "fields to be changed" and in parameter group give posting period as "#".

create a planning sequence , arrange function in a sequence i.e. REPOST and DELETE.