• 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 select one, many, or all assets in the filter criteria.
• Control Type: Multi-select
• BCS Parameter: asset_list
  • Possible Values: CSV list of <book_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: 1 (book), 21 (videos)
  • Default Value: All available
• BCS Parameter: asset_subcategory
  • Possible Values: 0 (chapter), 1 (journal), 2 (reference suite), 3 (execsummary), 4 (execblueprint), 5 (journal style toc), 6 (analyst perspective), 7 (review), 8 (video), 9 (recorded session), 10 (newsletter)
  • Default Value: All available

• Description: Provides the ability to select Books24x7 collections to include in the report.
• Control Type: Multi-select
• BCS Parameter: collection_list
  • Possible Values: CSV list of <collection_id> values
  • Default Value: All available

• Description: Provides the ability to specify a seat status.
• Control Type: Single-select
• BCS Parameter: seat_status
  • Possible Values: 0 (deleted), 1 (occupied)
  • Default Value: All

• Description: Provides the ability to specify a Books24x7 subscription ID for a list of all subscriptions associated with the SkillPort site.
• Control Type: Single-select
• BCS Parameter: subscription_id
  • Possible Values: <books_subscription_id>
  • Default Value: Company subscription id

• Description: Provides the ability to filter on one or two fields that exist in the report definition. You can define either an AND or an OR statement when using two filters. The field selector drop-down will include all fields that are available in the report definition.
• Control Type: Logical filter
• BCS Parameter: you cannot specify custom filters when running this report via BCS

• Description: Allows the user to select one event and then filter that event by date.
• Control Type: Multi-option
• BCS Parameter: date_filter_field
  • Possible Values: first_access_date, last_access_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: 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: You cannot specify User Profile filters when running this report via BCS.

• Description: Provides the ability to include assets with no activity.
• Control Type: Single-select check box
• BCS Parameter: show_assets_with_no_activity
  • Possible Values: 0 (don’t show), 1 (show)
  • Default Value: Don't show

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

• Description: The title of the collection, for example, ITPro or BusinessPro.
• BCS Value: collection_title

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

• Description: The type of the asset.
• BCS Value: asset_category

• Description: The ID of the learning asset, for example, COMM0101.
• BCS Value: asset_name

• Description: The total number of times that a book or video was viewed by all users.
• BCS Value: count_of_asset_session_launches

• Description: The number of Chapters to Go files downloaded by the specified user during the specified time range.
• BCS Value: count_of_chapter_to_go_downloads

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

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

• Description: The number of page views during the specified time range.
• BCS Value: count_of_pages_viewed

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

• Description: The number of downloads by the specified user during the specified time range.

• Description: The number of video files launched by users in the subscription(s) during the specified time range. Applies to subscriptions that include LDC only.
• BCS Value: count_of_video_launches

• Description: The description of the asset.
• BCS Value: asset_description

• Description: The copyright date of the asset.
• BCS Value: b24x7_copyright_date

• Description: The expected duration of the asset. 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: asset_expected_duration

• Description: The expiration date of the video asset.
• BCS Value: b24x7_expire_date

• 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 ISBN for the title. For assets that do not have ISBN numbers, such as videos, this value is blank.
• BCS Value: b24x7_ISBN

• Description: The publisher or producer of the asset.
• BCS Value: b24x7_publisher_or_producer

• Description: The date that the video was published to the SkillPort site.
• BCS Value: b24x7_site_published_date

• Description: The speaker in the video asset.
• BCS Value: b24x7_speaker

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