I'm using EPM Add-in 10.0 and SP 20.
I created a report with a column "Time" and a row "Account".
The problem I've noticed is that the amount at the intersection of [2012.Q1] and [Total Asset] is not aggregated properly.
It seems that the amount for [2012.Q1] and [Total Asset] is from the value of [2012.03].
I was wondering if I didn't save the data property, when I had saved the amount for [2012.01], [2012.02], and [2012.03] in input form last time.
What I've investigated so far is as follows:
- When I changed Account member to others such as [Net Income], the amount for the parent member was aggregated properly.
- When I selected an option "Calculate parents in hierarchies" in Edit Report, the amount for the parent member was aggregated properly.
- When I used a EPM function "EPMRetrieveData", the amount returned "400" that is the amount for [2012.03].
Does anyone know where this issue comes from?
Thanks in advance.