Skip to Content

Error when refreshing interactive analysis excel report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 18, 2017 at 02:11 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2017 at 07:51 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 18, 2017 at 01:01 PM

    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

    Add comment
    10|10000 characters needed 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)