refresh report after Insert member

[Former Member]

Hi ,

        We like to refresh the report after inserting the row using insert member option in EPM.

          Please suggest here  how to do this with VBA code.

Thanks in advance

[former_member186338]

It's controlled by:

20 User Options

Refresh only Expanded and Inserted Members

Read my answer here

Vadim

[former_member186338]

P.S. And there are no special event that can be used to trigger vba code after insert member.

[Former Member]

Hi Vadim Kalinin,

                               Thanks for the reply, we like to only refresh the report and not to expand the report.do we have any option to only refresh the report , when ever we insert the  new row to the report using the "insert member" option from the EPM menu.

[former_member186338]

When you insert member the report is by default refreshed if you don't switch Freeze Data Refresh - User option.

[Former Member]

yes, that's the problem we are facing now, when ever we insert the new row in the EVDRE report(we are in EPM environment  using old EVDRE report )using insert member option , it is not refreshing by default and it is taking the formatting properties from the above row in the report , but when we refresh the report(only refresh and no expand) it is showing correctly ,

so what we are planning here is to refresh the report  when ever we inert the row using the insert member option .

[former_member186338]

Don't you think it's a good idea to tell that you are using EVDRE with BPC 10 from the very beginning???

Due to the limited support of EVDRE in EPM I don't think you will get any improvements ...

And anyway - no event -> no automatic refresh!

Vadim