Creating Analyses and Building Dashboards

Navigate to the Oracle Business Intelligence Sign In page and sign in.

Navigate to the Oracle Taleo Enterprise Edition Sign In page and sign in. The Oracle Taleo Enterprise Edition Sign In page is displayed. Enter your User ID and Password and click Sign In.

When you sign in, the Welcome Center is displayed.

The Welcome Center is the landing page where you can choose which Oracle Taleo Enterprise Edition Cloud Service module you would like to access. You can access Oracle Business Intelligence by choosing the link in the top navigation, or through Centers in the left channel.

When you access Oracle Business Intelligence, the Home Page is displayed.

The Home page is a task-oriented, centralized workspace combined with a global header, allowing access to Oracle Taleo BI objects, their respective editors, help documentation, and so on.

The Home page contains a global header, a Create New section, a Catalog Management section, a Get Started section with links to additional help and BI tools, a Recent section displaying the recently viewed or created analyses or dashboards, and a Most Popular section. You can always operate these features from the global header as well.

You can add catalog objects to favorites using the following steps:

Select an object (analysis or the dashboard) from the catalog. In this example we selected the analysis MH Hired vs Applied. Click the More drop-down list and select the task Add to Favorites.

The selected analysis or object is displayed with a gold star symbol on the Home page.

You can also add the catalog object to favorites by using the tasks pane as shown below.

a. Select the object: a report, analysis, or a dashboard.

b. Click the Add to Favorites task from the task pane.

The analysis is displayed as a favorite object on the Home page.

You can also add the object from the viewer window.

Open the object (in this example it is an analysis).

Click the Favorites menu, and then select Add to Favorites.

The analysis is displayed as a favorites on the Home page. Observe a star next to the newly added analysis.

You can organize these favorites and also delete the objects from the favorites section based on your business requirements.

a. In the global header's Search field, click the drop-down list, and select the object type for which you want to search.

b. Place your cursor in the field next to the Search field and enter part or all of the object's name or description.

c. Click the arrow icon to begin the search.

The Catalog page is displayed with the results that match your search criteria.

The available data types when exporting analyses are:

From an analysis, opened either directly from the catalog, or in a dashboard, click Export, and choose the format you want the analysis saved as.

From the dashboard you can export a dashboard page or the entire dashboard to Excel.

Click More Options > Export to Excel and export the current page or the whole dashboard.

Individual dashboard pages and analyses can be saved as Printable HTML or Printable PDFs. After making a selection a print preview will open up that you can print or save in the specified format.

To view a dashboard print preview, click More Options > Print and view a Printable PDF or Printable HTML.

To view an analysis print preview, click Print and view a Printable PDF or Printable HTML.

From the Home page, click New > Analysis.

The Select Subject Area pop-up appears.
A subject area contains columns that represent information about the areas of an organization's business or about groups of users within an organization. When you create a new analysis, this subject area is known as the primary subject area and will appear in the Subject Areas pane of the Analysis Editor. If, as you work, you need more data, you can add additional subject areas if you have permission to access these additional subject areas.

In the Select Subject Area pop-up, select Recruiting. The Analysis Editor is displayed.

Observe the Analysis Editor, which is used to explore and interact with information by visually presenting data in tables, graphs, pivot tables, and so on.

The Analysis Editor is composed of tabs and panes, as shown in the screenshot, representing the subject area (columns), available catalog objects, selected columns for the analysis, and filters (which limit the selected data).

A subject area contains folders, measure columns, attribute columns, hierarchical columns, and hierarchy levels that represent information about the areas of an organization's business or about groups of users with an organization. Subject areas usually have names that correspond to the types of information that they contain, such as Period, Regions, Products, Orders, and so on.

In this example:

• The selected subject area is Recruiting
• The four tabs (Criteria, Results, Prompts and Advanced) are displayed at the top of the Editor
• The Selected columns pane is empty because you have not yet to chosen the columns
• The Filters pane is empty as well waiting for the column selections and further criteria

There are various column types in a subject area. They are:

The screenshot shows folders and columns in the Recruiting subject area.

a. Select the following columns for your analysis.

b. While selecting the columns, click the collapsed arrow to expand the folders and double-click the required column names to get them in the Selected Columns section. In this example, expand Requisition Logistics>Requisition Primary Location, and then double-click Region - Name to get it in the Selected Columns section.

c. The selected columns are displayed in the Selected Columns section. Your analysis criteria should look like this:

Note: In the Selected Columns section, you can reorder the columns in your analysis by clicking and dragging them. The image shows the step-by-step view of reordering the columns.

Click the Results tab. The default Compound Layout is displayed.

The Compound Layout is a composition of many views. By default, both a Title view and a Table view are defined for you when using attribute and measure columns. A Pivot Table view is automatically created when using hierarchical columns in your analysis.

The Title view allows you to add a title (the default), a subtitle, a logo, a link to a custom online help page, and timestamps to the results. The Table view displays results in a standard table. You can navigate and drill down in the data. You can add totals, customize headings, and change the formula or aggregation rule for a column. You can also swap columns, control the appearance of a column and its contents, and specify formatting to apply only if the contents of the column meet certain conditions.

Note: In the Compound Layout, you can create different views of the analysis results such as graphs, tickers, and pivot tables. These are covered in the upcoming topics.

a. Click the Criteria tabbed page. Select the column Requisition Primary Location > Region - Name to create a filter. You can create a filter by hovering over the specific column's toolbar and selecting the More drop-down menu.

b. In the More drop-down menu, select Filter.

You can also create a filter by clicking the "Create a filter for the current Subject Area" icon in the Filters pane and then selecting the column from the drop-down list, as shown in the screenshot.

The column selected for this example is Region - Name.

Since you have already selected a filter in the previous step you are not using this option.

The New Filter dialog box is displayed. Accept the default value for the operator (is equal to / is in), and enter a column value (or a range of column values) for this condition. To do this, click the drop-down list for Value, and select the desired checkboxes. Values may vary due to configuration settings. Choose any values you wish. I am choosing Albany and Allentown.

Click OK.

The Filters pane displays the newly created filter.

Save this filter. Click the More Options icon in the filters pane and select Save Filters from the drop-down list.

The Save As dialog box appears. A filter should be saved to a subject area folder so that it is available when you create an analysis using the same subject area.

Navigate to the _Filters folder under the My Folders. Select the Recruiting Folder. Name the filter LOD Region Filter and accept the default location. If a Confirm Save Location dialog box appears, accept the default. Oracle Taleo BI allows you to save any type of business intelligence object to any location within the Catalog. However, for some object types such as filters, Oracle Taleo BI suggests the best Catalog location.

