Some weeks ago SAP released the Analysis Office BIP Add On 1.4, which makes it possible to schedule and broadcast an Analysis for Office Workbook using the BI platform. It still hast several restrictions (e.g. prompts are not supported) but for simple tasks it can already be used.
To my mind the setup process is not well documented, so I want to mention the most important steps.
At first you have to download the latest version of "Analysis Office BIP Add On 1.4" from the Service marketplace.(http://service.sap.com/swdc)
Install this add-on on all your BO-nodes.
Afterwards open your CMC, go to the Server section and find your Job Server under the Core Services section. You have to stop the Job Server to add the "Analysis Office Schedule Service" to it (Select Services).
Open the properties of the Job Server and scroll down to the Analysis Office Schedule Service section. Add the path “Program Files (x86)\SAP BusinessObjects\Analysis Precalculation\BiPrecalculation.exe” (change the path to your BO installation directory) into the Precalculation text box.
Now you can start your Job Server again.
On your client PC of course you must have installed the Analysis for Excel Add-In for Office. It's important to use the latest version (e.g. 1.4.5 in my case), otherwise you can't export Analysis Workbooks to your BO platform.
Upload your Excel Workbook to your BO platform by using the option in the Analysis section of your File menu in Excel. You will see that your Excel Workbook is converted to an Analysis Workbook file on your platform.
When you right click on that object, you will see the Schedule option which is straight forward to setup.
One restriction at the moment is also, that you just can control your instances in the CMC. In Launch Pad there is no History-option like we know it from other objects.
In CMC, open the Instance Manager-section and search for Analysis Workbooks to monitor your scheduling processes.
In what version of Analysis for Office can the BOBJ Launchpad scheduler be used?
ReplyDeleteHello Bancanieve,
ReplyDeleteDeveloping a new gen developer friendly BI framework with some extremely unique features. Would like to give you early access & love to hear your opinion. Please do let me know of how to reach out to you. Would be launching product in 3 weeks from now.
Also, could you please share your email-id for further communication.
Regards,
Anugraha
Here i had read the content you had posted. It is much interesting so please keep update like this. Infact it will be useful for the beginners to develop their knowledge along with . I am expecting much more posts from you
ReplyDeleteHadoop Training in Chennai
Base SAS Training in Chennai