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
To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. 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…?

    (0) 
        1. 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.

          (1) 
  2. 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?.

    (0) 
  3. Deniz Hunger

    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

    (0) 

Leave a Reply