The Save As dialog box should look like this:

Click OK.

The Filters pane should look like this:

Next, you save the analysis so that you can verify the creation of your named filter within the Catalog.

a. Click the Save icon to save your analysis.

b. Navigate to My Folders and click the New Folder icon . The New Folder dialog box appears.

c. Name the folder LOD Analysis Folder and click OK. Save the analysis as Regional Applicants in the catalog folder LOD Analysis Folder.

Verify the named filter.

Click the Catalog link on the global header and navigate to the folder where you saved your filter. The LOD Region Filter is displayed in the Catalog.

Go to Home page, and in the Recent area, click the Edit link for the Regional Applicants analysis.

Now you will add a sort to this analysis.

a. On the Criteria tabbed page, click the More Options icon for # Submissions.

b. Select Sort > Sort Descending.

Observe that a sort icon is added to # Submissions. The order of the sort is indicated by an arrow; in this case, the arrows points down, indicating that it is descending. Additionally, if multiple sorts are added, a subscript number will also appear, indicating the sequence for the sort order.

c. Save your analysis again.

Click the Results tabbed page to verify the filter and sort are being applied to your analysis. The Compound Layout displays the filtered and sorted analysis.

This concludes the topic of saving an analysis and sorting it.

Click the plus icon to expand the Selection Steps pane of the Compound Layout.

The Selection Steps pane opens.

Under Requisition Sources - Req. Source Type, hover over 1. Start with all members, and click the pencil icon.

The Edit Member Step dialog box appears with the list of available products.

You will use the shuttle icons to move column members between the Available and Selected columns.

Click the Move All shuttle icon to move all members from the Available pane to the Selected pane.

In the Selected column, select Job Board and Our Website and click the Remove icon to return these two members to the Available column. (If these options are not available, choose any selections you want.)

You can use Ctrl+C and click to select multiple members in the list. Click OK. Note that the two members that you removed(Install and Maintenance), are not selected anymore.

a. The Selection Steps pane appears with the new values added. Observe that you can also save the Selection Steps as an object in the Catalog by clicking the Save icon.

b. Click the collapse arrow icon to minimize the Selection Steps pane

.

Verify your results by reviewing your analysis in the Table view of the Results tab. Due to configuration settings you may have a scroll bar instead of pagination.

If you have pagination, click the double-headed arrow icon within the Table view to display all rows of the analysis.

The analysis appears with all 19 rows. The number of results you see may be different.

.

To add totals to your analysis, click the Edit View icon in the Table view.

The Table Editor appears.

a. To add a grand total to the analysis, click the Totals icon to the right of Columns and Measures in the Layout pane of the Table editor.

b. Select After from the drop-down list. Review the results in the Preview pane, and note that the Totals icon now displays a green checkmark, indicating that a grand total has been added to the analysis.

c. Click Done.

Before adding a total to the Region, remove the sort from # Submissions.

a. Click the Criteria tabbed page.

b. Click the More Options icon for # Submissions and select Sort > Clear Sort.

c. Click the Results tabbed page and review the Table view to confirm that the sort has been removed from the analysis.

Now you will add a total by region to your analysis.

a. Click the Edit View icon in the Table view. The Table Editor appears.

b. In the Layout pane, click the Totals icon for Region - Name.

c. Select After from the drop-down list. Review the results in the Preview pane, and note that the Totals icon now displays a green checkmark, indicating that a total has been added for that specific column/region.

After you create and run an analysis, default formatting rules are applied to the analysis' results. Default formatting rules are based on cascading style sheets and XML message files. You can create additional formatting to apply to specific results. Additional formats help you to highlight blocks of related information and call attention to specific data elements. You can also use additional formatting to customize the general appearance of analyses and dashboards.

Now you will apply formatting to the Region - Name column.

You apply formatting to a heading. Click the More options icon for the Region - Name and select Format Headings.

The Edit Format dialog box appears.

a. In the Caption text box, enter Region.

b. In the Font area, click the drop-down list for Color and select a red color from the Color Selector dialog box. Click OK.

c. In the Cell area, click the drop-down list for Background Color and select a light blue color from the Color Selector dialog box. Click OK.

d. Click OK in the Edit Format dialog box to see the results of your format changes for the Region - Name.

The Preview pane should look like this:

a. Click the Table View properties icon on the toolbar.

The Table Properties dialog box appears.

b. Select the Enable alternate styling check box, and click OK.

c. The Preview pane should look like this. Click Done and then save your analysis.

This concludes the topic of formatting and adding totals to your analysis.

Create a new analysis by using the same columns that you used to create Regional Revenue. Select New > Analysis on the global header. Use Recruiting Subject Area.

Add Region - Name from Requisition Logistics > Requisition Primary Location, Req. Source Type from Requisition Posting & Sourcing > Requisition Sources, and # Submissions from Candidate Facts > Candidate Counts to Selected Columns.

Next, you will add a named filter that you previously created to limit the analysis..

a. In the Catalog pane, navigate to locate your filter LOD Region Filter.

b. Select the filter and click the Add More Options icon.

a. In the Apply Saved Filter dialog box, select the Apply contents of filter instead of a reference to the filter check box. This option adds the filter as an inline filter, allowing you to make changes without changing the Catalog filter item. Note that if you do not select this check box, the filter is added as a named filter that you can view, but not edit.

b. Click OK. The filter is added to your analysis.

Save the analysis to your LOD Analysis Folder, entering Regional Applicants Graph as the analysis name.

You will add a graph to this analysis.

a. Click the Results tabbed page, and click the New View icon.

b. Select Graph > Bar > Recommended Subtype from the menus.

The Graph view appears below the Table view.

Click the Remove View from Compound Layout icon for both Title and Table views.

Both views are removed from the Compound Layout. Note however, that they are still available for use from the Views pane.

Save the analysis.

Click the Edit View icon to begin your formatting changes. The Graph editor appears.

The Graph, like other view editors, is composed of three sections:

Click the Edit properties icon.

The Graph properties dialog box appears.

The Graph properties dialog box is composed of four tabbed pages: General, Style, Scale, and Titles and Labels. These tabbed pages allow you to do the following:

a. Select Enable for Horizontal Axis from the "Zoom and Scroll" check boxes. When zooming and scrolling is enabled for a graph, then the graph includes a Zoom icon. The Zoom icon allows you to zoom in and out of a graph's plot area via its axes. Once you zoom in on an axis, you can scroll the axis. When you zoom an axis, a zoom and scroll slider appears.

