Skip to Content
Author's profile photo Former Member

Overview of SAP BI 4.x Integration Option for Microsoft SharePoint

The integration option for SharePoint software (aka IOMS) enables SAP Business Intelligence (BI) solutions to work with the SharePoint software.  In this blog post I will walk you through few of the key IOMS features in BI 4.x.   

To start, here are some of the selected key highlights of IOMS

  1. Free download through service market place
  2. Deployed as a SharePoint Site template IOMS, IOMS provides instant access to content stored in BusinessObjects from SharePoint with native SharePoint look and feel.  
  3. Provides Authentication/SSO support and allows users to search, manage, view and interact with BusinessObjects content from the SharePoint environment.
  4. Includes out of box webparts for extending other SharePoint sites with BusinessObjects reports, dashboards, and more. 
  5. Supported platform:  Microsoft SharePoint Server 2007 (64 bit), 2010, and 2013
    1. Note: IOMS for SharePoint 2013 is supported as of 4.1 SP03

           

During installation, the installer will deploy a BusinessObjects site template in your SharePoint Server allowing instant access to the BusinessObjects content directly. 

    

When you access your IOMS portal URL (e.g. http://<machine_name>:80/), you will see the SAP BusinessObjects logon screen.  Users can setup SSO to skip the logon page using their Active Directory, LDAP, or BusinessObjects Enterprise credentials. 

LogonPage.jpg.png

Upon logging in, you will see a pre-deployed homepage composed of 4 main sections: Announcement, My Favorites, Recently viewed, and Recent Searches.    

For those of you familiar with BI launch pad, the “Recently Viewed” webpart is equivalent to the “My Recently Viewed Documents” widget in the BI
launch pad landing page.   The BI contents within IOMS are synchronized with your BusinessObjects servers where any changes you made in IOMS will
be reflected immediately in BI launch pad.

IOMS_BILP.png

The BusinessObjects SharePoint site template is designed to provide a native SharePoint user experience.  The familiar look and feel and navigation experience accelerate user adoption as users can move seamlessly from the IOMS to other SharePoint sites without having to change their basic working patterns or behaviors.  

The deployed BusinessObjects template comes with 3 main tabs: SAP BusinessObjects, Browser, and Page.  Within the Browser tab, you can navigate, manage, and view the BI content within SharePoint.   The “Page” tab allows you to easily customize the homepage using the out of box BusinessObjects webparts.  I will cover more on this in the later part of the blog post. 

landing page.png

 

The report (e.g. Crystal Reports, Web Intelligence reports, etc) can be viewed directly within the webpart (e.g. My Favorites).  You can perform similar capabilities such as printing, refreshing, and interacting with the reports with the IOMS viewers. 

/wp-content/uploads/2014/04/view_webi_438458.png

The “Inbox” and “Report Repository” drawers are equivalent to BI launch pad’s “My Documents” and “Folders” drawers.

InBox_Repo.png

The close integration with SharePoint’s native functionalities includes the breadcrumb navigation allowing users to jump straight to a specific folder
without having to navigate through the folder hierarchy. 

Breadcrumb.JPG.png

IOMS also provides flexible site searching option allowing users to search just the IOMS site or the IOMS site plus all the other SharePoint sites.  When searching just the IOMS site, the contents returned are identical to the contents returned if you were to do a search within BI launch pad. Within the search result page, you can also view or manage the report directly via the context menu. 

Search.png

Within the “SAP BusinessObjects” tab, you will find functionalities such as “New”, “Action”, “Upload” menus or Category View mode which are similar
what you would see in BI launch pad.   

BO_tab.png

The schedule option in the context menu also allows you to schedule and manage the BI reports within IOMS. 

Schedule.png

One of IOMS’s key functionalities is the ability to customize your landing page by enhancing other SharePoint sites by using the BusinessObjects
webparts that comes out of box.  These webparts allow you to

  • Viewing and interacting with Crystal Reports, Xcelsius (Dashboard Design), and Web Intelligence
  • Opening Office and PDF documents
  • Browsing the BusinessObjects repository
  • Searching and displaying search results from BusinessObjects
  • Helpful units for recent views and recent searches

/wp-content/uploads/2014/04/webparts_438469.jpg

It’s important to note that IOMS is meant to be used by the end users.  The administration tasks (e.g. starting and stopping servers) are still to be done within CMC. 

Reference Materials

  1. IOMS Installation and Administration Guide
    1. http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp3_ioms_admin_en.pdf
  2. IOMS Getting Started Guide
    1. http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp1_ioms_getstarted_en.pdf
  3. Official Product Tutorials – Integration Option for Microsoft SharePoint Software
    1. http://scn.sap.com/docs/DOC-19234

Assigned tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mark Richardson
      Mark Richardson

      Is there a good document for using the SAP Analytics tools (like IDT) to report against the data/records held within SharePoint..?

      oData looks like the only way to go if you want to write a report on "X number of documents" held in SharePoint by User X.

      Any better ways to do it via SharePoint Integration with SAP BO-BI 4.1...?

      Author's profile photo Former Member
      Former Member

      Hi Mark,

      I would be glad if we could be of any help as we specialises on SAP offerings and you can reach me to discuss how we can help you at niraj.jani@visiontreeconsulting.com

      Look forward to speak with you.

      Best,

      Niraj

      Author's profile photo Former Member
      Former Member

      Hi SAP,

      Could anyone direct me to integrate Microsoft Office 365 SharePoint with BusinessObjects 4.x?

      Cheers,

      Author's profile photo Maheshwar Singh
      Maheshwar Singh

      IOMS does not support Sharepoint Office 365, it is a roadmap item

      Thanks

      Maheshwar

      Author's profile photo COMMON LABSID
      COMMON LABSID

       

      Hi Maheshwar,

      Thanks for the info. Just wanted to check if this is still a roadmap item? Thanks in advance.

      Regards,

      Sri

       

      Author's profile photo Dallas Marks
      Dallas Marks

      We are also interested in IOMS support for Sharepoint Office 365 and would appreciate an update on its roadmap status.

      I've also not been able to figure out how to connect an Adaptive Job Server SMTP to Office 365. If it's a support issue, I would also like to see it resolved in future patch of SAP BI.

      Author's profile photo Former Member
      Former Member

      I am with Dallas on this. Any updates on the roadmap for this?

      Author's profile photo Caitanya Candra
      Caitanya Candra

      Hi Derrick,

      Thanks for the nice document.. i got a quick question ..could you please let me know whether this integration supports version management like regular share point or not?.

      Author's profile photo Maheshwar Singh
      Maheshwar Singh

      No, it does not. the BI documents continues to reside in the BOE repository

      Author's profile photo Former Member
      Former Member

      Hi experts,

      We want that the end-users access the reports in Sharepoint for viewing and save their own versions (e.g. Analysis for Office) into their own folder but not to the public folder.

      And they should not schedule any kind of reports.

      Is it possible? Any hints or detailed documents about this topic would be very appreciated.

      Thanks

      Deniz

      Author's profile photo Mario Kauer
      Mario Kauer

      Hi there

      Is IOMS also compatible with SharePoint 2016? If not when would it be possible to work with SharePoint 2016?

      Thanks,

      Mario