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
}
