Can we automate Scheduling of SAP Analysis for excel using RESTFUL SDK or BO 4.1 sdks ?

[Former Member]

Hi All,

Can we schedule sap analysis 1.4 using RESTFUL webservices ?Or do I need to go for the BO 4.1 sdks ?
I was able to do default schedule with BI RESTFUL services but I want destination to be file system which I am not able to do. Any pointers ?

I am working with SAP BO Analysis for office(for excel) . I get 404-not found error when I use

=========================================

schedule>

    <name>nameOfSchedule</name>

    <format type="pdf"/>

    <destination>

        <filesystem>

            <username>{name of user}</username>

            <password>{user's password}</password>

            <directory>C:/tmp/</directory>

        </filesystem>

    </destination>

</schedule

=========================================

But, I could refresh a webi report with above requestBody

I can schedule  SAP BO Analysis for office(for excel)  using schedule form based on restful ws.

requestBody is

=========================================

<entry xmlns="http://www.w3.org/2005/Atom">
<author>
<name>name</name>
<uri>restfulwebsericeURL</uri>
</author>
<id>ididid</id>
<title type="text">name of schedule</title>
<updated>2015-06-02T22:26:09.234Z</updated>
<content type="application/xml">
<attrs xmlns="http://www.sap.com/rws/bip">
<attr name="everyNDays" type="int32">1</attr>
<attr name="retriesAllowed" type="int32">0</attr>
<attr name="retryIntervalInSeconds" type="int32">1800</attr>
<attr name="startTime" type="datetime">2015-06-02T20:38:07.152Z</attr>
<attr name="endTime" type="datetime">2015-06-06T22:26:07.152Z</attr>
</attrs>
</content>
</entry>

=========================================

but when I add destination to attr  as shown below like (<attr name="Destination" value="filesystem" type="text" username ="usrname" password="pwd">path of directory</attr>) , I get 500- Internal Server error.

I using POST with http:<baseURL>/infostore/<id>/scheduleForms/daily

where baseaURL is restful ws url.

========================================

<entry xmlns="http://www.w3.org/2005/Atom">

<author>

<name>name</name>

<uri>restfulwebsericeURL</uri>

</author>

<id>ididid</id>

<title type="text">name of schedule</title>

<updated>2015-06-02T22:26:09.234Z</updated>

<content type="application/xml">

<attrs xmlns="http://www.sap.com/rws/bip">

<attr name="everyNDays" type="int32">1</attr>

<attr name="retriesAllowed" type="int32">0</attr>

<attr name="retryIntervalInSeconds" type="int32">1800</attr>

<attr name="startTime" type="datetime">2015-06-02T20:38:07.152Z</attr>

<attr name="endTime" type="datetime">2015-06-06T22:26:07.152Z</attr>

<attr name="Destination" value="filesystem" type="text" username ="usrname" password="pwd">path of directory</attr>

</attrs>

</content>

</entry>

========================================

I wondering how to define destination . Or am I missing something.

Thanks,

Regards,

Pramod.

[former_member245941]

Pramod Puthenpurayil Sivadas wrote:

[...]
<attr name="Destination" value="filesystem" type="text" username ="usrname" password="pwd">path of directory</attr>
[...]

Regards,
Pramod.

Hello,

i have not worked with the RESTFUL SDK up to now, but were you able to manually test-schedule a report with the destination, username and password parameters of your use case? First i would check if the parameters for the pdf creation are valid by scheduling once manually.

It is just a shot in the dark: Just from looking at it the quoted excerpt of your example looks iffy to me. It is just a gut feeling but according to the SDKs documentation the parameters for 'username' and 'password' should be child elements of the 'filesystem' element, which in turn is a child element of the 'destination' element.

Your example reads like it would just create attributes of the 'destination' element, which would be ignored.

Kind regards,

[Former Member]

Hi,

I was able to schedule analysis workbook manually and put in shared directory using File System option as destination.

I was able to schedule Webi report and put it shared folder using RESTFul SDK but same RESTFUL sdk syntax fails with Analysis Workbook. I guess SAP still does not have a option to put Analysis into a destination using RESTFUL sdk even though I can do the default schedule using RESTFUL SDKs !

I wish there was more clear documentation on this

Thanks,

Regards,

Pramod.

[former_member110741]

Hi Puthenpurayil Sivadas,

You do not require any sdk's , Use BIP-ADD-on to schedule AO workbooks

Have a look at these documents

Best Regards,
Subhash

[Former Member]

Hi,

Yes, we can schedule the reports manually .But our requirement is schedule multiple reports at different schedules. Manual process is time consuming. Our plan to feed data into a file and let that be an input for a code to schedule. Basically, schedule multiple reports at multiple time schedule.

Any input would be great.

Thanks,

Regards,

Pramod.

[former_member110741]

Hi Pramod Puthenpurayil Sivadas,

Please have a look at the Recurrence section Under scheduling parameters

using that you can schedule your workbook automatically based on time based

either could be Hourly/daily/monthly... based

Best Regards,

Subhash

[Former Member]

Hi Venkat,

yes we can schedule analysis workbook as given. But I would like to know if there is process to schedule multiple workbook simultaneously ? if there are 30 or 100 workbooks to schedule and whose schedule instances have different parameters then a user has to manually got cmc or bi Launchpad to get things done. averaging 2 or 3 minutes to schedule each workbook.

I was looking for a faster way to automate scheduling of multiple workbooks.

Thanks,

Regards,

Pramod.

[former_member110741]

Hi Pramod,

i tried by selecting multiple workbooks and i cannot find an option to schedule. As far as i know multiple workbooks scheduling is not possible as of now.

You may can add this in Idea place

Regards,

Subhash