Configure the distribution list to use the SQL query in Anaplan XL Reporting

You must configure the distribution list to use the SQL query.

1. On the web server, open the distributionLists.xml configuration file, found in the __xlcubed__\__scheduling__ subfolder of the Anaplan XL Repository.
2. To each dynamically populated distribution list, add:
   • A dbConnection element, containing the connection string to connect to the database. This can include the User Id and Password connection properties if appropriate, but not a Provider property.
   • A populateQuery element, containing the SQL statement to run.

Your distributionLists.xml file should now contain an element that looks like this:

<distributionlist guid="xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" name="List name"> <dbConnection>Data Source=serverName\instance;Initial Catalog=DBName;User Id=Username;Password=ThePassword</dbConnection> <populateQuery>ap_GetSchedulingItems</populateQuery> </distributionlist>