• Description: Provides the ability to select one, many, or all assets in the filter criteria.
• 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.
• Control Type: Multi-select
• BCS Parameter: asset_category
  • Possible Values: 2 (Course), 3 (Custom Content), 16 (Practice Labs), 17 (Projects), 18 (Simulations), 20 (TestPrep Exams)
  • Default Value: All available

• Description: Provides the ability to display units in days, weeks, months, quarters, or years.
• Control Type: Single-select
• BCS Parameter: display_units
  • Possible Values: 1 (Years), 2 (Quarters), 3 (Months), 4 (Weeks), 5 (Days)
  • Default Value: Months

• 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

Dynamic Dates

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

• BCS Parameter: filter_start_date
  • Possible Values: <date_value in the format MM/DD/YYYY>
  • Default Value: one month prior to the date the report is run
• 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.

Static Dates

For static dates, 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

The filter_to_date parameter allows you to include all activity up to the current date and time, regardless of the report_date_period chosen.

• BCS Parameter: filter_to_date (optional)
  • Possible Values: true or false
  • Default Value: true

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

Use the following parameters to set start and end dates.

• BCS Parameter: report_start_date (required)
  • Possible Values: <date_value in the format MM/DD/YYYY>
  • Default Value: one month prior to the date the report is run
• BCS Parameter: report_end_date (optional)
  • Possible Values: <date_value in the format MM/DD/YYYY>
  • Default Value: 'now', or the last successful database refresh

Use the following parameters to set dates for a number of previous intervals, such as, "previous 3 months."

• BCS Parameter: report_date_period (required)
  • Possible Values: 1 (Days), 2 (Weeks), 3 (Months), 4 (Years)
  • Default Value: 3
• BCS Parameter: report_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
• BCS Parameter: report_to_date (optional)

  The report_to_date setting allows you to include all activity up to the current date and time, regardless of the report_date_period chosen.

  • Possible Values: true or false
  • Default Value: true
• BCS Parameter: display_units (optional and used in chart templates only)
  • Possible Values: 1 (Year), 2 (Quarter), 3 (Months), 4 (Weeks), 5 (Days)
  • Default Value: 3

• 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, many, or all users or groups as part of the filter criteria.
• 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: You cannot specify User Profile filters when running this report via BCS.

• 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.
• BCS Value: accumulated_duration_for_all_assets