epmretrievedata used along with epmlocalmember doesnt fetch data

[v_g1]

Hello Team,

Trying to build an EPM report with the below structure

Existing report:

Row axis: Account, Company, Intercompany

Column Axis: AuditID, Currency

Wanted to build report:

Row axis: Account, Company(Intercompany of Company), Intercompany (Company of Intercompany)

Column Axis: AuditID, Currency

I am using epmretrievedata to derive amounts that are stored at above mentioned intersections. All is well if it is just epmretrievedata formula. However, when I create a local member with this formula, all rows are changed to #NODATA error. Further, after refresh all rows changed to Invalid member: Account ID- Account Description.

Please suggest a fix for this issue.

Thanks in advance.

[N1kh1l]

v.g1

Easier if you show the screenshot of your report and also the formula bar view of the actual formula written.

Nikhil

[v_g1]

@nikhil@1486

Here is the screenshot.

PS: Problem is only with Column H alone. Column F & G are alright & have been provided for clarity sake.

PS: All other references for epmretrievedata are from page axis.