9.2 Run the BCS_SEC_SACR Report

Purpose:  Use this document as a reference for running the BSC_SEC_SACR report.

Audience: Campus Community.

You must have at least one of these local college managed security roles:

  • ZD_DS_QUERY_VIEWER

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

For additional information about reporting solutions, visit the Report Catalog.

Navigation:  NavBar > Navigator > Reporting Tools > Bi Publisher > Query Report Scheduler

  1. The Query Report Scheduler search page displays.
  2. Select the Add a New Value tab. Select the Add a New Value tab to create a new Run Control ID and select AddIt is important to note that Run Control IDs cannot be deleted; therefore, we encourage them to be reused. Because of this, including your institution code and a short process description in the Run Control ID  is recommended. This only has to be done once.
The image displays the search crtiteria page
  1. To use an existing Run Control ID, click on the Find an Existing Value tab and select Search.
  2. Existing Run Control ID(s) displays below.
  3. Click on the appropriate Run Control ID.
The image displays the Find and Exisitng Value page
  1. Select Connected Query from the Data Source Type drop-down list in the Report Definition section.
  2. In the Report Name field, enter or look up BCS_SEC_SACR.
  3. Prompts appear for Query CQCS_SEC_SACR_CORE_COMPARE_CP
  4. Enter or look up the Institution.
  5. In the User1 field, enter the employee's EMPLID.
  6. Select OK.
The image highlights the query prompt fields
  1. The Query Report Scheduler page displays with the Query Parameters section populated.
    • Select the Update Parameters link and enter new values to modify prompt criteria.
  2. Select Run.
The image highlights the query parameters and update parameters link
  1. The Process Scheduler Request page displays. Select OK. (Note: Click on the Distribution link to ensure the ID Type = User, and your EMPLID is in the Distribution ID field).
The image displays the Process Scheduler Request page
  1. The Query Report Scheduler page displays.
  2. Select the Process Monitor link.
The image highlights the Process Monitor page
  1. The Query Report Scheduler page displays. Select the Report Manager link.
THe image promts to select the Report Manager link
  1. Select the Report name BCS_SEC_SACR.xlsx link.
The image displays the Report Manager page prompting to select the link.
  1. Select the BCS_SEC_SACR.xlsx link in the File List section.
The file List section displays and highlights selecting the link.
  1. Save the .xlsx file to your computer.
The Security Administration Security Report page displays
  1. Process complete.

2 Comments

Derreck Pressley

Hello,

I have the required security roles, but I am not able to find the BCS_SEC_SACR query in BI Publisher?

Tanjagay Martin

Hi Derreck, Your question is greatly appreciated; thank you. On the Query Report Scheduler page (ensure the Data Source Type is Connected Query), select the Report Name looking glass--BCS_SEC_SACR is located between "BCS_HCFNDETH" and "BCS_SF_ESSER." Thanks for taking the time to read this. ~Tanjagay Martin | CS Core Trainer

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.