Issue with Activ Form TM1RPTROW

[Stéphane]

Hi,

Here is my issue :

I generate a simple Activ Form with Perspectives, the TM1RPTROW is used that way :

=TM1RPTROW($B$9;"tm1serv:analytique";"";'{AR}01'!$B$23;"Lib_fr";0)

'{AR}01' is an hidden sheet created by tm1, at $B$23 I find the value i originally set with my activ form : Direction Services Supports

in excel i see :
+ Direction Services Supports *my measure number*

which is fine to me



If in '{AR}01' i change the value of $B$23 (for example to Services centraux which is a son of Direction Services Supports) and i recalculate the activ form nothing change : my AF still

i still get
+ Direction Services Supports *my measure number*

but expected
+ Services centraux *my measure number*


Can anyone tell me what I miss ?


(I'm 9.5.2 FP2)

Thank you very much

[lotsaram]

To recalculate the active form including change of the rowset the active form must be rebuilt. You do this by using Alt + F9 keys or the "Rebuild" button or by calling the VBA function TM1REFRESH.

For a change such as the one you are talking about it is much better not to use the hidden {AR}01 worksheet and instead use the MDX argument of the TM1RPTROW formula to pass in the member or member expression that you want on the rows.

[Stéphane]

Yes it works !

Thank you very much