Transcript WebFOCUS Integration with Microsoft Office SharePoint

Web FOCUS Integration with
Microsoft Office SharePoint
By: Kelvin Ruiz
NASA – Kennedy Space Center
Agenda
•
•
•
•
Web FOCUS Open Portal Services
Available Components
Microsoft Office SharePoint
Web FOCUS Integration with SharePoint
2
Web FOCUS Open Portal Services
• Allow integration of Web FOCUS Business
Intelligence and your businesses
Intranet/Internet Portals (Websites).
• Incorporate comprehensive reporting and
analysis capabilities with your existing
team collaboration sites.
• Have Web FOCUS Reports on the same
site as your relevant business data,
documents, schedules and action items.
3
Web FOCUS Components
• Customizable WEB modules
– Available for multiple Third Party Portal
Applications.
– Once deployed you can add them as “onscreen” components to your Portal.
– More than 10 Portal Application supported
4
5
Available Components
• Domain Component
– Allows users to view their assigned Domains.
– Launch Reports or Report Assist, Graph
Assist and even Power Painter!
6
Available Components cont.
• Report Component
– Can be setup to display a specified Report every time
a user accesses that page.
• Deferred Status Component
– Active button that when clicked will show users the
status of any report submitted for deferred execution.
• Quick Links Component
– Quick access to Business Intelligence Dashboard
(BID). If ReportCaster is installed, links to the Library
and Caster will be displayed as well.
7
Available Components cont.
• Favorites
– Give easy access to a user’s list of favorite
reports and graphs.
8
Microsoft SharePoint
• Web based collaboration tool that allows teams
to:
– Coordinate Projects, calendars and schedules
– Discuss ideas and review documents
– Share information and keep in touch with other team
members.
• Web FOCUS web parts expand SharePoint’s
capabilities to host Business Information side by
side with Reports, Documents and Project
Schedules among other things.
9
SharePoint Site
10
Web FOCUS Integration
1. Publish Web FOCUS Web Parts to
SharePoint Server
•
Install WOAS_Cab.CAB
2. Configure Web Parts (.dwp files)
3. Add Web Parts to SharePoint Site
Collection
4. Add Web Parts to desired site/page
5. ENJOY!
11
Install WOAS_Cab.CAB
• This file is not part of the Web FOCUS
installation. I got it from our IBI Support
guys.
• When you obtain it, copy the file in a folder
on your SharePoint Server
• Copy SharePoint Command Line tool
STSADM.exe from the “12 Hive” to the
same folder you put the “cab” file.
12
12 Hive?
•
•
•
•
Most SharePoint files are here = Hive
Version = 12
Get It?
C:\Program Files\Common Files\Microsoft
Shared\web server extensions\12\BIN
13
12 Hive?
14
Install WOAS_Cab.CAB cont.
15
Install WOAS_Cab.CAB cont.
• Open Command Prompt and run the
following to install it. (From the directory
you copied your files)
• Stsadm –o addwppack –filename
WOAS_Cab.CAB –force –globalinstall
• You should see: Operation completed
successfully.
16
Install WOAS_Cab.CAB cont.
17
Configure Web Parts
• Web Part Files are part of the Web
FOCUS installation.
• Default Location:
• D:\ibi\WebFOCUS76\worp\components\we
bparts2
18
Configure Web Parts cont.
19
Configure Web Parts cont.
• By default this files have “localhost” as the
server name.
• Open each .dwp file and input your server
name.
• You can open this files with “notepad”
20
Configure Web Parts cont.
21
Configure Web Parts cont.
22
Bonus Tip!
• By Default Web Parts run with the credentials
the user uses to login to SharePoint.
– http://servername/ibi_apps/components/woas/govern
or/WOAS_view.jsp?SID=_LogonUser_&gn=1&view=r
eport
– You may change “_LogonUser_” for the user id you
wish to use. For example:
– http://servername/ibi_apps/components/woas/govern
or/WOAS_view.jsp?SID=Guests&gn=1&view=report
23
Add Web Parts to SharePoint Site
• Go to your SharePoint Top Level Site and
add the Web FOCUS web parts to the
Web Part Gallery.
• Site Actions  Site Settings  Under
“Galleries” click on “Web Parts”.
24
Site Settings
25
Web Part Gallery
26
Web Part Gallery
27
Upload Web Parts
28
Upload Web Parts
29
Upload Web Parts
30
Group Web Parts
• After uploading you will see a form where
you can change some properties of the
uploaded Web Part.
• Recommendation: Create a group to put
your Web FOCUS Web Parts.
31
Group Web Parts
32
Upload Web Parts
• Repeat upload steps for each web part
you wish to make available in your site.
• Your Web FOCUS web parts will now be
in the Web Part Gallery.
33
34
Add Web Parts to desired site/page
• Your SharePoint site is now ready to
display Web FOCUS content.
• To add Web Parts to a page:
• Site Actions  Edit Page
• Then Click on the page Region you want
to put your Web Part
• The Add Web Parts window will pop-up.
• Scroll down to the “Web FOCUS” section
and select the Web Part.
35
36
37
38
Domain List Web Part Added
39
Domain List Feature
• Select the desired Domain from the drop
down list
– Browse reporting objects and reports
– Launch Report Assistant, Graph Assistant or
Power Painter
40
Browse Domains
41
Launch Power Painter
• If you select Power Painter, a browser
window will open after loading.
42
43
Report Assistant
44
Graph Assistant
45
Run a Report from Domain Web
Part
• Browse for the Report
• Click on it
• Select “Run” from the pop up menu.
46
47
48
Report Web Part
• The Domain list Web Part is very practical to create new
reports or graphs and to edit existing reports.
• But, what if you want to embed a report or graph to your
page?
• This is very useful if you want to have your most
important report always present right next to where your
team’s documents, calendar and schedules are.
• Very useful if used to track a performance indicator that
varies during the day
• On sites where customer can go to View business
information only.
49
Report Web Part
• To add a Report Web Part:
• Site Actions  Edit Page
• Then Click on the page Region you want
to put your Web Part
• The Add Web Parts windows will pop-up.
• Scroll down to the “Web FOCUS” section
and select the Web FOCUS Report Web
Part.
50
Select the Report
51
Report List Option
• If you select “List” you can choose multiple
reports that will display as items and can
be executed from there.
52
Launch Option
• Every time someone opens your web site
the report will launch automatically with no
user interaction.
• If the page is “Reloaded” the report/graph
will display the most up-to-date
information.
• Above the Report there is a “Refresh” link
that will update the report as well.
53
54
55
More Information
• Web FOCUS Open Portal Services
Administration Guide
– http://documentation.informationbuilders.com/
masterindex/html/html_wf_761/wf761openapp
/wf761openapp.pdf
56