How do I enable anonymization for Analytics reports?

Purpose

Data anonymization uses hashing to obscure specific sensitive information in the auxiliary database tables so that a non-admin NSP user with an anonymization role can access only encrypted information, such as the mobile subscriber name or ID.

Note:

  • Reports do not return data when anonymized attributes are prompts in the report.

  • Drill-down reports do not return data when the drill-down parameter is an anonymized attribute.

Contact your Nokia support representative for information about which tables or table columns to anonymize based on your privacy needs.

Steps
 
1 

Enable anonymization for Analytics reports:

  1. Log in as the root user on an auxiliary database station.

  2. Enter the following:

    # cd /opt/nsp/nfmp/auxdb/install/bin ↵

  3. Enter the following:

    # ./auxdbAdmin.sh addAnonymization schema table_name column_name ↵

    For example:

    ./auxdbAdmin.sh addAnonymization samdb Analytics_cflowd_aa_mobile_volume_ag_r_day obsSubId

  4. You are prompted for the samauxdb password.

  5. Enter the password.

    The anonymization entry is added.

2 

Configure and assign the anonymization role to the NSP user.

  1. Log in to the main server station as the nsp admin user or a user with admin privileges.

  2. Create a role with Analytics Reports access permissions and anonymization enabled, and assign it to an NSP non-admin user:

    • for Permissions, choose Read/Write/Execute for Analytics

    • enable the Enable Report Data Anonymization check box

    • enable access to the reports and data domains, as required

    See the NSP System Administrator Guide for more information.

3 

Disable anonymization for Analytics reports, if required.

  1. Log in as the root user on an auxiliary database station.

  2. Enter the following:

    # cd /opt/nsp/nfmp/auxdb/install/bin ↵

  3. Enter the following:

    # ./auxdbAdmin.sh removeAnonymization schema table_name column_name ↵

    For example:

    ./auxdbAdmin.sh removeAnonymization samdb Analytics_cflowd_aa_mobile_volume_ag_r_day obsSubId

  4. You are prompted for the samauxdb password.

  5. Enter the password.

    The anonymization entry is removed.

4 

Close the open console window.

End of steps

Example

The following figures show the same report but with different outputs. The first report displays anonymized output, in this case, subscriber information, as seen by an anonymized user. The second report shows output in clear text for the subscriber information.

Figure 1-1: A report with anonymized output
A report with anonymized output
Figure 1-2: A report with clear text (non-anonymized) output
A report with clear text (non-anonymized) output