BPF nit able to open a report

[michele_medaglia5]

Hello BPC friends

I have a BPF calling a report, now I had to create in the report a new column with the EPMRETRIEVE function to read the data from a different model.

When I try now to call the report from the BPF, it opens Analysis for Office but it crashes.

I deleted the EPM formula leaving the new columns blank and I am able to open it.

How can I fix the above issue?

Thanks

Michele

[former_member186338]

Please look on your post results! No screenshots attached.

[former_member186338 · Accepted solution]

It's not possible to answer without details of your report with screenshots.

But in general you can use second EPM report with shared row axis for another model column (instead of EPMRetrieveData).

[michele_medaglia5 · Accepted solution]

thanks Vadim

My report is the below , where the last column is EPMRETRIEVE

Why I am not able to open it?

Thanks for your help

[former_member186338 · Accepted solution]

michele.medaglia5

P.S. EPMRetrieveData is a bad function and can be used only in cases when there is no other solution.

[michele_medaglia5 · Accepted solution]

Hi Vadim, please find below the report

[former_member186338 · Accepted solution]

Once again, simply don't use EPMRetrieveData!

[michele_medaglia5 · Accepted solution]

thanks Vadim but I don't understand why I can't use the EPMRETRIEVE formula

[former_member186338 · Accepted solution]

"I don't understand why I can't use the EPMRETRIEVE formula"

- It's slow

- Possible issues with refresh

- other issues depending on SP of your system

[michele_medaglia5 · Accepted solution]

thanks Vadim