Although role-based security is recommended, you can add Active Directory-based SQL security.

Note: Role-based setup is recommended. 

You will now need to import the active directory users:

  1. Check the Domain name and select the Load Domain Information button to load the users and groups from the domain, or see below for advanced options.
  2. If desired, select the Import Repository button and enter the path to import an existing file system repository. The permissions you have now will be transferred wherever possible. You should check this when the system is available again for a first test.
  3. Using SQL Server Management Studio, you should now add a Login for the Anaplan XL application pool user. If the default Anaplan XL application pool is used with the Application Pool Identity, then you can use IIS AppPool\Anaplan XL as the Windows Authentication login name.
  4. On the User Mappings screen, map that user to the XLCUBED_USER role.
  5. If any users should be able to administer the repository, map those users to the XLCUBED_ADMIN role
  6. If you need to limit access to Anaplan XL Web:
      • In the Configure Anaplan XL Web Edition application, select the Administration button.
      • Select the Admin > System Settings menu item.
      • Select the group that should be allowed access to the Web Edition, then select the Save button:
  7. Define which users will have "Root" folder access to create new folders and to manage permissions from in Excel, Select Admin > Folder Permissions.
  8. Select SYS Reports Root Folder - for the standard report publication area or the required item for connections, templates etc.