Creating Workbooks


A workbook is a compound page that makes it possible for users to create charts and reports and incorporate this embedded content, along with external content, into a compelling display. The ability to create workbooks extends the role of the advanced user, empowering this user to build data narratives while employing the powerful combination of chart and page modes of WebFOCUS Designer. Workbooks can be run as content items directly from a browser, they can be published or shared with specific users and groups.

Procedure: How to Create a Workbook in WebFOCUS Designer

  1. On the Home Page, in the Resources tree, click a domain of folder, and then, in the Actions bar, click Workbook.

    The Open dialog box opens, as shown in the following image.

  2. Make one of the following selections:
    • To create a workbook from a Master File, select a Master File that would serve as a data source for the embedded charts and reports in your workbook, and then click Select.

      Note: Alternatively, you can click Upload or Connect to upload or connect a new data file.

    • To create a workbook from a Reporting Object or Master File shortcut, select a Reporting Object or a Master File shortcut on the Repository tab of the Open dialog box, shown in the following image, and then click Select.

      You can add custom thumbnails and tags to help the user identify Reporting Objects and metadata shortcuts more easily.

      Note: Another way to create a workbook from a Reporting Object is to right-click a Reporting Object in the Resources tree, point to New, point to Designer, and then click Workbook.

    Note: The view of the Open dialog box may vary depending on your privileges. You can see the Server tab if you have the Designer Content from Metadata privilege. You can see the Repository tab if you have the Designer Content from Reporting Object privilege.

    WebFOCUS Designer opens in chart mode.

  3. Create an embedded chart as described in the Creating Charts topic.

    You can reference your data source by clicking the Data tab, as shown in the following image. You can also use the Data tab to join two or more data tables, as described in Joining Data Sources topic.

    Note: The data tab is only available when you create a workbook from metadata. It does not display when you create a workbook from a reporting object.

  4. Click New embedded chart or New embedded report to add embedded charts or reports to your workbook, as shown in the following two images.

    Clikcing the New embedded chart button

    Clikcing the New embedded report button

    You can limit your workbook design to charts and reports only. In this case, at run time, it will display your collection of content in the carousel view. You can also add a single page to your workbook and use your embedded charts and reports to populate a page layout.

  5. To add a page, click New embedded page, as shown in the following image.

    The New Page dialog box opens.

  6. Click a template of your choice.

    WebFOCUS Designer in page mode loads. Notice that the embedded charts and reports are available in the Resource Selector in the Embedded Content area, as shown in the following image.

  7. Drag the embedded charts and reports to the canvas to populate the page.
  8. To add external content, in the Resource Selector, in the Content area, navigate to an item of your choice and drag it to the canvas.
  9. Save your workbook and exit WebFOCUS Designer.

    Your workbook now displays in the WebFOCUS Explorer on the Home Page. You can run, edit, and share it with other users.