• 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 (optional)
  • 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 (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)

  If you are using report_date periods, 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.

  • Possible Values: true or false
  • Default Value: true
• 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: 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 select one, many, or all assets in the filter criteria.
• Control Type: Multi-select
• BCS Parameter: asset_list
  • Possible Values: CSV list of <knowledgeCenter_asset_id> values
  • Default Value: All available

• 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 specify user statuses.
• Control Type: Multi-select
• BCS Parameter: user_status
  • Possible Values: 1 (activated), 2 (deactivated)
  • Default Value: Activated

• 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 roll up the activity of members of subgroups into higher-level group summary fields.
• Control Type: Single-select check box
• BCS Parameter: rollup_members_of_subgroups
  • Possible Values: 0 (don’t roll up), 1 (roll up)
  • Default Value: Don't roll up

• Description: Used to determine how records that contain field(s) that could have multiple values (such as a user that exists in multiple groups) present or stored the data in the report. If multiple rows are selected, a record will be provided for every instance.
• Control Type: Single-select
• BCS Parameter: show_multiple_groups
  • Possible Values: 1 (multiple rows), 2 (single row)
  • Default Value: Multiple rows

• Description: The title of the KnowledgeCenter.
• BCS Value: kc_title

• Description: User's login name.
• BCS Value: skillport_username

• Description: The total number of accesses to the Skillsoft Advantage Track, by this user, in the specified date range.
• BCS Value: count_of_kc_launches

• 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: sum_of_durations_via_kc_by_user

• Description: The total number of accesses to any asset in the track, by this user, within the specified date range.
• BCS Value: count_of_launches_via_kc_by_user

• Description: The total number of access to any asset of the specified type during the time period by users matching the filters.
• BCS Value: count_of_launches_of_books_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_courses_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_custom_category_via_kc

• Description: The user's first name.
• BCS Value: user_first_name

• Description: The organization code associated with the group.
• BCS Value: group_orgcode

• Description: Total number of accesses to any asset of the specified type during the time period by users matching the filters.
• BCS Value: count_of_launches_of_ilt_via_kc

• Description: The ID of the KnowledgeCenter.
• BCS Value: kc_name

• Description: The user's last name.
• BCS Value: user_last_name

• Description: Total number of accesses to any asset of the specified type during the time period by users matching the filters.
• BCS Value: count_of_launches_of_learning_portals_via_kc

• Description: Total number of accesses to any asset of the specified type during the time period by users matching the filters.
• BCS Value: count_of_launches_of_resources_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.

• Description: The first name of the approval manager.
• BCS Value: cud_approval_manager_first_name

• Description: The ID of the approval manager.
• BCS Value: cud_approval_manager_Skillport_name

• Description: The last name of the approval manager.
• BCS Value: cud_approval_manager_last_name

• Description: The user's first name as it appears in Skillport.
• BCS Value: cud_display_first_name

• Description: The user's last name as it appear in Skillport.
• BCS Value: cud_display_last_name

• Description: The email address of the user.
• BCS Value: cud_user_email

• Description: The name of the group.
• BCS Value: group_title

• Description: The path to the group's location based on the hierarchy configured in Skillport.
• BCS Value: group_path

• Description: The user's geographic location (for example, where the user's office or branch is located).
• BCS Value: cud_location

• Description: The user's SkillPort role: Super Administrator, Company Administrator, Company Administrator-Custom, Administrator, Administrator-Custom, Manager, Manager-Custom, and End-User.
• BCS Value: user_role

• Description: The user's status: Activated, Deactivated, or Pending.
• BCS Value: user_status