Skip to Content
avatar image
Former Member

EPM10 Basic question


IN EPM10 input template

1) In cell A5 to A13 - ACTUAL

          A14 to A16 - FORECAST

and in my Column axis contains CATEGORY(ACTUAL, FORECAST) , TIME (2014.APR - 2015.MAR) for 2014.APR to 2014.DEC category is ACTUAL and 2015.JAN to 2015.MAR FORECAST

= EPMOlapMemberO(A5,"[CATEGORY].[PARENTH1].[ACTUAL]","ACTUAL","","000")

but when i press REFRESH then ACTUAL for TIME 2014.APR to 2015.MAR appearing and FORECAST for TIME 2014.APR to 2015.MAR appearing, how can i resolve it,

this is basic question but still i'm not able to get


2014.apr   2014.mar  ..... 2015.mar   2014.APR   2014.MAY ......  2015.MAR

2) when i write Local member formulas formula is taking based on time and category combination for ex: 2014.APR & ACTUAL, when i select my time 2016.TOTAL then member got change to 2015.APR & ACTUAL and my LOCAL member formula not working, it is appearing as "#RFR" and formula got erased in column section.

I verified for above two questions in forums and build the template as guided by documents in forums, but still not working in my template, should i need to make any settings, please let me know



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 31, 2014 at 07:44 AM

    Hi Silu,

    Please go through the following link about static reports in BPC by Vadim

    Static report in BPC NW 10


    Add comment
    10|10000 characters needed characters exceeded

  • Dec 31, 2014 at 08:07 AM

    Hi Silu,

    Without detailed screenshot it's not possible to help...

    Also explain the logic with local member.


    Add comment
    10|10000 characters needed characters exceeded