Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

EPM10 Basic question

Hi

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

ACTUAL   ACTUAL  .... ACTUAL   FORECAST FORECAST.... 2015.MAR

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

Regards

Silu

Former Member
Not what you were looking for? View more on this topic or Ask a question