Many SAP BusinessObjects customers make extensive use of scheduling and publishing, and this often involves sending the same report (as a PDF or Excel file) as an attachment to various email addresses. A good alternative is to schedule the report to be saved to OneDrive or SharePoint so that the file is physically stored in only one location. An additional benefit is that permissions are easy to set up and version history is available.<\/p>\n\n\n\n
First of all, it is important that SAP BusinessObjects runs under a (Windows) service account. This is usually already the case if Windows AD and SSO have been set up. In addition, the service account must be linked to an Office 365 (now called Microsoft 365) account. The next step is to log in to the BO server using the service account and install OneDrive. Select a local drive and folder to be synchronized with OneDrive. Repeat this on each BO application server if the BO environment consists of a cluster. Of course, the BO server must have internet access.<\/p>\n\n\n\n
When the report is scheduled in SAP BusinessObjects, you can specify the directory that syncs to OneDrive as the \u201cDestination\u201d under \u201cFile System.\u201d In this example, that would be the local directory \u201cE:\\OneDrive\\OneDrive \u2013 Alistar B.V\\Finance\u201d on the BO server. If desired, you can also choose to have BO send an email (without an attachment) notifying recipients that the report has been updated. However, a better solution is for the people who have access to the shared folder to set up their own notifications when an update is available.<\/p>\n\n\n\n
Scheduling to SharePoint Online works essentially the same way as scheduling to Microsoft OneDrive because the underlying Microsoft technology is the same. If there is a Microsoft 365 account for the SAP BO service account and the appropriate permissions have been granted to a folder in SharePoint Online, the service account can be used to log in to the BO server and access the relevant SharePoint folder. This folder can then be synchronized with a local folder on the BO server.<\/p>\n\n\n\n
When scheduling in SAP BO, this local folder can be used as a \u201cDestination\u201d for the schedule, just as with OneDrive. The files will then be automatically synchronized with SharePoint.<\/p>\n\n\n\n
If your organization still uses on-premises SharePoint, you can also schedule from BO to a SharePoint location. In that case, follow these steps exactly to set this up.<\/p>\n\n\n\n
Make sure SAP BusinessObjects is running under a Windows service account, and then grant that service account Contribute Rights on the desired SharePoint site.<\/p>\n\n\n\n
Install the Windows feature \u201cDesktop experience\u201d and restart the server after installation.<\/p>\n\n\n\n
Open the Registry Editor on the BO server.<\/p>\n\n\n\n
Go to the following location: HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\WebClient\\Parameters<\/p>\n\n\n\n
And add the following lines:<\/p>\n\n\n\n
DWord (32-bit): EnableAutoCertSelection with a value of 1<\/p>\n\n\n\n
DWord (32-bit): EnableCTLFiltering with a value of 1<\/p>\n\n\n\n
Multi-string value: AuthForwardServerList with value https:\/\/*.<SharePoint domain<\/em>>.com<\/p>\n\n\n\n Restart the Web Client service and check the box next to \"Automatically restart.\".<\/p>\n\n\n\n Go to Internet Explorer Options on the SAP BO server and set the SharePoint site as a \u201ctrusted site.\u201d.<\/p>\n\n\n\n Also open \u201cCustom level\u201d in Internet Explorer Options and enable the \u201cautomatic login with current username and password\u201d option.<\/p>\n\n\n\n Open the SharePoint site in Internet Explorer on the BO server after logging in with the BO service account. Click \u201cOpen with Explorer\u201d as shown below (if necessary, you\u2019ll need to switch SharePoint to classic view). Windows File Explorer should now open without prompting for credentials. If you are prompted for credentials, you\u2019ll need to repeat the previous steps; otherwise, scheduling to SharePoint will not work.<\/p>\n\n\n\n Find the UNC path that can be used for scheduling. In Windows File Explorer, select \u201cMap Network\u201d and then click the link \u201cconnect to a website that you\u2026\u2026.\u201d.<\/p>\n\n\n\n In the screen above, enter your SharePoint address to which the BO service account has access. For example: https:\/\/sharepoint.ensior.com\/BI_Governance\/ReportRepository\/Forms\/AllItems.aspx<\/p>\n\n\n\n Now retrieve the \u201cproperties\u201d of the network connection you just created and copy the UNC path listed under \u201cComment.\u201d For example: \\\\scharepoint.ensior.com@SSL\\DavWWWRoot\\BI_Governance\\ReportRepository<\/p>\n\n\n\n Use this address now to schedule a transfer from BO to SharePoint.<\/p>\n\n\n\n Instead of selecting the email option during scheduling and sending the same file to multiple mailboxes, Microsoft OneDrive and\/or SharePoint are good alternatives. Additional benefits include easy user authorization, reduced storage requirements, and automatic version control.<\/p>\n\n\n\n <\/p>","protected":false},"excerpt":{"rendered":" Many SAP BusinessObjects customers make extensive use of scheduling and publications, and as part of this process, the same report is often sent as a (PDF or Excel) attachment to various email addresses. <\/p>","protected":false},"author":16,"featured_media":30139,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[27],"tags":[151,153,225,432,430],"industrie-type":[],"interesses":[],"techologie":[],"alistar_language":[],"class_list":["post-30138","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-nl","tag-microsoft-365","tag-modern-work","tag-modern-work-applications","tag-onedrive","tag-sharepoint"],"acf":[],"yoast_head":"\nStep 4:<\/h3>\n\n\n\n
Step 5:<\/h3>\n\n\n\n
Step 6<\/h3>\n\n\n\n
Step 7<\/h3>\n\n\n\n
Conclusion:<\/h1>\n\n\n\n