Dashboard integration with sharepoint

[#1]

Hi Experts

I'm new to dashboard and dashboard integration with sharepoint 2007

I have questions on some Dashboard integration with sharepoint 2007.

1.  web intelligence report can still be datasource for databoard using dashboard integration with sharepoint?

2. is SSO configurable in the above integration

What is the difference between IOMS and dashboard integration with sharepoint

Thanks in advance

Youqin

[Former Member · Accepted solution]

Hi Dave,

Pre-requisites

Xcelsius for SharePoint server (XSP) installs a web part container into the SharePoint web part library.

After installation and configuration, the web part container can be added to the Web Part Gallery within SharePoint and any user with the appropriate rights can add the web part container to a page within the site.

Xcelsius Web connectivity Parameters to use

SharePoint Parameter: Used to define parameters or properties in Crystal Xcelsius models that a user can change in the SharePoint environment

SharePoint Provider: Used to give data to another Web Part published in SharePoint

SharePoint Consumer: Used to get data from another published Web Part in SharePoint (a SharePoint List or another Crystal Xcelsius model)

Use the File -> Export -> SharePoint option to generate the .swf file with SharePoint functionality.

Once generated, you will be able to add and configure the SharePoint Web Part with the .swf file to publish the model

Building the Dashboard

Add the Xcelsius document to the SharePoint document list

Copy the shortcut to the uploaded document

Go the SharePoint page

Click on Modify Shared web part

Add a web part

From the web part-gallery list select Crystal Xcelsius web-part

Use Modify Shared Web Part option

In the Xcelsius Visualization source, specify URL (paste the shortcut you copied from the document list) and apply

It is possible to customize models Real-time – Change chart type, title etc when defined as SharePoint Parameter

Use Modify Shared web part at run time

Add a SharePoint List, say “Sample” as a web part in the same page

In the Xcelsius web part configuration menu, “connections” option is enabled once a list is added in the page

In the connections, specify consume list from “Sample”

All SharePoint lists and Providers in the same page will be listed in the connections option.

In order for a Xcelsius model to consume data from SharePoint Provider, there should be two models deployed in the same page – one for the provider and one for the consumer

The visuals in the swf file with the consumer will change based on the data from the provider once connection is set

Your SharePoint BI app is not limited to strictly Microsoft data sources: you have connectivity to more than 20 different data sources – relational and multidimensional – including SAP, Oracle, Microsoft, and IBM

Web parts are available in multiple sizes, making it easy to adapt to your viewing needs

Web parts can be arranged on your dashboard however you prefer

Ad-hoc analysis by pivoting in a web part interface

Bi-directional data communication including write-back to source data

Xcelsius makes SWF's. SWFs can be dropped into Sharepoint (and everywhere else).

There is no special software you need to do this.  SAP makes a Sharepoint integration Kit. This kit helps SSO work when Xcelsius SWF's are dropped into Sharepoint. The kit has strict requirements. Look em up to see if it is worthwhile. If you dont use SSO in your company, then dont worry about the Integration Kit. Its useless for you.  Do not install Xcelsius on a Sharepoint Server.  You can install Adobe Flash on the Sharepoint Server (for rendering SWF's).

Useful Links

http://www.businessobjects.com/pdf/products/crystalxcelsius/cx_sharepoint.pdf

http://wiki.scn.sap.com/wiki/display/BOBJ/Integration+of+an+Xcelsius+dashboard+in+Microsoft+Sharepoi...

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/c01d630d-7c64-2b10-5aa7-cf3d76363...

http://redmondmag.com/articles/2011/03/01/delivering-intelligence-with-sharepoint-dashboards.aspx

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/c01d630d-7c64-2b10-5aa7-cf3d76363...

Regards

NK

[Former Member · Accepted solution]

Hi Naveen,

Thanks for you really helpful reply/links.

Is dashboard integration with sharepoint 2007 sso configuration Which can be followed guide from IOMS sso configuration?

Many Thanks,

Dave

[nikhil_joy2 · Accepted solution]

Hi Dave,

The Integration option for Microsoft Sharepoint(IOMS) is a package to integrate BO contents with sharepoint portal. You can design sharepoint sites using the templates provided which can access BI platform contents.

refer below link for more details.

http://help.sap.com/D861704A-C426-4ED7-B826-0E418010882F/FinalDownload/DownloadId-0DD3205D7A47BF39F8...

refer below link for ioms elearning tutorial which explains steps with interactive visuals.

http://scn.sap.com/docs/DOC-19234

refer below link for a collection of KBAs related to IOMS where you can find info reg SSO option.

http://wiki.scn.sap.com/wiki/display/BOBJ/IOMS+Integration+for+Microsoft+Sharepoint+KBAs

Regards,

Nikhil Joy

[Former Member · Accepted solution]

Thanks Nikhill.

[Former Member · Accepted solution]

Hi Naveen,

Could you please let me know IOMS 4.0 supports WSS 3.0?

Our SAP client wants dashboards integration with SharePoint but SharePoint is Windows SharePoint Services 3.0 free version.

2nd query is about IOMS 4.0 supports only 64 bit SharePoint? either MOSS 2007 or SharePoint 2010 and SharePoint 2013. Will not support 32 bit MOSS 2007?

Thank you in advance

M Chintapalli

[Former Member]

Hi Dave,

Kindly refer the following Wiki and let me know if is usefull:

http://wiki.scn.sap.com/wiki/display/BOBJ/Integration+of+an+Xcelsius+dashboard+in+Microsoft+Sharepoi...

Regards,

Nakul Mehta

[Former Member]

Dear Nakul,

I already shared the link ,what is the use of sharing it again?