b. Select left from the Legend location drop-down list. The dialog box should look like this:

Note: The "Animate graph on Display" checkbox specifies whether to show initial rendering effects and is selected by default. For example, the bars on a horizontal graph start at the x-axis and move up the scale on the x-axis to the current measurement level.

"Listen to Master-Detail Events" allows you to specify this analysis as a detail view in a master-detail relationship. You will use this option in a subsequent step when working with pivot tables

a. Click the Style tabbed page.

b. Click the Style drop-down list for Graph Data and select Gradient. The Graph Data area allows you to choose a style for specific types of graphs. For example, you might choose pattern fill for to highlight differences on a line-bar graph or gradient for a bar graph to make the data values standout.

Click the Background drop-down list in the Plot area, and select a light blue color from the Color Selector. Click OK.

The Graph properties dialog box should look like this:

Click the Scale tabbed page. The Scale tabbed page appears.

Specifying setting for the axis limits and tick marks enables you to control what you see on your graph. If you override the system default for tick marks, the colors that you have selected for horizontal and vertical gridlines on the General properties tabbed page will be applied to both major and minor ticks.

a. Click the Titles and Labels tabbed page.

b. Deselect the check box for Use measure name as graph title and enter Regional Submissions in the Title text box.

c. Click the Format Title icon for Graph Title.

The "Font Format: Title" dialog box appears. You use this dialog box to specify how titles, legend labels, and so on are handled (such as truncated automatically) and to specify font properties. Click Cancel.

Deselect the check box for Vertical Axis Title and click OK to close the Graph Properties dialog box.

The preview pane refreshes and should look like this:

Examine the changes that you made to the graph. The formatting changes have been applied along with a new title and a horizontal zoom.

Click the Zoom icon and select Zoom In.

Once you have zoomed in, a slider appears.

a. In the Layout pane, move Region - Name from the Group By drop target to the Graph Prompts drop target. The preview pane refreshes:

The prompt allows you to select each region individually, making the graph a bit easier to consume.

b. Move Region - Name to the Sections area and select the Display as Slider check box. The Graph editor should look like this:

When you move along the slider for a particular region, the graph changes accordingly.

c. Click Done and then save your analysis.

You can further experiment with the region slider using the play button, action arrows, or slider.

The graph display changes accordingly.

Click New > Analysis on the global header.

Select Recruiting as the subject area.

In the Analysis Editor, add the following columns to the analysis criteria:

Click the Results tabbed page to view the analysis and inspect the pivot table. Observe that the Pivot Table view is included by default.

a. Return to the Criteria tabbed page.

b. Apply the LOD Region Filter named filter as you did previously.

c. Edit the column properties for # Openings. Click the More Options icon for # Openings and select Column Properties.

The Column Properties dialog box appears.

Select the Column Format tabbed page. Select the Custom Headings check box and enter Openings in the Column Heading text box.

Select the Data Format tabbed page. Select the Override Default Data Format checkbox and select the values as indicated below in the image. Click OK.

