Skip to Content
0

Dynamic imput form

Dec 29, 2016 at 05:53 PM

74

avatar image

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

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

1 Answer

Vadim Kalinin Dec 29, 2016 at 06:59 PM
0

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″)

Share
10 |10000 characters needed characters left characters exceeded