How to create reports in BO WebI from share point

general discussion
1

I am new to use microsoft sharepoint. I am working how we can do the reporting for sharepoint through BO. I am using BO XI R2.
Please give me some documents or manuals which I can read and get the idea how to use BO for getting reports for sharepoint.

Thanks

Archie (BOB member since 2008-06-19)

2

Hi Archie
please go through following link to have Sharepoint portal integration kit of BO

Here is the PDF for installation of SDK

do some Googling and you will get more details

Nirav

nniravv :india: (BOB member since 2007-08-16)

3

Hi Nirav,

Thanks for this.
If you have any link or document which you can share here which shows some sample reports or any tutorial of how to do the things that will be very nice and helpful.

Archie (BOB member since 2008-06-19)

4

Archie, please go through following BO SAP forum
https://www.sdn.sap.com/irj/scn/forum?forumID=311

Not sure either you can get solution or not , you can explore further in this community

Nirav

nniravv :india: (BOB member since 2007-08-16)

5

Archie,

Are you looking to create reports from scratch via sharepoint? I know that it is possible to link reports to be viewed in sharepoint but not sure if you can actually create the report.

May I ask why you don’t want to use Infoview to create the reports? Just curious.

Mitra

Mitra Moini (BOB member since 2002-09-01)

6

Hi Mitra,

I am trying to link to view reports in sharepoint and not create the report. The reports will be created in infoview only.

If you have already worked on this and give step by step points to link the reports, that will be a real great help to me.

Thanks
Archie

Archie (BOB member since 2008-06-19)

7

Not many people are using the SharePoint integration kit for BO, judging from the relative lack of questions about it. Archie, I think you’re going to have to read the manuals and trial-and-error explore on your own.

Basically, it means you’ll need to install the BO Enterprise SDK/API on the SharePoint server, and install the “web parts” (widgets) to view reports.

Note, however, that I think the Sharepoint integration kit only supports Crystal report viewing.

An easier way is just to just OpenDocument calls and use the Web Page Viewer part in SharePOint. But for this to work smoothly, you’ll really need Single Sign-On (SSO) enabled for both BusinessObjects and SharePoint.

dnewton :us: (BOB member since 2004-01-30)

8

Archie,
Did you ever get this to work?

I am SOMETHING similar:
Thinking of extracting specific information from within a Sharepoint document(Excel type) and populate it within a WEBI report.

My platform and version is:
BOXI 3.1
SQL Server
Sharepoint 2010 Foundation

Any help is appreciated

toscajo (BOB member since 2002-09-04)

9

Extracting information from SharePoint metadata or lists is a whole different matter, than displaying BO reports within the SharePoint site.

SharePoint data is only formally accessible through SharePoint web services. You’ll probably need to write something (custom program, ETL tool, etc.) to talk to the web services, and extract that data out to a database, where a Universe can point to it.

dnewton :us: (BOB member since 2004-01-30)

10

You could map a Sharepoint Folder to a Network Drive and then connect to the Excel Source via WEBI Rich Client, and use this as the basis for a WEBI Document. Is that what Toscajo is getting at?

I can get it to work locally (via WEBI Rich Client, connecting to an Excel File in Sharepoint), but because I’ve mapped the drive locally, it doesn’t work when exported to Infoview.

HTH

NMG

mcnelson :uk: (BOB member since 2008-10-09)

11

Rich Client would be a Blessing to have it; unfortunately we don’t

That said, I like to bring in the output of an Excel Macro into Data Services

toscajo (BOB member since 2002-09-04)