Create a workbook

The workbook contains functions that use the existing global variables and global selection page variables.

In addition to filtering purposes, selection pages are used as a function in workbooks, as opposed to selection pages in dashboards and reports, which are used as a query. The selection page pre-populates a cell so that you can use it in functions. That function can then be used in the formula wizard instead of being hard-coded.

To create a workbook:

1. Right-click in an empty space in the Workbooks tab and select New Workbook.

   • 

2. In the New Workbook dialog box, select the appropriate authorizations and options. Refer to Authorizations and Options for more information.

3. Click Save. The new workbook is displayed in Edit mode.

4. If you chose a selection page in Step 2, the Selection Page dialog box is displayed.

   • 

   1. Enter the selection page values or use the prompt icon to select them from the list.
   2. Click Confirm. The new workbook is displayed in Edit mode.

Authorizations and Options

Authorizations Settings

Setting	Description
Description	Enter a meaningful description for the workbook.
Publish	Use the slider to publish the workbook for other users. There is also a second slider that allows you to publish for everyone or to select a specific group: - Publish to everyone (enabled by default): This option will publish the workbook to all users. - Publish to everyone when disabled: Click the slider to the left to select specific groups. The Select groups to publish to field is displayed to allow you to select one or more groups. Select the owner from the drop-down list. This is the user profile that will own and have full access to this workbook. The default owner is the current user.
Lock View Definition	Only the owner of this workbook or a user with the Administrator flag will have the ability to modify it.

Options Settings

The options settings allow you to open a selection page before opening the workbook.

Setting	Description
None	No selection page is applied.
Selection Page	Opens the selection page before opening this workbook. The workbook data can then only be retrieved once the criteria of the selection page is entered. You can select a global selection page from the list. To add or edit a global selection page, click the pencil icon Note that the parameters of the selection page will be available when creating a function.