Web FOCUS Integration with Microsoft Office SharePoint

1. Web FOCUS Integration with Microsoft Office SharePoint By: Kelvin Ruiz NASA – Kennedy Space Center

2. Agenda • Web FOCUS Open Portal Services • Available Components • Microsoft Office SharePoint • Web FOCUS Integration with SharePoint

3. 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.

4. Web FOCUS Components • Customizable WEB modules • Available for multiple Third Party Portal Applications. • Once deployed you can add them as “on-screen” components to your Portal. • More than 10 Portal Application supported

6. Available Components • Domain Component • Allows users to view their assigned Domains. • Launch Reports or Report Assist, Graph Assist and even Power Painter!

7. 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.

8. Available Components cont. • Favorites • Give easy access to a user’s list of favorite reports and graphs.

9. 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.

10. SharePoint Site

11. Web FOCUS Integration • Publish Web FOCUS Web Parts to SharePoint Server • Install WOAS_Cab.CAB • Configure Web Parts (.dwp files) • Add Web Parts to SharePoint Site Collection • Add Web Parts to desired site/page • ENJOY!

12. 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.

13. 12 Hive? • Most SharePoint files are here = Hive • Version = 12 • Get It? • C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN

14. 12 Hive?

15. Install WOAS_Cab.CAB cont.

16. 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.

17. Install WOAS_Cab.CAB cont.

18. Configure Web Parts • Web Part Files are part of the Web FOCUS installation. • Default Location: • D:\ibi\WebFOCUS76\worp\components\webparts2

19. Configure Web Parts cont.

20. 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”

21. Configure Web Parts cont.

22. Configure Web Parts cont.

23. Bonus Tip! • By Default Web Parts run with the credentials the user uses to login to SharePoint. • http://servername/ibi_apps/components/woas/governor/WOAS_view.jsp?SID=_LogonUser_&gn=1&view=report • You may change “_LogonUser_” for the user id you wish to use. For example: • http://servername/ibi_apps/components/woas/governor/WOAS_view.jsp?SID=Guests&gn=1&view=report

24. 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”.

25. Site Settings

26. Web Part Gallery

27. Web Part Gallery

28. Upload Web Parts

29. Upload Web Parts

30. Upload Web Parts

31. 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.

32. Group Web Parts

33. 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.

35. 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.

39. Domain List Web Part Added

40. 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

41. Browse Domains

42. Launch Power Painter • If you select Power Painter, a browser window will open after loading.

44. Report Assistant

45. Graph Assistant

46. Run a Report from Domain Web Part • Browse for the Report • Click on it • Select “Run” from the pop up menu.

49. 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.

50. 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.