Ok,

So we knew that datasources.xml is the default file name and under WEB-INF/ is the default location.

But in web.xml, it's possible to specify a unique location, using the init-param, DataSourcesConfig.

I have made this:
<init-param>
<param-name>DataSourcesConfig</param-name>
<param-value>WEB-INF/datasources_${ENV_ID}.xml</param-value>
</init-param>

So ENV_ID is a system variable. We have multiple datasources.xml files based on the installations because their configurations are different.

The problem is that Mondrian can not seem to return this variable. It reads the string literally. And of course it errors and says it can't find the file.

Could anyone suggest a solution to this? Is there different syntax for calling the variable? Linux installation by the way.

Thank you,
dever