Error when refreshing interactive analysis excel report

[JerushaLala]

Hi All
I created a cube/data model in SAP HANA studio and deployed it in SAP Business One. It works correctly and the info is correct.

I am using it in the interactive analysis and the idea was to format it and save the file. and just open it when I need to run the report and fresh. When I click refresh I am prompted for the SYSTEM password, I enter them but then I a get the below errors and the data does not refresh.

Has anyone had this issue before?
Any help and suggestions are always appreciated.

Regards,
Jerusha

[JerushaLala]

Hi All.

Just an update on my issue. I tried with 2 users machines and I get the below error.

Do I need to create a connection on their machines?

Regards,

[JerushaLala]

Hi Ankit

Thank you for the response.

Is there a specific script I need to run..Or can I check in the normal trace files?

Regards,
Jerusha

[ANKIT_CHAUHAN]

Hi Jerusha,

Have you been able to run the HANA SQL Trace and check whether it captures any error?

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[JerushaLala]

Hi Ankit

I think I just figured it out.

In the excel document, I need to go to the Analyze option, and click on Refresh from there...Instead of clicking refresh from the Data option.

My next issue now is this same file doesnt work on other users pc.. One step at a time 🙂

Thank you
Jerusha