Advanced Reporting groups data into a schema that provides for quick and simple querying, yet it is flexible enough to support more complex reporting requirements.
Advanced Reporting consists of categories, tables, and columns:
- Categories consist of tables and columns grouped around a particular subject or concept - for example, employment, compensation, and person. A category is selected from the upper-left dropdown list on the Query Designer.
- Tables can be blocks, sections within blocks, Foundation Objects, or Metadata Framework Objects. Tables are identified by a > , which helps you expand and view all the columns under it. Choose the arrow to the right to continue navigating to related tables.
- Columns are fields or cells contained within the table.
The menu bar contains the following buttons. Many of these buttons are described in more detail later in the lesson.
- New Query – Not used
- Open Query - Not used
- Save Query – Save the current query
- Save Query As - Not used
- Cancel Query Changes - Revert to the last save
- Manage Query Filter – Open query filter designer
- Manage Runtime Filters – Open runtime filter designer
- Person Context – Open person context selector
- Date Options – Open date options
- Sort Columns – Open column sorting
- Calculated Columns – Open calculated columns designer
- Pivot Query Designer – Not used
- Module Configuration – Open module configuration
- Change Reporting Column – Open change reporting configuration
Hint
Note
Note
Searching
Searching will produce a list of potential matches and the category and object the column is found in the following:
Category Selection, Object and Column Listing
Alternatively, a user can navigate the category listing using the dropdown selection box.
Selecting a category from here will display a list of objects and columns available for that category.
Opening objects and expanding objects will display other objects that relate to the "parent" object, as pictured in this screenshot below.
