Skip to Content

AO Precalculation and Scheduling available in SMP (15th Nov 2013)

Hello All,

AO Precalculation and scheduling features are now bundled as feature pack with BIP add-on.

What does it contain?

1. Precalculation enablement via BIP.

2. Scheduling (Broadcasting) via BIP.

Note that BW precalculation and broadcasting is still not possible.

This may be something planned for future?

Here is the SMP link to add-on installer -:https://smpdl.sap-ag.de/~swdc/012002523100020426492013D/BIPADDON04_0-10013163.ZIP?_ACTION=DL_DIRECT

Regards,

Bharath

Here is the documentation relevant to precalculation and Scheduling – http://help.sap.com/businessobject/product_guides/AMS14/en/14SP5_aaoffice_user_en.pdf   Section 10 – Scheduling

35 Comments
You must be Logged on to comment or reply to a post.
  • Hi,

    is there any information available in regards of sizing the BI Platform in the AAOffice scheduling usecase? What components are involved on the BIP when scheduling AAOffice workbooks? Is it comparable to AA OLAP refreshing for the sizing? Thanks!

    Regards,

    Harald

  • I scheduled one workbook and it’s delivered to the destination, but the data inside is not getting refreshed. Which settings are necessary to get it refreshed?

    We using SSO, no variables, and refresh on open is activated.

    We are using anylsis 1.4 and BO 4.1 SP2

    thanks!

    • Hello Hans,

      We also have problems with scheduling and AO documents. Please take a look in the Instance Manager, select Analysis Office, deselect status and click search. You should see an error message at the end of the line.

      We have an open ticket with SAP concerning this topic. What I have learned so far: scheduling only works for xslx and xslm not for xls.

      Torsten

      • Hello Torsten,

        Interesting, I can’t select “Analysis Office” in the Instance Manager, just Analysis Workbook. Does it mean that something is missing?

        Actually we installed all the Add-Ins in our BO platform. Are you sure you see it there?

        Thanks!

        • Sorry, that’s what I have meant 🙂

          After scheduling a job you should see it there (in our system the standard selection is pending – selected and Crystal Reports – not selected). After chaning the setting to AO and every status you can see all AO Jobs with the status. Maybe there are some with the status failed.

          • I did the scheduling via Publication, so I wouldnt find any instances searching for Analysis Workbooks. When I right click on my Excel there is no schedule-option, that’s why I did it with Publications. Do you have a schedule option?

          • Yes, I do have a schedule-option with right click in Folder view of cmc. I’m not sure if this is only available for files which are stored since the update to 4.1 (I have to check that tomorrow). The files which you save on BO platform are resulting in a kind of a link in the lauchpad folder view with the extension *.SAPAOX which points to the file on BO platform (the symbol is also different now).

          • Ok, what I fond out so far:

            until now I uploaded the Excel workbook with Analysis 1.4.3 and it ended up as an “Microsoft Excel” file type. I created a publication for it with the effect, that the excel-file gets delivered to the destination, but without data refresh (=useless).

            I upgraded now to Analysis 1.4.5 (and I am also using a newer Excel version), when I save the excel-file to the BI platform, it is saved as an “Analysis Workbook” file. This one I can’t use in publication, but I can schedule it. When I do that and find the Intance in the CMC Instance Manager, it get stuck in the “pending” state forever – no error message. (@Torsten: Did you have the same issue, could you solve it?)

            Is there anyone who could schedule (and refresh) an analysis for excel file successfully? Thanks!

          • The issue could be solved by adding the “Analysis for Office Scheduling Service” to a Job Server after installing the Analysis for office Add In. In the configuration properties I also set the Precalculation Path (e.g.: “C:\Program Files (x86)\SAP BusinessObjects\Analysis Precalculation\BiPrecalculation.exe” – don’t know if this step is necessary)

            Afterwards I could sucessfully schedule my Analysis workbook with saved prompt values.

          • Some new Information:

            • Scheduling is not working with .xls files (only xlsx / xlsm)
            • The error messages (if there are errors in scheduling) are only containing numbers. There is no text Information what’s wrong (4.1 SP1 Patch 4 – first Version of scheduling add in). That should be changed in future accourding to a SAP developer
            • Currently only OLAP Connections with the type Server are supported – Group is not supported
            • You have to install .NET 3.5 on Server (4.x is not enough)
  • Hi all,

    Is the BIP addon only required to get the following features:

    1. Precalculation enablement via BIP.

    2. Scheduling (Broadcasting) via BIP

    Or is the BIP Addon also required to be able to connect to the BI platform going forward?

    Thanks for clarifying, couldn’t find the information in the installation guide.

    Denis

    • It is only for scheduling. It is not precalculation in the meaning of BEx Broadcaster. But is is possible to calculate an Excel and send it e.g. via mail.

  • Using the API macros Analysis it is also possible to program your own precalculation server easily. It should not be a very big deal to implement a windows server application which will provide a web service that you can call to have any workbook precalculated with any variable selection. The workbook can be returned as xls(x) or pdf by the web service. Using some kind of dispatcher this could also be run on a multiple servers with load balancing. I did some tests, and it works pretty well. Of course you need some database where you maintain the values for the variables. (Or you save variants for the queries, that is also a possibility.)

  • There are some new options available now like parameters and history on BO platform (4.1 SP5 + AO 1.4 SP10). But there are still some features missing like “view last instance” and “limit instances”. And the parameters are not very comfortable: You have to type in all names (DS and variable) manually and you don’t get a proposal for the characteristics – so that’s a nice feature for administrators but not for standard users,

    In the end it is much better than before but not perfect. 😉

    Edit: I have tested BW variable from type SAP Exit (e.g. for the Date). They are automatically updated.

  • Has anyone tested the new option for entering variable values ? I tried it several times without success. The scheduling of the workbook doesn’t fail but the entry of the (optional) variables seems to be ignored  and the scheduled workbook just shows all values.