Skip to Content
0

How to delete recros before display in BPC embedded with AFO

Oct 30, 2017 at 10:50 AM

44

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gregor Dieckmann
Oct 30, 2017 at 03:27 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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.

0

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

0