How to dynamically refer to cube view in TI?

[Ashleigh W]

Hi experts, is there a way to dynamically refer to cube view in TI without setting reference to specific cube and view in 'Data Source'?
I have a TI which need to run on top on multiple cubes. Same TI - Multiple cubes with only 1 dimension difference and I do not want to replicate multiple TIs.

Thanks for your help in advance.

[declanr]

DataSourceNameForServer = <CubeName>;
DataSourceCubeView = <ViewName>;

On the prolog tab.
You need to make sure the view that you originally set it up with has at least the same number of columns etc in order to be able to use the variables.

[Ashleigh W]

Thank you for quick response.

does it matter where I place DataSourceNameForServer?
I currently set it at the Prolog bottom

[Emixam]

does it matter where I place DataSourceNameForServer?

No, as long as it's in the Prolog.

[Ashleigh W]

Thank you so much!

[lotsaram]

If you want to look at some worked examples of dynamically setting cubes and views as datasources just look at the bedrock library. For example bedrock.cube.data.export