The Anaplan Security team’s policy mandates that all models undergoing model concurrency testing must be sanitized. This provides additional protection for customers on top of the secure performance test environment. Model sanitization involves manipulating the data contained in a model to values that do not enable the identification of a company, any people, precise locations, company plans, or any other sensitive data.

You should make a copy of your model, sanitize it, and provide the model concurrency team with access to the model. The model concurrency team can then import this sanitized copy of the model into the performance test environment. Alternatively, if there is insufficient workspace capacity to enable a model copy, Level 3 Support can provide an isolated workspace to carry out sanitization.

This document describes the model sanitization requirements, and approaches. Script development doesn't start until a model has been imported into the performance test environment.

We understand that you may not sanitize all data due to time or effort constraints. We recommend that all data be sanitized, but the table below lists which data can remain unchanged. Data should be sanitized by a solution architect or model builder.

PriorityDataPossible locationExamplesSanitization mandatory
1Company nameModel name dashboards"Anaplan"Yes
2Other company namesGeneral listsAccounts, Suppliers, Clients, DistributorsYes
3Financial dataData input modulesSalaries, Revenue, Expenses, Sales tax %Yes
4Real person namesGeneral listsEmployees, PartnersYes
5LocationsGeneral listsSales offices, RetailersOptional
6ProductsGeneral listsBiscuit brands, Drink brandsOptional
7ServicesGeneral listsDental, Advertising, HousingOptional

A workspace administrator can sanitize list items and modules.

The quickest way to sanitize list items that represent sensitive data such as employee lists or accounts, is to create modified numbered lists. Follow these steps to convert proper names into an alpha-numeric string format.

  1. Go to General lists and identify the list you want to sanitize.
  2. Scroll to the Numbered column for the list you want to sanitize, then select and clear it. This changes the names of the items on that list to the default IDs that the model associates with the items.
  3. Open the list, then select the Properties tab.
  4. Insert a new property and name it Sanitized display name.
  5. Change the format to Text.
  6. Enter this formula in the Formula column:
    "ListName" & NAME(ITEM('list name'))
    where ListName is the prefix you want to give to the list item names and list name is the actual name of the list you’re modifying.
  7. In General lists, go to the list you’re sanitizing and select Numbered.
  8.  In the Display Name Property column, select Sanitized display name.

You can quickly sanitize modules used for collecting user data input, such as actual sales figures, forecasted sales values, and salaries:

  1. Go to Modules and open the module used for data input.
  2. Determine the line item used for inputting data that needs to be sanitized. Select any cell under that line item.
  3. Go to its formula bar and enter a random number. This should change the values of all the cells associated with that line item.
  4. Delete the random number from the formula bar.

If you've only one column of data in a module to be sanitized, you can copy and paste directly from a spreadsheet/text application. However, if you have cells that require values from a list selection, you can use the Export and Import functionality.

The Export and Import functionality also lets you sanitize several columns of data in one action. This method typically reduces human error.

If you encounter an error during the sanitization of your data, use the Model Restore functionality in  History to return to an original state.