Click the Results tabbed page. Review the formatting changes that you made to the Opening column. (Note that you must have more than 1000 openings in a region to see the 1000's separator.)

Delete the Title view and then click the Edit View icon to format the pivot table.

The Pivot Table editor appears.

Format the pivot table as follows:

a. Drag Business Unit - Name below Measure Labels.

b. Drag Region - Name to the Sections area.

The pivot table should look like this:

Add a calculation to the pivot table by duplicating the Openings column. Click the More Options icon for the Openings column and select Duplicate Layer.

The duplicated Openings column appears.

a. Select the More Options > Format Headings to edit the properties for the duplicate column.

b. In the Caption text entry box in the Edit Format dialog box, name the new column % Openings and click OK.

Change the calculation to reflect a percentage of the parent. Select the More Options > Show Data As > Percent of > Row Parent.

The Pivot Table editor looks like this:

Click Done and save the analysis as Regional Openings Pivot. The pivot table should look like this:

a. Expand the Orders Hierarchy by clicking the plus sign icon for Job Field Name Total for Albany, or whatever your top section is. The open and collapse arrows are used to expand and collapse the data for analysis. Requisition Job Field Name contains Job Field Names on the row edge and Job Field Name Total as the parent. Openings is the measure.

Because hierarchical columns imply pivot tables, you can sort not only on members and measures, but also on rows. Hierarchical members on the row edge can include sort carat icons () , which allow you to sort the members on the column edge by that row, in either ascending or descending order. These carat icons do not appear for attribute columns, which do not have the concept of a row edge.

When you sort members in a hierarchical column, you always sort within the parent; that is, children are never sorted outside of their parent. The children appear below the parent in the proper sort order; the parent is not sorted within its children.

b. The Job Field Name Total parent member represents an outline total for the orders. Row sort Job Field Name Totals, for your top section in Descending sequence and examine the results within the pivot table. (You can also access sort options by choosing Sort in your right click menu.) The product brands on the column edge are sorted, reflecting sorted Openings values in descending sequence for each Job Field Name Total.

a. Place your cursor on top of the Requisition Job Field Name Hierarchy and right-click. Select Collapse all items in view from the menu. Notice that you can also sort, exclude columns, and move items around using this menu.

b. Place your cursor to the left of the Business Unit - Name column (Electronics in this example). A tab appears. When you hover over this tab, a swap icon appears. You use this swap icon to swap columns with rows or to reposition a column or row along a different axis.

The swap icon look likes this:

c. Drag Business Unit - Name on top of Orders Hierarchy. The pivot table should look like this before you release the mouse button:

d. Release the mouse button and review the pivot table.

e. Save the analysis.

Click the New View icon and select Gauge > Dial.

Scoll down and view the gauge.

Use the pencil icon to access gauge editor. Change the display to medium size and edit the gauge properties, Titles and Labels tab, to remove the footers. The gauge view should look like this.

Add a slider to the gauge (for Region - Name) and exclude the Requisition Job Field Name Hierarchy.

In the Layout pane, drag Region - Name to the Sections drop target and select Display as Slider. Then, drag Requisition Job Field Name to the Excluded drop target.

Click Done and save the analysis.

Select the New > Analysis on the global header. Select A – Sample Sales as the subject area.

In the Analysis Editor, double-click the following columns:

Click the Results tab. Two views appear: Title and Pivot Table. Because you are using hierarchical columns, a Pivot Table view is generated automatically.

Expand Requisition Latest Filled Date Hierarchy.

a. Delete the Title view.

b. Scroll down to view the Selection Steps pane. Expand it.
Note: If you do not see the Selection Steps pane, click the Show/Hide Selection Steps pane icon

You will add members based on Hierarchy for Requisition Job Field Name Hierarchy.

In the Requisition Job Field - Requisition Job Field Name Hierarchy section, click Step 2.Then, New Step. Select Select Members based on Hierarchy.

The New Hierarchy Selection step dialog box appears.

Select “Based on Family Relationship” from the Relationship drop-down list.

The New Hierarchy Selection Step dialog box expands.

Select “ Keep only”, “Siblings Of” as the action, and then expand Job Field Name Total and select a child. This example uses Information Technology, but you may choose a different job field that is available to you. Move the selection to the Selected pane.

Click OK.

Save the analysis as My Selection Steps Analysis under the folder My Folders>LOD Analysis Folder. Observe that the analysis only shows the siblings of Information Technlology, or your selected job field.

Click the pencil icon  in Step 2 to edit the selection for Product Hierarchy.

In the Edit Hierarchy Selection Step dialog box, select Include selected members. Click OK and save the analysis.

Observe that Information Technology, or your selected job field, is included this time.

Selection Steps views are now available just as another view that can be included.

From the New View drop-down list, select Selection Steps.

The Selection Steps view is displayed in the compound layout.

Save the analysis.

Now, you will add a Group for Requisition Job Field Name Hierarchy.

In the Product – Product Hierarchy section, click “Then, New Step.”

Select Add Groups or Calculated Items > New Group.

In the New Group dialog box, enter My Group in the Display Label text box, expand Total  Product, and then select FunPod and HomeView. Move them to the Selected pane and click OK.

This new group is added to the Compound Layout view.

Click My Group in the Selection Steps View and you will be able to see the values in My Group.

You can also see the values if you expand My Group in the Pivot table.

Save the analysis.

This concludes the topic of creating a Pivot table and applying selection steps to the table.

Set up the master view to which you link the detail view.

a. Edit the Regional Openings Pivot analysis, and click the Criteria tabbed page.

b. Click the More Options icon and select Column Properties for the Region - Name column.

The Column Properties dialog box appears. Click the Interaction tabbed page.

In the Value area, click the Primary Interaction drop-down list, and select Send Master-Detail Events.

When "Send Master-Detail Events" is selected, a qualification text box, Specify channel, appears. You use this text box to enter a name for the channel to which the master view will send master-detail events. This is a case-sensitive text box.

a. Enter region in the "Specify channel" text box and click OK.

b. Save the analysis.

Define the detail view to which the master view should link. You can add any view that includes the same master column as the master view.

a. Click the Results tabbed page to view the Compound Layout and click Edit View for the Gauge view.

b. The Gauge editor appears. Click Edit gauge properties on the toolbar.

The Gauge Properties dialog box appears.

a. Select the Listen to Master-Detail Events check box.

b. Enter region in the Event Channels text box. Remember that this must match precisely with the text entered for the master view.

c. Click OK.

Click Done and then save your analysis.

a. In the Pivot Table view (the master view), select Albany , or a region available to you, to drill down.

Both the Pivot Table view and the Gauge view (the detail view) update to reflect the drill.

b. Save your analysis.

To create a meaningful Narrative view, begin by creating a new analysis that includes a calculated item.

a. Create an analysis as you did above, including the following columns:

b. Add a filter to Region - Name and select only one region. For this example, I choose Albany region. Save the filter as LOD One Region.

a. Add # Submissions Ace to the Criteria tabbed page a second time. The Selected Columns within the Criteria tabbed page should look like this:

b. Edit the Column Properties for the duplicate # Submissions Ace column. Click More Options for this duplicate column and select Column Properties.

c. Select the Column Format tabbed page, and select the check box for Custom Headings. Enter % Submissions Ace in the Column Heading text box.

d. Using the Data Format tabbed page, format the data for this column as a percentage with two decimal places and then click OK.

The Selected Columns should look like this:

a. Click More Options for % Submissions Ace and select Edit Formula.

The Edit Column Formula dialog box appears:

b. Enter the following formula in the Column Formula text box.

("Candidate Counts"."# Submissions Ace"/"Candidate Counts".# Submissions")*100

Hint: You can copy the line of code and paste it in the Column Formula text box.

The Edit Column Formula dialog box should look like this:

c. Click OK.

a. Select the Results tabbed page and remove the Title view from the Compound Layout.

b. Click the Edit View icon to open the Table editor.

c. Click the More Options icon for Region - Name and select Hidden to hide the column.

d. Click Done to review your results. The Table view should look like this:

e. Save the analysis as Ace Submissions by Region.

To add the Narrative view perform the following steps:

a. Click the New View icon on the toolbar and select Other Views > Narrative.

b. Drag the Narrative view above the Table view.

c. Click the Edit View icon for the Narrative view.

The Narrative editor appears.

• You use the Prefix text box to enter the header for the narrative. This text is displayed at the beginning of the narrative.
• You use the Narrative text box to enter the narrative text that will appear for each row in the results. You can include both text and column values. Include a line-break code at the end of this field to force each line of text and values onto its own line. To include values, use the at sign (@) by itself to indicate the first column. If you include multiple signs, then the first occurrence of the sign corresponds to the first column, the second occurrence corresponds to the second column, and so on. You use the @ sign to include the results from the designated column in the narrative.
• You use the "Row separator" text box to enter a row separator for each line from the Narrative field that contains values. For example you might enter a string of plus signs (+) between each line.
• You use the "Rows to display" text box to enter the number of rows from the column to return. For example, enter 5 to display values from the first 5 rows of the column. For a hierarchical column, you can use selection steps to display hierarchy levels with the hierarchical column. A hierarchy level is considered a row.
• You use the Postfix text box to enter the footer text to appear at the bottom of the narrative. To display the footer information on a separate line from the actual narrative text, include markup tags in the Postfix field. Ensure that the narrative ends in a line break, or that the footer begins with a line break.
• The toolbar allows you to use HTML code and markup to enhance the narrative.

b. In the Prefix text box, enter This analysis shows the percent of ace candidates per educaiton level within the , ensuring that you leave a single space following the last word.

c. In the Narrative text box, enter @1, where the number "1" represents the first column in the analysis (Region - Name). Then, select the @1 that you entered and click the bold icon.

d. In the Postfix text box, enter region., ensuring that you include a space before region and a period after region.

e. Enter 1 in the "Rows to display" text box.

Notice that a preview is provided at the bottom of the editor.

Click Done and save your analysis. The Compound Layout should look like this:

This concludes the topic of creating a narrative view.

a. Open the Regional Applicants analysis in the Analysis Editor. The Results tabbed page appears.

b. Click the New View icon and select Other Views > Column Selector.

The Column Selector view appears. Drag the Column Selector view above the Title view.

Click the Edit View icon for the Column Selector view. The Column Selector editor appears.

a. Select the Include Selector Region - Name check box.

b. In the Label (optional) Choices text box, enter Choose a column:.

c. With Column still selected, double-click the following columns to add to the selector: Job Field Name, Business Unit - Name, and Job Role Name.

d. Click Done.

The Compound Layout appears:

a. Click the Column Selector drop-down list and select Business Unit - Name:

b. The values change appropriately. Note, however, that because you set a custom heading for the Region - Name column earlier, the custom heading is still displayed for the column.

c. Save the analysis.

Now you will add the View Selector view.

A View Selector view provides a drop-down list from which users can select a specific view of analysis results from among saved views. A View Selector view is analogous to a storage container, because it holds other views that have been selected in the editor for display.

a. Perform these steps before adding the View Selector view:

• Delete the Title view from the Compound Layout.
• Set the Column Selector to display the Region - Name column, which is the default. Then delete the Column Selector view from the Compound Layout.

• Add a Graph view - Vertical Bar graph.

These changes will allow you to showcase the analytic data-driven views. Regional Applicants should look like this:

a. Click the New View icon on the toolbar and select Other Views > View Selector.

b. Drag the View Selector view to the right of the Table view.

c. Click the Edit View icon for the View Selector view.

a. The View Selector editor appears.In the Caption text box, enter Choose a view:.

b. In the Available Views list, select the Table and Graph views and click the shuttle icon to move them to the Views Included list.

A preview appears at the bottom of the editor. Note that these views are data-driven views, unlike the Column Selector and Title views, which were deleted from the Compound Layout.

c. Click Done.

The Compound Layout should look like this when the Graph view is selected:

Do not save your changes to the analysis.

Create a new analysis by selecting New>Analysis on the global header, and then selecting Recruiting as the subject area.

On the Criteria tab, select the following columns:

Insert the LOD Region Filter

Click the Results tab. Two views Title and Table appear.

Add the Trellis view. Select New View>Trellis>Simple.

Scroll down to view the Trellis view.

Delete both the Title and Table views.

Save the analysis as My Trellis View, under the folder My Folders/LOD Analysis Folder

Click the Edit View pencil icon in the Trellis view at the Compound Layout. Note that the layout pane appears vertical.

Arrange the dimensions and measure as shown below:

Click Done.

The Trellis view appears. Save the analysis. Observe that the measure has the same scale for all the Categories.

This concludes the topic of creating a Simple Trellis view.

Click the Dashboards link on the global header and then click My Dashboard.

An empty My Dashboard page appears.

When you open a dashboard, including My Dashboard, the content appears on one or more dashboard tabbed pages. Pages contain the columns and sections that hold the content of a dashboard, and  every dashboard has at least one page. Multiple pages are used to organize content.

This example shows an empty My Dashboard page with no content. Hover over the Edit icon to edit the dashboard and add content.

Click the Edit icon () to add content to your empty dashboard page.

The Dashboard Builder appears and automatically creates page 1 of your dashboard (the first tabbed page).

Using the Dashboard Builder, you can add pages and objects to a dashboard and control the page layout. The Dashboard Builder is composed of the following:

• Dashboard Toolbar: The toolbar allows you to perform tasks such as adding or deleting pages, previewing, saving, and so on.
• Dashboard Objects pane: Items that are used only in a dashboard. Examples of dashboard objects are sections to hold content, action links, and embedded content that is displayed in a frame on a dashboard
• Catalog pane: Items that you or someone else has saved to the Catalog (for example, analyses, prompts, and so on). On a dashboard, the results of an analysis can be shown in various views, such as a table, graph, and gauge. (The results of an analysis are the output that is returned from the Oracle BI Server that matches the analysis criteria.) Users can examine and analyze results, save or print them, or download them to a spreadsheet.
• Page Layout pane: This is a workspace that holds your objects, which are displayed on the dashboard.

In the Dashboard Toolbar, the Tools toolbar button provides options to set dashboard properties, set page report links, and so on.

As mentioned above, the Dashboard Objects pane provides you with a list of objects to add as content to a dashboard page. You will have to drag the object to the Page Layout pane on the right.

• Columns are used to align content on a dashboard. (sections within columns hold the actual content.) You can create as many columns on a dashboard page as you need.
• Sections are used within columns to hold the content, such as action links, analyses, and so on. You can drag and drop as many sections as you need to a column.
• Alert Section is used to add a section in which you display Alerts from Agents, if any. ( Agents dynamically detect information-based problems and opportunities, determine the appropriate individuals to notify, and deliver information to them through a wide range of devices such as e-mail, dashboard alerts, and so on.) An Alert section is added by default to the first page of My Dashboard if you do not manually include one. You cannot disable the appearance of an Alert section on the first page of My Dashboard. You can add an Alert section to an additional dashboard page so that section will then appear on both dashboard pages.

Drag the Column object onto the Page Layout pane.

The Column object appears on the Page Layout pane.

a. In the Catalog pane, navigate to the folder where you saved your analyses.

b. Drag the Regional Applicants analysis to Column 1.

Regional Applicants appears in the column. Observe that a Section is automatically created for you. You can also drag an analysis directly onto an empty Layout Pane without first creating a column. The Dashboard Builder automatically creates the column for you. You can then add sections automatically to that column by dragging analyses below the existing sections.

c. Click the Save icon () to save the dashboard page and then click the Run icon .

My Dashboard appears with the selected analysis Regional Applicants.

Select New > Dashboard in the global header.

The New Dashboard dialog box appears.

a. Enter Applicant Metric in the name text box. Notice that you can also enter a description of your choice.

b. Navigate to your LOD Analysis Folder and select it as the Location. If you receive a warning message, click OK to close it.

c. Accept the default to Add content now. The New Dashboard dialog box should look like this:

Observe that a Dashboards subfolder was automatically created inside the LOD Analysis Folder.

d. Click OK. The Dashboard Builder appears.

a. Navigate to the Ace Submissions by Region analysis and drag it from the Catalog to the Page Layout pane.

b. Save and run the dashboard. The Applicant Metric dashboard appears.

a. Select Dashboards > My Dashboard.

b. Click the Page Options icon ( ) and select Edit Dashboard.

Give the existing tabbed page a more meaningful name.

Click the Tools button and select Dashboard Properties.

The Dashboard Properties dialog box appears.

From this dialog box, you can do the following:

• Change the Styles (Styles control how dashboards and results are formatted for display, such as the color of text and links, the font and size of text, the borders in tables, the colors and attributes of graphs, and so on)
• Add a description (Descriptions are displayed when Oracle BI Administrators use the Catalog Manager)
• Add hidden prompts, filters, and variables
• Specify the links that will display with analyses on a dashboard page
• Rename, hide, reorder, set permissions for, and delete dashboard pages

Select page 1 in the Dashboard Pages section. The Dashboard Page Control toolbar is enabled. Using the toolbar, you can do the following:

• Change the name of your dashboard page.
• Add a hidden prompt. Hidden prompts are used to set default values for all corresponding prompts on a dashboard page.
• Add permissions for the dashboard.
• Delete the selected page. Dashboard pages are permanently deleted.
• If more than one dashboard page is in this dashboard, the arrange order icons are enabled (up and down arrow icons).

a. Click Rename icon ( ).The Rename dialog box appears.

b. Enter Regional Applicants in the Name text box and click OK.

The Dashboard Properties dialog box reappears with the new dashboard page name.

a. Click the Edit icon for Dashboard Report Links to set the report links at the dashboard level. Report links can be set at the dashboard, dashboard page (click Page Options> Page Report Links), or analysis level (click the properties icon for the specific analysis within the Dashboard Builder and then select Report Links).

b. Select the check boxes as indicated in the image below:

c. Click OK and then click OK again to return to the Dashboard Builder.

The Dashboard Builder should look like this:

a. Click the Add Dashboard Page icon ( ). The Add Dashboard Page dialog box appears.

b. Name the dashboard page Applicant Metric and click OK.

In the Catalog pane, navigate to the Ace Submissions by Region analysis and drag it to the Page Layout pane on the right.

Edit the properties of the column.

a. Click the Column Properties icon.

The Column Properties dialog box appears.

Using the Column Properties dialog box, you can change the appearance of the cells, border, width, height, and so on. You can also apply a custom style sheet.

a. Select the drop-down list for Background Color within the Cell area and choose light green. Click OK, then click OK again to close the Column Properties dialog box.

b. Click Preview to preview the dashboard. After previewing close the Window.

Edit the properties of the section.

You use the Section Properties drop-down list to do numerous tasks:

When you have more than one analysis within the section, you can also align the analyses by using the vertical and horizontal alignment icons.

a. Click the Properties drop-down list for the section and select Condition.

The Section Condition dialog box appears.

You use conditions to determine the following:

• Whether sections and their content appear on the dashboard page
• Whether agents deliver their content and execute their actions
• Whether action links appear on dashboard pages.
  Conditions are evaluated based on a Boolean expression; in other words, the condition is either True or False.

b. Set a condition that determines whether the analysis appears on the dashboard.
Click the New Condition icon ( ). The New Condition dialog box appears. Select Analysis, to base the new condition, from the drop-down list.

Browse the Catalog and select the Ace Submissions by Region analysis.

a. In the "True If Row Count" drop-down list, select is greater than and enter 25 in the text box to the right.
The New Condition dialog box should look like this:

b. Click Test.

If previously your analysis returned less than 25 records this test should evaluate to False. Modify the condition, as necessary, to create a false evaluation.

c. Your results are verified. Click OK. To further verify your results, then click OK and click OK again to return to the Dashboard Builder.
Preview the dashboard page now.

The dashboard page is empty. All that appears within the dashboard page is the column color.

d. Close the Preview window. Click the Properties drop-down list for the section and select Condition. The Section Condition dialog box appears.
e. Click the More icon and select Remove Condition to remove the condition so that the section displays.

e. Click the OK.

You will rename the section.

a. Click Properties (within the section) > Rename. The Rename dialog box appears.

b. Enter Applicant Ace Percentage in the text box.

c. Click OK.

a. Click Properties (within the section) > Show Section Title.

b. Preview the dashboard page once again to see your changes.

c. Save the dashboard.

Override the default dashboard report links at the analysis level.

a. Click the Properties icon for the Customer Discounts by Region analysis, and select Report Links.

b. The Report Links dialog box appears.

c. Select the Customize radio button and then select all check boxes.

d. Click OK.

e. Save and run the dashboard page. You are now able to export and copy this analysis from the dashboard.

a. Edit the dashboard in the Dashboard Builder again and edit the Regional Applicants tabbed page.

b. Edit the section properties for the analysis and select Drill in Place. Drilling allows you to view additional levels of detail for the specific column. Drill in Place means that the current browser is refreshed with the new data. To return to the previous view, simply click the back button on your browser.

c. Save and run the dashboard page.

Ensure the Region - Name column is selected in the column selector. Drill down on Region - Name, for this example the drill was performed on Allentown. Choose any value available to you.

The Region's City - Name column appears.

Create a personal, customized view of your dashboard page. Saved customizations allow you to save and view dashboard pages in their current state with your most frequently used or favorite choices for items such as filters, prompts, column sorts, drills in analyses, and section expansion and collapse. By saving customizations, you do not need to make these choices manually each time you access the dashboard page.

a. Select Page Options > Save Current Customizations.

b. The Save Current Customization dialog box appears. Name your customization My City Submissions and click OK.

c. You can apply the saved customization to a dashboard page. Click Page Options > Apply Saved Customization > My City Submissions.

Create a named dashboard prompt for region.

Click New > Dashboard Prompt on the global header and then select the Recruiting subject area.

The Definition pane appears. The Definition pane allows you to add, organize, and manage a named prompt's columns.
You can use column prompts, image prompts (maps) and variable prompts.
The Definition table lets you view high-level information about the prompt's columns.
You can also use this table to select columns for editing or deleting, arrange the order in which the prompts appear to the user, or insert row or column breaks between prompt items.

The Display pane is a preview pane that allows you to view the prompt's layout and design.

a. In the Definition pane, click the New prompt icon (), and select Column Prompt.

b. Select Region - Name as the column for the prompt, and click OK.

c. The New Prompt: Region - Name dialog box appears.
The Prompt for Column field allows you to view information about the column that you selected as the prompt. This appears only for column prompts.

The Label text box allows you to enter a meaningful label that appears on the dashboard next to the prompt. Enter Select a Region: in the the Label text box (add a space following the colon). You can optionally enter a description.

d. Select the operator. Accept the default, which is "is equal to / is in." This field is only for column prompts.

e. The User Input field's drop-down list appears for column and variable prompts and provides you with the option to determine the User Input method for the user interface—in other words, the user will see one of the following: check boxes, radio buttons, a choice list, or a list box.
You use this item in conjunction with the Choice List Values item to specify which data values appear for selection.
For example, if you selected the User Input  method of Choice List and the Choice List Values item of  All Column Values, the user will select the prompt's data value from a list that contains all of the data values contained in the data source.

Accept the default, Choice List.

f. The Options section provides you with the opportunity to constrain values available for selection.
Click the plus sign to expand the Options section. Because you selected Choice List for the User Input field, you must now indicate those values.
Some of your choices include All Column Values, Specific Column Values (where you supply those values),
SQL Results (choose a list of values based on a SQL statement), and so on.

Accept the default, All Column Values.

g. The series of check boxes allows you to restrict the amount of data returned.
Select the Enable user to select multiple values, and Require user input check boxes.
Allowing multiple selection of values lets you choose more than one value (region, for example), and requiring input forces you to enter at least one value.
"Default selection" allows you to select an initial value, and "Set a variable" allows you to create a new variable that this column prompt will populate.
Accept the default, None, for both of these fields.

The New Prompt dialog box should look like this:

h. Click OK.

The prompt is added to the Definition pane.

Save the prompt in the LOD Analysis Folder as Region prompt.

Test the prompt.

Navigate to My Dashboard - Applicant Metric and open it in the Dashboard builder.
Recall that the "Ace Submissions by Region" analysis has a Narrative view associated with it that is specifically set to a predefined value. In this example, the value of Albany.
Use Page Options > Edit Dashboard to open the Dashboard builder. Navigate to select Region Prompt from the catalog pane.

Drag Region Prompt to Column 1, above the "Customer Discounts by Region" analysis.

Click the Region Prompt properties icon and select Scope > Page. Scope determines whether the prompt applies to the entire dashboard or just this page.

a. Save and run the dashboard. Initially, the filters for the analysis that you created earlier are assumed; that is, the analysis is filtered for Albany region, in this example.

b. Select a new region from your dashboard prompt. This example uses Calgary.

c. Click Apply. The region value changes for this page.

d. Observe the change in the region in the dashboard display:

You can try selecting other values in the prompt. Then click Apply to rerun the dashboard prompt.

a. In the Definition pane, click the New prompt icon (), and select Column Prompt.

b. Select Latest Year from the Requisition Datess folder, and click OK.

The prompt is added to the Definition table.

Save the prompt in the LOD Analysis Folder as My Prompt.

Select Page 1 row in the Definition table and click the pencil icon to edit the page properties.

In the Edit Page Settings dialog box, change Prompt Display to Place label above prompt. Deselect the Show Apply button and Show Reset button check boxes. The Edit Page Settings dialog box should look like this:

Click OK. Observe that the buttons have been removed from the Display section. Save the prompt.

Open My Dashboard and add a new page. Use Page Options > Edit Dashboard to open the Dashboard builder.

Click the Add Dashboard page icon.

In the Add Dashboard Page dialog box, enter Region Stats as the page name and click OK.

In the new page, drag My Prompt and My Region Stats from My Folders>LOD Analysis Folder, to the dasboard page.

Save My Dashboard and click Run. The dashboard appears.

Select 2009 as the year and click anywhere on the dashboard. The query runs immediately and returns with data for only 2009.

Select a region and click any where on the dashboard. . This example uses Aberdeen as the Region. The dashboard refreshes with Year as 2009 and Region as Aberdeen.

Select Page Options>Edit Dashboard. Click the Tools icon and select Prompts Buttons on Current Page>Apply Buttons>Show All Apply Buttons.

Click the Tools icon and select Prompts Buttons on Current Page>Reset Buttons>Show All Reset Buttons.

Save the dashboard and run it again. This time both the Apply and Reset buttons are displayed.

Create a new variable dashboard prompt that creates a Recruiter presentation variable.

a. Click New > Dashboard Prompt and select Recruiting as the subject area.

Click New > Variable Prompt.

The New Prompt dialog box appears.

a. Accept Presentation Variable as the default prompt type.

b. In the text box to the right of the drop-down list for the prompt type, enter VarRecruiter.

c. Enter Recruiter Name: in the Label text box.

d. Select Choice List for User Input.

e. Select All Column Values for Choice List Values.

The dialog box should look like this:

a. Click Select Column and, in the Select Column dialog box, select Requistion Logistics > Requisition Recruiter > Recruiter Name.

b. Click OK. The dialog box should look like this:

Expand the Options section.

Select Specific Value from the "Default selection" drop-down list.

Click the Select Values icon.

In the Select Values dialog box, select a recruiter and then, click OK. For this example we choose Jeff Adams.

The New Prompt dialog box should look like this:

Click OK. The newly created variable prompt is displayed in the prompts definition list.

Save the prompt as Recruiter Variable Prompt Variable Prompt in your LOD Analysis Folder.

Click the Preview icon () to preview the prompt.

Close the Preview window.

Create an analysis by selecting the following columns:

• Requisition Logistics > Requisition Primary Location > Country - Name
• Requisition Logistics > Requisition Primary Location > Region - Name
• Requisition Logistics > Requisition Recruiter > Recruiter Name
• Requisition Facts > Requisition Counts > # Requisitions Currently Sourcing

Add ascending column sorts in this sequence: Country - Name, Region - Name, and Recruiter Nameas shown below:

The Criteria tabbed page should look like this after adding the sorts:

Select the Results tabbed page.

Select New View > Other Views > Static Text.

Move the Static Text view above the Table view.

Click the Edit View icon on the Static Text view. The Static Text editor appears.

In the Static Text editor, reference the VarRecruiter variable. Enter the following syntax in the Static Text pane: This analysis is for the Recruiter @{VarRecruiter}.

The syntax for referencing a Presentation variable is as follows:

@{variables.variablename}[format]{defaultvalue} or @{scope.variables['variablename']}

Where:
variablename is the name of the presentation or request variable

format (optional) is a format mask dependent upon the data type of the variable, for example #, ##0, MM/DD/YY hh:mm:ss. (Note that the format is not applied to the default value.)

default value (optional) is a constant or variable reference, indicating a value to be used if the variable referenced by variablename is not populated
scope identifies the qualifiers for the variable. You need to specify the scope when a variable is used at multiple levels (analyses, dashboard pages, and dashboards) and you want to access a specific value. (If you do not specify the scope, then the order of precedence is analyses, dashboard pages, and dashboards.

Examples:
@{variables.MyFavoriteRegion}{EASTERN REGION}

or

@{dashboard.variables['MyFavoriteRegion']}

Observe that your entry is previewed below the Static Text text box. Click Done.

Save your analysis as Recruiter by Country and Region.

Your analysis should look like this:

a. Select the Criteria tabbed page.

b. In the Filters pane, click the Create a Filter icon and select "Requisition Recruiter"."Recruiter Name".

a. In the New Filter dialog box, click Add More Options and select Presentation Variable.

b. In the Variable Expr field, enter the variable name, VarRecruiter. Notice that you can also specify a default for the variable, but in this case the default is driven by the variable prompt, which is set to default to "Jeff Adams".

c. Click OK. The filter should look like this:

Select the Results tabbed page. Because the variable dashboard prompt has not been run, the VarRecruiter presentation variable has not been populated with a value. Because of this, no results from the analysis meet the filter requirement.

Save the analysis.

Add the analysis Recruiter by Country and Region and the newly created variable prompt to the Applicant Metric dashboard.

Open the dashboard Applicant Metric from the LOD Analysis Folder > Dashboards folder, then click Page Options > Edit Dashboard.

Add a new column next to Column 1, and then navigate to the Sales Reps by Region and Country analysis and drag it to the new column.

Navigate to Recruiter Variable Prompt in the catalog pane, and drag the prompt above the Recruiter by Country and Region analysis. Save the dashboard and run it.

The Dashboard view looks like this:

Click the Collapse icon for the first column to minimize it.

The dashboard runs and the variable dashboard prompt is preset to the default value, Adams, Jeff, which in turn appears in the Static Text view as expected and is used to filter the embedded analysis results. The value of a presentation variable is populated by the variable prompt. That is, each time you select a value in the variable prompt, the value of the presentation variable is set to that value.

Click the drop-down list for the dashboard prompt, and select a different recruiter. For this example we chose Keith Adams.

Click Apply. The dashboard displays the presentation variable as Adams, Keith.

This concludes the topic of Presentation Variables and Filters.

You will have to set the Delivery Options for the Oracle BI Account settings as Email. It is recommended to do this for an authoring user without row level security restrictions, and a report viewer user with row level security set.

For more information about row level security see the Oracle Taleo Reporting with Oracle Business Intelligence User Guide. If your company does not use row level security with reporting there will be no difference between running the report as the recipient or using the agent owner's credentials.

A System Profile is created automatically with the user's SmartOrg email, but we are going to set up an additional delivery profile.

In the Global Header, click the username, and then click My Account.

a. Click the Delivery Options tab and select Email from the Devices drop-down list.

b. Click the Add icon.

In the Create Device window, add details as shown in the following screenshot and click OK.

The Email Device is listed. Set the Email device you created as Default.

a. Click the Add icon for Delivery Profiles.

b. Enter details for the Delivery Profile as shown in the following screenshot. Click OK.

c.Set the Email Delivery Profile as Default. Both the Email Device and Delivery Profile are listed on the Delivery Options tab. Click OK.

Repeat steps 1-4 for the other user you will test, you may use the same email for both users.

Now create an agent to create and deliver the alert by using Oracle BI Delivers.

Click New in the Global Header and select Agent to navigate to the Agent Editor.

In the Agent Editor, start with the General tab to specify the priority of the agent and how to send the delivery content. Select the following options:

• Priority Normal
• Run As Recipient

Click the Schedule tab and verify that scheduling is enabled, Frequency is set to Once, and the Start date and time are set to the current date and time.

On the Condition tab, select the Use a condition option and click Create. The Create Condition dialog box appears.

a. In the Create Condition dialog box, select Analysis from the Create condition based on drop-down list and click Browse to select the analysis. In this example, you must choose the standard report Requisitions Filled Details.

b. Navigate to the Reports - Recruiting folder and select Requisitions Filled Details. Condition Data is displayed as the selected analysis. Now you also see the condition operator drop-down list.

c. Select is greater than from the True If Row Count operator drop-down list and enter 0 as the row count.

If your environment has a lot of filled requisitions you may want to set a date range on the Latest Filled Date filter. This step is optional.

d. Click Test to test the condition. The test result is displayed.

e. Click OK. If the result is false, you do not have enough data to return a result. You may alter the filter criteria, choose another analysis, or run the analysis knowing you will not get any results.

Click the Delivery Content tab to identify the content that will be delivered by the agent. Perform the steps given as follows:

• Enter a Subject.
• Select Analysis from the Content drop-down list and click Browse to select the analysis.
• Select Requisitions Filled Details from the Reports - Recruiting folder in Catalog.
• Verify that (Device default) is selected from the Format drop-down list.
• Select If Condition is False Deliver this message and input a delivery message. If this option is not selected than no email will be delivered to a recipient when the condition evaluates to false.
  
  

On the Recipients tab, select the default option to identify the recipients of the agent. By default, the agent creator is available.

Remember that you have set the delivery options for "My Account" in the BI EE Home as Email.

On the Recipients tab, add the report viewer as a recipient.

a. Click the add recipient button () to open the select user dialog.

b. Select Users as the list option

c. Enter the viewer's name in the Name search box.

d. Search for the user by clicking the search button.

e. Select the user and move him into the Selected Members column by using the move carrot.

f. click OK.

Now both the authoring user and the viewer user are listed as selected recipients.

On the Destinations tab, select the destination for the agent.

For User Destinations, select the Devices > Specific Devices and Email check boxes.

Click the Save button to save the agent. In the Save Agent dialog box, save the agent as Requisitions Filled Details in the LOD Analysis Folder.

Click the Run Agent Now button. Verify that the agent is running in the Running Agent dialog box:

When the agent has run successfully, you should receive a confirmation:

Click OK.

Verify that the agent ran successfully and generated and an email for the report author and the report viewer was received.

We will be modifying the Requisitions Filled Details agent for this exercise.

In the LOD Analysis Folder click edit under the Requisitions Filled Details agent.

Click the General tab and select Use Agent Owner's Credentials from the Run As selections.

Since the system will not be able to recognize an email as a recipient you must select this option for any agents that will be delivered to specified emails instead of, or in addition to, system users.

Click the Delivery Content tab and in the Format dropdown, select CSV Format.

Deliver As Attachment is automatically selected for this format type.

a. In the Recipients Tab clear all selected recipients and click the Add Email Recipents icon.

b. In the Enter Email Address dialog, enter email list including your email, and the email of colleagues who don't mind confirming receipt (separate multiple addresses with commas), as shown in the following screenshot. Click OK.

The recipients image should look like the following image, with your list of emails displayed.

Click Save As and save the agent as Requisitions Filled Details - run as user in the LOD Analysis Folder.

Manually run the agent using the Run Agent Now icon.

Verify the agent ran successfully by waiting for the Agent Successful message.