Scheduling and embedding BO Reports in SharePoint

[Former Member]

Hi,

We have a very restricted and locked down environment, so I am looking for some creative ways for scheduling and embedding BO Reports in
SharePoint. Goal is to publish weekly BO Reports, exported in Excel, to a document library on SharePoint, and/or to refresh embedded data in a SharePoint Web Part. Already tried scheduling to a SharePoint directory using UNC path, but it failed to access without giving a descriptive error message (Destination failed). A third party software, or direct connection to SAP is out of the question per our Administrators (performance, security, etc.). Looking to hear from anyone who had similar challenges and has come up with a “home-grown” solution.

Thanks kindly. 

[former_member832223]

Hi,

Did you find a solution?

I am trying to do the same?

Thanks in advance

[former_member201488 · Accepted solution]

It's certainly possible to schedule to a document library, but it can be a PITA to setup if I recall (haven't worked with Sharepoint in a while).

Lots of reference material:

http://www.forumtopics.com/busobj/viewtopic.php?t=157179

http://www.forumtopics.com/busobj/viewtopic.php?t=166510

http://www.forumtopics.com/busobj/viewtopic.php?t=215544

Try logging on with the credentials your SIA runs under, and browsing to the Sharepoint library UNC via Windows Explorer; this will let you know if it's an access issue with your BOBJ network credentials.

HTH

NMG

[Former Member · Accepted solution]

Good ideas and references. Thank you.

[Former Member]

Hi

I've always thought the account running the webi report job server should be an AD account with permissions to write to the other server (where the reports get sent) Something needs write access to put files there. Not sure how this worked in the past without that.

Regards,