Skip to Content

Opening scheduled Analysis for office reports returns originally saved data

Hi Experts,

I am currently facing a problem, where i am scheduling an analysis report with prompts and after the scheduling is succesful, I was expecting that when i open the analysis report from the BI platform, I would see the scheduled data and not the data i initially saved the report with.

Is this by design or am I missing some wierd little tickmark somewhere?

BIP version: 4.2 SP3 patch 4

Analysis version:

Hope you can advice me.

Best regards


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 02, 2017 at 01:27 PM

    Please check out the below blogs, it will help with scheduling of Analysis office reports with prompts.

    2134836 - Checklist for Scheduling of Analysis for Office Workbooks



    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ashraf,

      Thanks for your reply. While I do not have an issue with the scheduling itself, my question was more directed at the intended behaviour of scheduled Analysis for Office reports on the BI platform.

      I can see from one of your supplied links (DOC-60492), that under paragraph 8 the following sentence can be found:

      "You can right click and select the “history” of the particular Analysis Workbook to view the instances.", is this to be interpreted as this is only was of accessing the scheduled instances of Analysis reports? For webi reports we are able to define in the CMC that the latest instance is to accessed when double clicking the reports on the BI platform.

      I am well aware that a solution could be to use opendocument and access the latest instance via hyperlink shortcuts, but I would classify this as a workaround.

      Best regards


  • Dec 06, 2017 at 05:48 AM

    Once you scheduled the report it doesnot mean that your data is getting refreshed with the updated on. That is the data which gets saved by saving your workbook.

    So once you open the report from the BI platofrm open it in analysis office and then select refresh all. it will ask for the connection password. give the same and then your data will get refreshed in the report.

    Let me know for any clarification.


    karan Sehjpal

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Karan,

      Sorry for the delayed response, and thanks for your reply.

      I do not agree with your statement in your first paragraph, the data is indeed refreshed when you schedule the analysis workbook. My question was rather, if it is intended behaviour that you need to go to history to find your updated data?

      Also scheduling and opening the analysis report in order to refresh the data source, does not make sense in my opnion (or atleast in my usecase), since that would mean filling out prompts twice, not mention waiting for the data to be fetched again!?

      This is not the case for WEBI reports for instance, if you double click the webi report in the navigation window, the latest instance of the report is fetched (if configured so).

      As i wrote to Ashraf, I consider the hyperlink solution a workaround.

      Best regards


  • Nov 20, 2018 at 02:55 PM

    Hey Rasmus,

    did you find a solution for this Topic?

    We had the same question at this moment.

    Thanks in advance


    Add comment
    10|10000 characters needed characters exceeded