Preventing zero value records from getting exported, on running EXPORT Data Manager Package

[Former Member]

Hi Experts,

We are using BPC standard Data Manger Package, ‘Export Transaction data to Application Server’ to automatically export data from BPC to client application server every hour. We are using ‘SIGNEDDATA’ measure, while exporting BPC data to application server. Throughout the day many other automatic calculations run on the system that post data in BPC. These calculations first clear the data for a particular audittrail, and then repost the newly calculated values. Clearing data values, leads to many duplicated records being posted in BW, so as to accumulate the member intersection value to 0.

Light optimize is run once every day, which aggregates the positive and negative values and eliminates records with 0 value.

The issue is that during the day, when data export is being sent from BPC to application server, these redundant values (+ve and -ve values generated when CLEAR is run) also get transported, increasing the size of the data manyfolds. Is there a way through which we can somehow prevent these unwanted values from getting transported to the application server?

We are currently working on BPC NW 10.0 SP 25.

Thanks a lot, in advance

Regards,

Rupali

[former_member186338 · Accepted solution]

Hi Rupali,

For sure you can perform light optimize with zero elimination before each transfer But it will cost...

Another option is to use default cube measure instead of SIGNEDDATA - instead of +- you will have zero single record.

And you can also create a routine badi to filter the output.

Vadim

[Former Member]

Thanks Vadim and Andy for your prompt responses.

Default cube measure for our cube is Periodic. However, if we export periodic data in place of signed data, the process is really slow as compared to signed data export.

We are thus planning to use routine BADI to accomplish our requirement. However, what we are not sure about is what impact will including a routine BADi in transformation file, have on the performance of EXPORT data manager package.

Request you to please share your inputs on our above stated query.

Thanks,

Rupali

[former_member186338]

For sure routine badi will affect performance. The effect can be the same as periodic measure...

[Former Member]

Hi Rupali,

Performance impact will be minimum, routine will just sum up and remove all the 0 records in the internal table, will be very quick.

Andy

[former_member186338]

Default measure will do the same, but without zero removal...

[Former Member]

Hi Rupali,

my suggestion will be using endroutine in your transformation file to remove all the 0 signeddata in your export table.

Andy