Skip to Content
avatar image
Former Member

Dynamic imput form

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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):

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

    Add comment
    10|10000 characters needed characters exceeded