Skip to Content
0

Error when refreshing interactive analysis excel report

Aug 18, 2017 at 11:19 AM

41

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jerusha Lala Aug 18, 2017 at 02:11 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Jerusha Lala Aug 22, 2017 at 07:51 AM
0

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,


Share
10 |10000 characters needed characters left characters exceeded
ANKIT CHAUHAN
Aug 18, 2017 at 01:01 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

excel-refresh.png (52.4 kB)
0