refresh issue after member insertion

[Former Member]

Hello,

I have an issue with an input form in which i would like to detail 4 accounts by partners. The input form is built as follow :

1. Structure of the report

in rows :

          Account dimension

          Partner dimension

               I_NONE : total account without Partner detail

               I_ALL : sum of partner

               I_PA : Partner 1, 2, etc...

               S9999 : Non group

     Option of the input form : remove empty and zeo values is activated for rows.

in col :

          any other dimension (made with an EPMdimensionoverride)

Users will have to use the EPM function "EPM insert members" to detail the account / I_None information. The issue is that after inserting, sending, and refreshing datas by partners, the I_ALL member (aggregation of partners) does not appear.

After closing, re opening, and refreshing, the member appears correctly.

Can anyone have already met this kind of issue ?

Thanks for your help !

Edouard

[former_member186338]

Hi Edouard,

Please provide screenshot for better understanding of the issue!

Vadim

[Former Member]

thanks for your answer, please find the screenshot in shrikant answer !

[former_member186338]

The intco hierarchy is like:

I_NONE

     S9999

I_ALL

     I_xxx

     I_xxx

     ...

Vadim

[former_member186338]

P.S. And please show Member Selection screenshot for the partner dimension for PIC1

Vadim

[former_member186338]

Was able to reproduce the same scenario! Looks like it's not possible - after member insertion any criteria with I_ALL will be replaced by the inserted members.

Only some VBA may help.

Vadim

[Former Member]

thanks for your answer. Indeed i understand that EPM member insertion replace edit report. If i close without saving my input form, it works after reopening it.

am i right ?

[Former Member]

Hi,

Strange that after closing, then re opening the report on the same contexte (where data were sent), I_ALL appears....

seems a refresh issue...

BR

Olivia.

[former_member186338]

Nothing strange, the file was not saved And the original definition will show I_ALL!

[Former Member]

thank Vadim and Olivia,

Vadim,

i'm a beginner in VBA script. it would be VBA script with an "after_save" event ? could you please advise me on what the script could be ?

Thanks a lot !

Edouard

[Former Member]

Thanks Vadim and Olivia,

I'm a beginner in VBA script, but it would be a VBA script with a after_save event ?

Could you advise me on what could be this script please ?

Thanks again,

Edouard

[former_member186338]

Yes, closing without saving and reopening will restore original member selection. But this is not the right way

[former_member186338]

You have to use AFTER_SAVE event like:

Dim epm As New FPMXLClient.EPMAddInAutomation

Function AFTER_SAVE() As Boolean
ThisWorkbook.ActiveSheet.Range("B5").Formula = "=EPMDimensionOverride(""000"",""INTERCO"",""I_NONE,BAS(TotalInterco),TotalInterco"")"
epm.RefreshActiveSheet
ThisWorkbook.ActiveSheet.Range("B5").Formula = ""
epm.RefreshActiveSheet
AFTER_SAVE = True
End Function

It will apply EPMDimensionOverride to restore original members selection, refresh, then remove EPMDimensionOverride and refresh finally.

Vadim

[Former Member]

Thanks Vadim for your answer, i'll try as soon as possible but it seems to be a good idea !

[former_member186338]

You can also try to play with API: AddMemberToRowAxis

Vadim

P.S. By the way - if some answer is useful - mark it useful, not "Like"

[Shrikant_Jadhav]

Hi Edouard,

Where the user inserting row ? Is the sheet is protected ? Any sorting / filtering ?

Kindly explain the issue with the help of real screen shot.

Shrikant

[Former Member]

thanks for the answer :

PIC1 (#1) : when opening input form i want to detail by partner

PIC2 (#2): After inserting sending refreshing datas by partner

PIC3 (#3): after closing, reopening, the I_ALL agregation appears whereas i'm exepecting to get it at end of #2,

Account are filtered in edit report, but in my mind no impact.

Sheet is unprotected

[Former Member]