How to delete recros before display in BPC embedded with AFO

[javier_barneogonzlez]

Hi.

I need delete record post selection in BPC embedded with AFO. I have created a Planning function, but I can't find an event (callback) who works that i need.

The user must select some input variables, before show the records in AFO, i must execute a planninf function for delete de "blocked" records. This blocked records must not be modified, so, i delete ir form the initial selection for the user.

I have check callback AfterRedisplay but this event is only executed when the user click on redisplay.

Callback BeforeFirstPromptsDisplay is previous to the data selection.

Is there any event for this?

[gregor_dieckmann]

Hi Javier,

a planning function read data from buffer and writes changes to the buffer, so to run a function before 'display' would have to run even before AO read data using the query; before 'display' is too late.

I also think that is is not a good idea to change before the user does something with the data: how to explain to the user that something was changed and the user really did nothing?

If some data records should not be changed by the user use a data slice.

Regards,

Gregor

[javier_barneogonzlez]

Hi.

I need change the records just in a moment the user execute the filters.

In the old BPS was very easy. I am try to use the refresh evet, but I don't know if I get the solution for my request.

Kind regards.

[gregor_dieckmann]

Hi,

yes, in BPS it is possible the change the result set before it is sent to the client. And it seems that you need something like this; reading the AO documentation there seems to be no API where you can do this.

One idea is to disable the generic filter dialog and to implement your own; you may implement something here that deletes records (observe that you can only delete records in DSO, not in cubes or cube-like aDSOs) or sets some values to zero or some specific value where you can use generic features (e.g. zero suppression or conditions) to filter out some records.

Regards,

Gregor