Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
BI_BOBJ_300 Business Objects For Power Users PowerPoint Presentation
Download Presentation
BI_BOBJ_300 Business Objects For Power Users

BI_BOBJ_300 Business Objects For Power Users

380 Views Download Presentation
Download Presentation

BI_BOBJ_300 Business Objects For Power Users

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. BI_BOBJ_300 Business Objects For Power Users BI_BOBJ_300 Business Objects for Power Users

  2. Course Content • Introduction • Unit 1 – Business Objects Infoview • Unit 2 – Basic Report Design • Unit 3 – Modifying Existing Reports • Unit 4 – Adding Objects • Unit 5 – Query Filters • Unit 6 – Creating Queries • Course Summary BI_BOBJ_300 Business Objects for Power Users

  3. Prerequisites, Access and Software • Prerequisites • UK_100, IRIS R/3 Access • Course must be on training plan • Access • Determined by Area Security Officer • Business Objects Infoview local client • Check with your IT support to load software • Call Customer Service tech support at 7-5599, if you are unsure of who your IT person is BI_BOBJ_300 Business Objects for Power Users

  4. Benefits of Business Objects (BOBJ) • Ability to join different data sources to create ad-hoc reports • Examples: GRADS, Remedy, FDB, BEx • Web interface where users can check out reports in their role-based folders, saving their own formatted views of the report • Interactive-mode, where power users can refresh the data • After changes to the query have been made • In the end user reports • Supports conditional formatting, alerts, and drill-downs BI_BOBJ_300 Business Objects for Power Users 4

  5. Terminology BI_BOBJ_300 Business Objects for Power Users

  6. Reports • Are created using universes • Example of BEx Universe: Report FI_Missy: BOBJ_300 Exercise Report Universe Funds Center Balances: Budget vs Actual BEx Query QZPU_C02_5008 BExInfocube ZPU_C02 BI_BOBJ_300 Business Objects for Power Users

  7. Unit 1 Business Objects Infoview BI_BOBJ_300 Business Objects for Power Users

  8. Unit 1 – Business Objects Infoview • How to Access • Using Infoview BI_BOBJ_300 Business Objects for Power Users

  9. How to Access • Click on myReports • Click on Options and select Open in New Window • Provides larger viewing area BI_BOBJ_300 Business Objects for Power Users

  10. BusinessObjects Infoview • When Business Objects InfoView opens, click Document List • Use either the menu or the toolbar • Contains the reports to which you have access • Click Yes if the Security Information box appears BI_BOBJ_300 Business Objects for Power Users

  11. Favorites Folder • Default folder • Contains reports you save here • Other Power Users can not access reports here BI_BOBJ_300 Business Objects for Power Users

  12. Public Folders • To view other reports, click on the Expand icon to the left of Public Folders or double-click on the folder • BW role determines access to folders • Double-click on the appropriate folder to display the reports BI_BOBJ_300 Business Objects for Power Users

  13. Finding a Report • You will be able to see the title, type, and owner of the report • You also can search for title of a report BI_BOBJ_300 Business Objects for Power Users

  14. Opening a Report • To open a report, double-click on it • A system message may display letting you know that the document is being retrieved (processed) BI_BOBJ_300 Business Objects for Power Users

  15. Exercise • Displaying a Report BI_BOBJ_300 Business Objects for Power Users

  16. Navigation Map Use to move around the report, either the map or tabs BI_BOBJ_300 Business Objects for Power Users 16

  17. User Prompt Input Can change variable values and refresh data BI_BOBJ_300 Business Objects for Power Users 17

  18. Exporting Report Can export the report in one of four formats: Excel Adobe PDF Excel CSV (Comma-separated values) Excel CSV (Comma-separated values) with options BI_BOBJ_300 Business Objects for Power Users 18

  19. Summary • How to Access • Using Infoview BI_BOBJ_300 Business Objects for Power Users

  20. Unit 2 Basic Report Design BI_BOBJ_300 Business Objects for Power Users

  21. Unit 2 – Basic Report Design • Report Design • Edit Report Screen • Report Manager • Grids BI_BOBJ_300 Business Objects for Power Users

  22. Report Design • Report format can consists of: • One or more reports (sub-reports) • Similar to multiple worksheets in an Excel file • One or more blocks • Table, cross tab, form, or chart • Returned Data BI_BOBJ_300 Business Objects for Power Users

  23. Edit Report Screen • To make changes to the report use the Edit Report screen • After running the report, click on Edit • When the screen displays, the Edit Report button will be highlighted BI_BOBJ_300 Business Objects for Power Users

  24. Edit Report Screen BI_BOBJ_300 Business Objects for Power Users

  25. Report Manager – Data Tab • Allows viewing the data objects available in a document • Organized alphabetically (default) • Recommended to arrange by query BI_BOBJ_300 Business Objects for Power Users

  26. Data Tab • Classes • Logical groupings of objects that map to data in the database • Dimensions • Retrieves data – typically character-type • Details • Provides descriptive data about the dimension BI_BOBJ_300 Business Objects for Power Users

  27. Data Tab • Measures • Retrieves numeric data resulting from calculations on data in the database • Query Filter • Predefined filter that restricts the information retrieved from the database BI_BOBJ_300 Business Objects for Power Users

  28. Template Tab • Allows adding and changing the type of blocks in a report by dragging and dropping templates • Also provides templates for adding: • Last Refresh Date • Page Number • Page Number/Total Pages BI_BOBJ_300 Business Objects for Power Users

  29. Map Tab • Allows viewing and navigating through reports and sections in document • Click on Structure to view the structure of the report BI_BOBJ_300 Business Objects for Power Users

  30. Properties Tab • Allows formatting the report and blocks within the report • Click on a part of the report to view its properties, i.e., table, cell, title, header, etc. BI_BOBJ_300 Business Objects for Power Users

  31. Thumbtacks • Used to keep the Report Manager displayed • Click on the thumbtack to collapse the Report Manager • Click on one of the Report Manager buttons to open again, and then click on the thumbtack to keep it open BI_BOBJ_300 Business Objects for Power Users

  32. Report Manager • Simple to configure how the tabs display • Use the Configure Views icon BI_BOBJ_300 Business Objects for Power Users

  33. Report Manager • Data tab in front of other tabs (default view) • Properties tab below Data tab • Allows both tabs to be viewed simultaneously • Tabs become clickable buttons BI_BOBJ_300 Business Objects for Power Users

  34. Report Manager • Data tab on left, Properties tab on right • Collapsing Report Manager as vertical toolbar • Tabs become clickable buttons BI_BOBJ_300 Business Objects for Power Users

  35. Grids • Use grids to line up report features, such as the title, graphs, charts, tables, etc. • Click on Show User Settings icon BI_BOBJ_300 Business Objects for Power Users

  36. Grids • Can • Change the measurement unit • Show grid • Snap to grid • Change grid spacing BI_BOBJ_300 Business Objects for Power Users

  37. Grids • Select your settings and click OK • Grid displays in background of report BI_BOBJ_300 Business Objects for Power Users

  38. Exercise • Edit Report Screen BI_BOBJ_300 Business Objects for Power Users

  39. Summary • Report Design • Edit Report Screen • Report Manager • Grids BI_BOBJ_300 Business Objects for Power Users

  40. Unit 3 Modifying Existing Reports BI_BOBJ_300 Business Objects for Power Users

  41. Unit 3 – Modifying Existing Reports • Edit Report Mode • Using Save As • Rearranging Columns • Change Report Title • Remove Objects • Refresh Data BI_BOBJ_300 Business Objects for Power Users

  42. Edit Report Mode • Provides access to change the report including • Format changes • Sorting data • Adding/deleting/rearranging columns • Refresh data • Using free standing cells • Adding breaks, graphics • Tracking data changes • Access to Edit Query mode • Not all functions above taught in this course BI_BOBJ_300 Business Objects for Power Users

  43. Using Save As • Remember! Use the Save Asfunctionality if you are changing an existing report • Ensures that you do not make changes to another person’s report • Two ways to save • Save As • Save to my computer As BI_BOBJ_300 Business Objects for Power Users

  44. Using Save As • To save the report in BOBJ, click on the drop-down icon to the right of the Save icon and select Save As • To drop the report on your computer in Excel or pdf format, click on Save To My Computer As • Cannot upload back to Business Objects BI_BOBJ_300 Business Objects for Power Users

  45. Using Save As • Click on My Favorites folder • Enter the new name for the report in the Name field • Important! Use the Business Objects Naming Standards BI_BOBJ_300 Business Objects for Power Users

  46. Using Save As • Click on Advanced to change the description of the report • Change the Description field • Include the universe name in the description BI_BOBJ_300 Business Objects for Power Users

  47. Using Save As • Enter keywords including universe name and AD/MC User ID • Recommended to not select Refresh onOpen BI_BOBJ_300 Business Objects for Power Users

  48. Using Save As • Click OK • After saving, the new name will display in the report window header BI_BOBJ_300 Business Objects for Power Users

  49. Rearranging Columns • To rearrange columns, click on column heading an hold down the mouse button • Move the column to the new location and release the mouse button to drop the column • Note: As you move the column heading, the system will highlight possible “drop sites” BI_BOBJ_300 Business Objects for Power Users

  50. Rearranging Columns • Column will display in its new location BI_BOBJ_300 Business Objects for Power Users