Control Datastore where the optimized sql will run on BODS

Is there is any way to control the data store where the optimized sql will run on BODS?

The optimised sql should have run on a schema A of the database, but the optmised sql is running on the Scheme B. Is there is any way in order to make the optmised sql to run on schema B.