• Description: Provides the ability to select one, or many assets.

  Note: The maximum number of assets selected for each report cannot exceed 1000.

• Control Type: Multi-select list
• BCS Parameter: asset_list
  • Possible Values: CSV list of <any_asset_id> values
  • Default Value: All available

• Description: Provides the ability to select all or specific asset categories and sub-categories.
  • Categories and sub-categories can be selected independently of each other.
  • Selecting an asset category will include all sub-categories for that value.
  • You can also select sub-categories individually.
• Control Type: Multi-select
• BCS Parameter: asset_category
  • Possible Values: 2 (Courses), 3 (Custom Content), 4 (Instructor Led Training), 6 (Resources)
  • Default Value: All available
• BCS Parameter: asset_subcategory
  • Possible Values: See the tables below for a list of sub-categories available for each category. There is no sub-category for the Instructor Led Training category.

• Description: Allows the user to select one event and then filter that event by date.
• Control Type: Single-select
• BCS Parameter: date_filter_field
  • Possible Values: first_access_date, last_access_date, completion_date

Static Dates

To enter static dates, use the following parameters with a specific date for the filter_start_date and filter_end_date parameters:

• BCS Parameter: filter_start_date (optional)
  • Possible Values: <date_value in the format MM/DD/YYYY>
  • Default Value: the first day of the preceding calendar month
• BCS Parameter: filter_end_date (optional)
  • Possible Values: <date_value in the format MM/DD/YYYY>
  • Default Value: 'now', or the last successful database refresh

    Note: Default start and end dates will only be used if a date_filter_field value is entered and the date values are left blank. In this instance, the date values are dynamic and will update each time the report is run.

Dynamic Dates

For dynamic dates that change each time the report is run, use the following parameters:

• BCS Parameter: filter_date_period (required)
  • Possible Values: 1 (Days), 2 (Weeks), 3 (Months), 4 (Years)
  • Default Value: 3
• BCS Parameter: filter_date_period_count (required)
  • Possible Values: valid numeric value with the following maximum value for each report_date_period:

    Days - 9999

    Weeks - 999

    Months - 999

    Years - 99

  • Default Value: 1

Filter to Date

If you are using filter_date periods, filter_to_date=true will include all activity for the requested periods plus activity in the current period up to the current date and time. If filter_to_date=false, the report will only include activity for the requested periods.

• BCS Parameter: filter_to_date (optional)
  • Possible Values: true or false
  • Default Value: true
• Example:
  • If filter_to_date = true, the end date is always the date the report is run, up to and including the most recent database refresh.
  • If filter_to_date = false, the end date is the last day of the previous interval. For instance, if today is December 31, the ‘Previous [n] Months’ ends on November 30 and the ‘Previous [n] Years’ ends on December 31 of the prior year.

• Description: Allows the user to determine the date range and display units for all activity for the report.
• Control Type: Multi-option

To use this control, set the Display Units to the desired value. Then determine the length of time included in the results by setting either the Previous option or the From / To dates. Make sure the length of time included in the results does not exceed the value determined by the Display Units option. For more information, see Modify Chart Activity Dates.

Display Units

The display_units value available in all charts impacts the length of time that can be included in the report results. The length of time included in the results is determined by the report_date_period and the report_date_period_count values, or the report_start_date and report_end_date. For each display_unit, there is a maximum amount of time that can be included in the results.

The following list depicts the maximum length of time that can be included in the results for each Display Unit:

• Days - 16
• Weeks - 16
• Months - 12
• Quarters - 12
• Years - 4

Use the following parameter to set the display units:

• BCS Parameter: display_units
  • Possible Values: 1 (Year), 2 (Quarter), 3 (Months), 4 (Weeks), 5 (Days)
  • Default Value: 3

Previous Option

Use the following parameters to determine the number of previous intervals, such as, "previous 3 months." Ensure the combined value for these parameters does not exceed the maximum length of time set by the display_unit limits.

• BCS Parameter: report_date_period (required if using this option)
  • Possible Values: 1 (Days), 2 (Weeks), 3 (Months), 4 (Years)
  • Default Value: 3
• BCS Parameter: report_date_period_count (required if using this option)
  • Possible Values: Any numeric value that, when combined with the report_date_period value, does not exceed the maximum length of time for the selected display_unit.
  • Default Value: 3

To Date Option

• This option is only available if you are using the Previous option. Setting report_to_date=true will include all activity for the requested periods plus activity in the current period up to the current date and time.  If report_to_date=false, the report will only include activity for the requested periods.
• Example:
  • If report_to_date = true, the end date is always the date the report is run, up to and including the most recent database refresh.
  • If report_to_date = false, the end date is the last day of the previous interval. For instance, if today is December 31, the ‘Previous [n] Months’ ends on November 30 and the ‘Previous [n] Years’ ends on December 31 of the prior year.
• BCS Parameter: report_to_date (optional)
  • Possible Values: true or false
  • Default Value: true

Start and End Dates (From / To Option)

Use the following parameters to set start and end dates. The length of time returned by the dates cannot exceed the maximum length of time for the selected display_unit.

• BCS Parameter: report_start_date (required if using this option)
  • Possible Values: <date_value in the format MM/DD/YYYY>
  • Default Value: the first day of the preceding calendar month
• BCS Parameter: report_end_date (required if using this option)
  • Possible Values: <date_value in the format MM/DD/YYYY>
  • Default Value: 'now', or the last successful database refresh

• Description: Provides the ability to include subgroups within the scope of the report.
• Control Type: Single-select check box
• BCS Parameter: select_subgroups
  • Possible Values: 0 (don’t select), 1 (select)
  • Default Value: Don't select

• Description: Provides the ability to select one, or many users or groups.

  Note: The maximum number of users or groups selected for each report cannot exceed 1000.

• Control Type: Multi-select
• BCS Parameter: user_list
  • Possible Values: CSV list of <username> values
  • Default Value: All
• BCS Parameter: group_list
  • Possible Values: CSV list of <group_orgcode> values
  • Default Value: All

    Note: In some templates the Group or the User filter may not be available. For instance, if the report is group specific then the user filter may be disabled.

• Description:  Provides the ability to filter data based on user profile fields that have been configured and enabled on the User Profile page.
• Control Type:  Logical filter
• BCS Parameter: N/A

• Description: Provides the ability to specify user statuses.
• Control Type: Multi-select
• BCS Parameter: user_status
  • Possible Values: 1 (activated), 2 (deactivated)
  • Default Value: Activated

• Description: The total cumulative duration for all launches in the specified date range for assets for which duration is tracked. Displayed in hh:mm format for Previewed reports, and reports exported to PDF and HTML. Displayed in minutes for reports exported to CSV and Excel.

  Note: Duration for passive assets such as Word or PDF documents is not tracked.

• BCS Value: accumulated_duration_for_all_assets