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

}