Skip to Content
0

Opening scheduled Analysis for office reports returns originally saved data

Dec 01, 2017 at 02:16 PM

110

avatar image

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: 2.3.0.57241

Hope you can advice me.

Best regards

Rasmus

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

2 Answers

Mohammed Ashraf
Dec 02, 2017 at 01:27 PM
0

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

https://archive.sap.com/documents/docs/DOC-60492

https://archive.sap.com/documents/docs/DOC-64437

Thanks

Ashraf

Show 1 Share
10 |10000 characters needed characters left 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

Rasmus

0
avatar image
Former Member Dec 06, 2017 at 05:48 AM
0

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.

Regards

karan Sehjpal

Show 1 Share
10 |10000 characters needed characters left 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

Rasmus

0