Ad Hoc Reporting

Drag and drop fields to quickly retrieve data for analysis without the need of creating a report. Ad Hoc Reporting offers features such as:

  1. Convenient drag and drop functionality to create “reports”
  2. Grouping and sorting functionality
  3. Filtering capabilities
  4. Export to Excel functionality

Security, as configured in the Administration screens, is inherited ensuring users see only the data you have been assigned.

General Usage

Ad Hoc Reporting allows users to create a report referencing the data they are most interested in. Save this report so it can be ran on another day.

Ad Hoc has the following highlighted features

  1. Accessing Ad Hoc is a permission that can be granted by an Administrator.
  2. Data Access security as setup in the Administration screen is inheritted
  3. Ad Hoc reports are yours. The ability to share Ad Hoc reports with other users is currently not available.

Ad Hoc has the following key screen features.

Number Feature Description
1 Options

  • Gear Icon
  • Help Icon
  • Full screen Icon
  • Click the gear icon to view Ad Hoc settings. This includes the number of rows being displayed in the Ad Hoc report and when to refresh the screen.
    • Keep in mind that the more data you bring into your Ad Hoc report, you may need to adjust these settings for an optimal user experience.
  • Help Icon: click this icon to be taken through a quick application walk thru
  • Full Screen: click this icon to enter full screen mode.
2

Options

  • module selector
  • Fields and filters

For organzations with more than just the General Ledger, click the dropdown arrow to switch to a different module

Choose the fields that should appear as columns in your Ad Hoc report by selecting the checkbox icon. 

Choose the filters of the report by selecting the filter icon. Filters can be defined in the filter grid (3)

3 Filter Grid

A list of all fields that have been selected as a filter.

By default, for the Period dimension, this year this period is selected. Click this text to display a selector to choose different period options

For dimensions, by default all dimension codes will come in. Click the text to display a selector to choose specific dimension values. 

4 Data Grid

Upon Clicking Refresh (bottom corner of the data grid), your Ad Hoc report will process and once complete, data will appear in this grid. 

Click a column header to sort

5 Groupings Drag column headers from your report into this section to create groupings of data. Typical use cases may include dragging Department into this section to group by Deparment
6

Actions

  • Create a name for the report
  • save
  • Export
  • Pivot
  • Should you want to save your Ad Hoc report for future use, type a descriptive name here in this box
  • Save: click this button to save the report for future use
  • Export: click this button to export the currently shown data to excel
  • Pivot: click this option to create a pivot view of your currently displayed data

Using Ad Hoc for the first time or with no saved Ad Hoc reports, users are directed to the Get Started screen. Click on “Get Started” to begin. For customers who have

  • Only the Data Warehouse, Ad Hoc will begin loading the interface. This may take a couple seconds to load
  • The Data Warehouse and connections made to an on premises ERP system, you will be prompted to select an integration and company
  • Click Ok

If you have saved any Ad Hoc reports, upon clicking Ad Hoc Reporting, a listing of all previously save reports will appear.

Ad Hoc will load. There are three areas that make up the screen.

The grid to the far right displays the factsets of the currently selected module.

Expand on the factset to display the dimensions you would like to bring into the report.

  • Period is a filter by default. Reference the blue filter icon. A default filter for “This peirod this year” has been applied and can bee seen in the middle grid.
  • Period is not a column that will appear in your composer report because the checkbox is not selected. Check the checkbox to make Period appear in your report.
  • Clck the checkboxes for other dimensions and attributes you would like to see in your report. Click the filter icon to make it a value you can filter on.

Once all fields are selected click Refresh in the bottom right hand corner of the data grid.


Refresh button becomes active (blue) based off a change being made to the selected fields and/or filters. If it is greyed out, there have been no changes made.

If data does not load or is not what you are expecting, check your filters and make sure the correct filters are applied.