![]() |
|||||||||||||||||||||||||||||||
![]() |
![]() |
|
![]() |
||
![]() |
Tutorial1. Getting StartedFrom the Hiring and Staffing Activities home page side bar there are 3 cubes from which you can extract data
If you select Staffing Activities; this is the table that will appear by default. If selecting a different cube, the procedures will be the same. 2. Edit options TabTo customize your report you need to click on the Edit Options tab
3. Query OptionFrom the Edit Options tab, the first option you should select to customize your report is the Query option You can modify the query by performing the following tasks and actions in the Query pane Add data items: Select a data item in the Available items pane, and then click Specify where you want the new data item to be added by selecting one of the following: to Rows: adds the data item to the vertical axis. to Columns: adds the data item to the horizontal axis Note: To be able to have access to the option Percent of Total in the Edit Options pane, you need to select the available item Total at the beginning of your query and to add it to the columns. Reorder selected data items: Select a data item in the Selected Items pane, and then click Remove selected data items: Select a data item in the Selected Items pane, and then click When you are finished making changes to the query, click OK to apply the query to your current view. To cancel any query changes that have not been applied yet, click Cancel Note: For a query to be valid, the rows and the columns must each contain at least one data item.
4. Filter OptionYou can subset the data by Using the Filters Option Note: you can only filter on the selected data items. To subset data using filters, follow these steps from the filter pane
Select a condition for the Filter from this pane: Is equal to specifies that a matching value must match the filter value exactly. You can select one or more values. Is not equal to specifies that a matching value must not match the filter value exactly. You can select one or more values. Click OK to apply the filter to your data view. The new filter will appear in the Filter Expression viewer.
5. Totals OptionTo have subtotals and total for rows and columns, select the Totals option
6. Percent of Total OptionNote: To be able to have access to the option Percent of Total in the edit options pane, you need to select the available item "Total" at the beginning of your query and to add it to the columns option. To add the percents to your table, select the Percent of Total option From the Percent of Total pane, you can add percents to your table by performing the following tasks and actions. It is recommended that before you select this option, select the Totals option to add the totals to rows and columns From the Show percent of option, you can select :
The Label option allows you to give a name to the column or row that you created, e.g.
Click Add. Your percent will be added to the bottom pane. To activate it, you highlight the label created in the pane. Click OK. You can also remove the percent by highlighting the label that you created and click Remove. You can create more than one percent
7. Scrolling Option
8. Exporting Your Table as an Excel FileTo save a table in Microsoft Excel format,, you need to click on the Export To tab Output type:
Include:
Format:
Options:
Note:
9. Sort rows dataClick on the row heading (Staffing Activities) to obtain options Select the Sort Rows Data option
10. Sorts Columns DataClick on the column heading (Fiscal Year) to obtain options Select the Sort Columns Data option
11. Rotate table - ROWSClick on the row heading (Staffing Activities) to obtain options Select the Rotate Table Option Rotate table - Columns Click on the column heading (Fiscal Year) to obtain options Select the Rotate Table Option
12. Other options and tipsView (side bar):
Printer Friendly (side bar):
Percent of Total Option:
Fiscal Year:
|