Set Up and Maintain Security

The standard procedure for setting up security during implementation of Capture Analytics commonly involves the following basic steps:

  1. Edit the data in the security setup files to define users and user groups and to provide the users and user groups with the access that you want them to have.

  2. Use the security-related configuration options to activate security in Capture Analytics.

  3. Run an update process to apply the access specified in the security setup files to Capture Analytics.

In this topic

Preparation

If You Have Costpoint Analytics

Alternate Field Security

Set Up Security

Maintain Security

Preparation

Before you begin the security setup process, we recommend that you do the following:

If You Have Costpoint Analytics

If your firm has Costpoint Analytics as well as Capture Analytics, it is important that you update the data models for Costpoint Analytics – Project security either before you update the data models for Costpoint Analytics – Employee and Capture Analytics or as part of the same update process.

Ideally, you should select security configuration options and prepare the security spreadsheets for all three modules, and then, when all three are prepared, do either of the following to update all data models in one process:

Alternate Field Security

These procedures apply only to the standard security based on organization. They do not include security based on an alternate field. If you are going to set up security based on an alternate field for some users, refer to Set Up and Maintain Security Based on an Alternate Field.

Set Up Security

Important: Before you begin this procedure, contact your network administrator to get the correct LDAP server name. In step 5 of this procedure, be sure that you enter the path to that LDAP server.

  1. Run the QlikView Management Console (Start » All Programs » Deltek Analytics » QlikView Management Console).

  2. Click the System tab and the Setup subtab.

  3. Expand Command Center, Directory Service Connectors, and DSC@<server name>.

  4. Click Active Directory, and click ADMIN_ActiveDirectoryPlusButton.png.

  5. Click ADMIN_ActiveDirectoryGetDefaultButton.png next to the Path field.

Important: When you click ADMIN_ActiveDirectoryGetDefaultButton.png, QlikView Management Console defaults in an LDAP server path. That path may not be correct. If not, enter the correct path. It is extremely important to have your network administrator verify the path. Security will not function properly if it not correct.

  1. In Username and Password, specify either a domain service account (recommended) or a valid domain-based user name and password.

  2. Click Apply.

  3. Open the CostpointAnalyticsOrgSecuritySetup.xlsx file. The file location is the <installation location>\Setup folder.

  4. In the CostpointAnalyticsOrgSecuritySetup.xlsx file, specify the user groups and users. Save your changes.

For more information on editing the access settings in the Excel file, see Specify Security Settings in the CostpointAnalyticsOrgSecuritySetup.xlsx File.

  1. On the server on which you installed Capture Analytics, go to the <installation location>/Admin folder.

  2. Run CRM_Analytics_System_Config.qvw to open Capture Analytics Configuration.

  3. Select the configuration options that activate Capture Analytics security and single sign on authentication.

See Security and Security: Single Sign On for more information.

  1. Run the QlikView Management Console (Start » All Programs » Deltek Analytics » QlikView Management Console).

  2. Click the Documents tab.

  3. On the Source Documents tab, expand the items in the left pane until the Final folder is displayed. Expand that folder also.

  4. Expand CRM_Analytics.qvw, and do the following:

    1. Click the task.

    2. Click the Reload tab in the right pane.

    3. Select the Section access check box.

    4. In Username, enter DeltekAnalytics, and in Password, enter the password you assigned to that service account when you installed Costpoint Analytics.

    5. Click Apply.

  1. Locate the Translate folder in the left pane, and expand that folder.

  2. Repeat the procedure in step 16 for Data_Model_CRM_Secured.qvw.

  3. Load the security data into the Capture Analytics data model. You can wait for your next scheduled load process, or you can implement it immediately. See Update the Data Model Based on Security Settings for the load procedures.

Maintain Security

If you need to add or change user groups or users, make the changes in the security setup file and load the updated security information into the Capture Analytics data model.

  1. In the CostpointAnalyticsOrgSecuritySetup.xlsx file, make any necessary changes to the existing security data. You can add or delete user groups and users, and you can change the access for the existing user groups and users.

  2. Save your changes.

  3. Load the security data into the Capture Analytics data model. You can wait for your next scheduled load process, or you can implement it immediately. See Update the Data Model Based on Security Settings for the load procedures.