Manage Reports for Warehouse Analytics

Document created by RSA Information Design and Development on Sep 11, 2017Last modified by RSA Information Design and Development on Oct 16, 2017
Version 4Show Document
  • View in full screen mode
 

Note: Warehouse Analytics is not supported in Netwitness Suite 11.0 release.

Manage Warehouse Analytics reports by editing or deleting Warehouse Analytics jobs. You can also enable or disable scheduled jobs.

Edit Warehouse Analytics Jobs

Note: ETL job names are Read-only and cannot be edited.

For more information, see Job Definition View

  1. In the main menu, click Monitor > Reports.
    The Manage tab is displayed.
  2. Click Warehouse Analytics.
    The Warehouse Analytics view is displayed.
    Warehousre Analytics View in Reports
  3. In the Warehouse Analytics list panel, select a job and click .
    The Job Builder screen is displayed.
  4. (Optional) Modify the job Name.
  5. (Optional) From the Warehouse drop down list, select the data source created on the Reporting Engine configuration page. (For example, Horton Works or MapR).
  6. From the On drop down list, select the type of run schedule, Past or Range (specific), for that time range.

    Note: While scheduling a job, if you select Past option or Range (specific) option close to the current time, you must ensure that the aggregate data in the data source is returned. If there is an aggregation delay in the data source, the end time you choose must account for the delay, otherwise jobs lose non-aggregated data for that time range.

  7. (Optional) In the Advanced Options field, do the following:

    • In the Model Params field, enter a column name and select the column value from the List Selection window.
    • In the HDFS Params field, enter a column name and value.
    • In the MapReduce Params field, enter a column name and value.
    • In the SandBox JVM Params field, enter a column name and value.

      Note: To run a Warehouse Analytics job on Horton Works, you will be required to add the parameter fs.DefaultFS to the job. To add this parameter, add a JVM Parameter - Dfs.defaultFS , where the value for this parameter depends on the cluster configuration. For example, if you run the Warehouse Analytics jobs on an HDP Sandbox, the parameter value is defined as hdfs://sandbox.hortonworks.com. This value is usually set by the Cluster Administrator.

  8. Click Save.

    A confirmation message that the job is saved successfully is displayed.

Delete Warehouse Analytics Jobs

Note: ETL jobs cannot be deleted.

  1. In the main menu, click Monitor > Reports.

    The Manage tab is displayed.

  2. Click Warehouse Analytics.
    The Warehouse Analytics view is displayed.
    Warehousre Analytics View in Reports

  3. In the Warehouse Analytics list panel , do one of the following:

    • Select the jobs and clickDelete Icon.
    • In the Actions column, click Action Icon  > Delete.

      A confirmation dialog is displayed.

      Confirmation Dialog for deleting a job

  4. Click Yes to delete the job.

    A confirmation message that the job is deleted successfully is displayed.

Enable or Disable Scheduled Jobs

  1. In the main menu, click Monitor > Reports.

    The Manage tab is displayed.

  2. Click Warehouse Analytics.

    The Warehouse Analytics view is displayed.
    Warehousre Analytics View in Reports

  3. In the Warehouse Analytics list panel, select a job and do either of the following:

    • Click Action IconEnable.

      The state of the job is changed to Running, if the report is scheduled to run immediately.

    • Click Action IconDisable.

      The state of the report is changed to Inactive.

Refresh Jobs List

  1. In the main menu, click Monitor > Reports.
    The Manage tab is displayed.
  2. Click Warehouse Analytics.
    The Warehouse Analytics view is displayed.

    Warehousre Analytics View in Reports

  3. In the Warehouse Analytics List panel, drag and drop the jobs.
    The jobs are moved to the new location.
  4. Do the following to refresh a jobs list:
    • In the Warehouse Analytics toolbar, select Auto Refresh.
      The jobs list is automatically refreshed.
    • In the Warehouse Analytics List panel, click Refresh Icon.
      The jobs list is refreshed immediately.

Set Access Control for Warehouse Analytics Jobs

After you create Warehouse Analytics jobs, you can set up access and permissions to manage the jobs. You can change the job permissions using the Job Permission panel, you must select a job and set user access permissions.

Jobs are assigned to a specific set of user roles. When users log into NetWitness Suite, they can access only to the jobs to which they belong. Users who belong to a user role with the Read & Write access permission have full access rights on the job. Further, the access can be strengthened so that jobs are accessed only by those who have the Read Only access.

Except for Administrators, the default permission set for all the other user roles is No Access before applying job permissions.

The following figure shows the Jobs Permission panel.

 

                           
ColumnDescription
RolesDescribes roles of the users logged into the NetWitness Suite user interface.
Read & WriteAllows users to access, view, edit and delete Warehouse Analytics jobs on the Warehouse Analytics View. Users can also change the permission for the jobs.
Read OnlyAllows users to only access and view the jobs on Warehouse Analytics View.
No AccessDoesn't allow users to access or view jobs.

 

Access Control for Warehouse Analytics Jobs

Users will have access permissions depending on the user role. For more information, see (Optional) Adding Roles and Assigning Permissions for the Roles.

Note: Ensure that you have a Read & Write access permission to set up the access for a Warehouse Analytics job.

  1. In the main menu, select Monitor> Reports.

    The Manage tab is displayed.

  2. Click Warehouse Analytics.

    The Warehouse Analytics view is displayed.

    Warehousre Analytics View in Reports

  3. Select a job and click .

    The Jobs Permission dialog is displayed.

    Job Permission Dialog

  4. Based on the user role, select the appropriate radio buttons.
  5. Click Save.

    A confirmation message that the permission is successfully set for the selected job is displayed.

    Access Control for Multiple Jobs

    To change permissions of multiple jobs, you can select multiple jobs at a time and set their access permissions on the Jobs Permission panel.

    Job Permission View with multiple Jobs selected

    Test Scheduled Jobs

    1. In the main menu, click Monitor > Reports.

      The Manage tab is displayed.

    2. Click Warehouse Analytics.
      The Warehouse Analytics view is displayed.
      Warehousre Analytics View in Reports

    3. In the Warehouse Analytics List Panel, select a job and click Action Icon > Test.

      The Test Job Configuration page is displayed.

      Note: The Name field displays the name of the job being tested and is Read-only.

    4. (Optional) From the Warehouse drop down list, select the data source created in the Reporting Engine configuration page. (For example, Horton Works or MapR).
    5. From the On drop down list, select the type of run schedule:

      • Past- Select the number of days.
      • Range (specific)- Select the date and time in the From and To.
    6. (Optional) In the Advanced Options field, do the following:

      1. In the Model Params field, enter a column name and select the column value from the List Selection window.
      2. In the HDFS Params field, enter a column name and value.
      3. In the MapReduce Params field, enter a column name and value.
      4. In the SandBox JVM Params field, enter a column name and value.
    7. Click Test.

      A confirmation message that the job is scheduled successfully is displayed.

 

You are here
Table of Contents > Manage Reports for Warehouse Analytics

Attachments

    Outcomes