cancel
Showing results for 
Search instead for 
Did you mean: 

EPMOlapMemberO formula to the cell containing EPMCommentFullContext

Former Member
0 Kudos

Hi expert:

  We have an issue with EPMOlapmemberO reference to another cell. This Cell contains an EPMCommentFullContext formula. When refresh, comments gets right and the cell which have EPMOlapmemberO show new comments right values, but the value inside EPMOlapmemberO formula does not get new member dimension.

In the screenshoot bellow:

    cell F3 contains EPMcommentfullcontext and retrieve right value

    cell G3 contains EPMOlapmemberO formula  with reference to F3

   Refresh button

   Cell G3 show right value, but EPMOlapmemberO formula not get reference and show previous values

Anybody have same issue?

Thanks,

Abel

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Refresh second time

former_member186338
Active Contributor
0 Kudos

P.S. Before experimenting with comment value (a bit strange idea) please test with a fixed value in F3

Former Member
0 Kudos

Hi Vadim:

    Fixing value in F3 and refresh, EPMOlapmemberO  formula runs properly and change right values.

   And refresh twice it doesn´t work.

Abel

former_member186338
Active Contributor
0 Kudos

"And refresh twice it doesn´t work" - doesn't work - what do you mean?

Former Member
0 Kudos

I mean than f5 cell show new value but EPMOlapmember formula don´t get the new value, retain old value

Abel

former_member186338
Active Contributor
0 Kudos

By the way, may be comment contain some space at the end?

Test in F4

=">"&F3&"<"

Former Member
0 Kudos

No, I already tested and not contains space either at the start and end

Abel

former_member186338
Active Contributor
0 Kudos

Just tested myself - yes, I can see the issue!

Looks like EPMcommentfullcontext is refreshed at the wrong time and EPMOlapmemberO is not able to read the proper contents of the cell during refresh.

Then only VBA will help (before refresh - copy comment to some cell)

Vadim

Former Member
0 Kudos

Ok Vadim , thanks a lot for your time and your effort. We´ll try to code VBA in order to solve it.

Thanks again

Abel

former_member186338
Active Contributor
0 Kudos

In VBA you have BEFORE_REFRESH event.

In a new module:

Function BEFORE_REFRESH() As Boolean

ThisWorkbook.Worksheets("Sheet1").Range("F4").Value = ThisWorkbook.Worksheets("Sheet1").Range("G3").Value

BEFORE_REFRESH = True

End Function

And the formula in F3 will be :

= EPMOlapMemberO($F$4;"[xxxx].[xxxx].[xxx]";"yyy";"";"000")

Tested, working!

Vadim

Former Member
0 Kudos

I just insert your VBA code and test it. WORK FINE !!!

Brilliant, well donde Vadim

Thank you very much

Abel

Answers (0)