Dynamic imput form

[former_member269849]

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.

[former_member186338]

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

[former_member186338]

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😞

=EPMMemberProperty(,EPMContextMember(,"TIME",,TRUE),"YEAR")

to get the year of the context member selected

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

https://blogs.sap.com/2013/03/01/static-report-in-bpc-nw-10/

Sample:

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