Skip to Content

Dynamic imput form

Dec 29, 2016 at 05:53 PM


avatar image
Former Member

Hi experts,

I want that my report be dynamic and not static , for example if I change the context member of the time ( wich is Jour in my example ) colums of my report should change for example from 2016 to 2017 with the chhildern of course .

is it possibile ? if yes how?

thanks in advance.

contextmember.png (17.9 kB)
10 |10000 characters needed characters left characters exceeded

The correct primary tag for this question has to be: EPM Add-In for Excel

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Dec 29, 2016 at 06:59 PM

Not 100% clear what do you want to select but if you want to have quarters and total for some year depending on selection you can have in some cell (B3):


to get the year of the context member selected

Then use this year in EPMOlapMemberO formulas in column axis like here:


= EPMOlapMemberO($B$3&".Q1",”[TIME].[PARENTH1].[2017.Q1]”,”2017.Q1”,””,”000″)

10 |10000 characters needed characters left characters exceeded