This relates to Idea TS-I-6178.
Scenario
Data Function is set to Type: Open Source R.
The script runs using server's open source R, as opposed to local machine's, even though system's PATH includes the location of local open source R.
Setting `RinR_R_FULL_PATH` variable in script to local open source doesn't help either.
Goal
Enable Data Function to run on local open source R as it provides the full runtime speed-up benefit as it avoids the round-trip to server.
It is possible to use "force local" with Python but not with open source R. However, that forces us to maintain expensive H/W just for R data functions. We could install the same R engine on the Windows terminal servers where we run our installed clients and then "force local" would allow us to exploit that high spec H/W.
If you'd then allow to run Python and R service together on the same node manager, that would help us cut operational costs for Spotfire significantly. And it saves time for moving data from one machine to the other when we use the installed client.