Dealing with UDM Configuration Settings

Sometimes, you may need to have a configuration setting that is stored outside UDM. For example, you may need to store a connection string to a database that will supply the allowed set for dynamic security. As with SSRS, you can use the msmdsrv.exe.config file for this purpose like so:

<configuration>

<startup>

<requiredRuntime
version=“v2.0.50727“
safemode=“true“ />

</startup>

<runtime>

. . .

</runtime>

<appSettings>

<add
key=“connectionString“
value=“connection string here“ />

</appSettings>

</configuration>

This shouldn’t come to surprise since the SSAS server process hosts a .NET application domain to execute SSAS stored procedures. Once the configuration settings are defined, you can read them with a single line inside a SSAS stored procedure:

public
static
string GetConfigSetting(string settingName) {

return settingValue = ConfigurationManager.AppSettings[settingName]; // need a reference to System.Configuration

}