Custom Query with Oracle data source
I have installed a native Oracle connector and I can bring in tables from Oracle to Spotfire, and I can even make joins via the Relations menu. However, I am not able to submit Custom Queries, as that option is always greyed out (see screenshot).
Is there a function that needs to be enabled that I can use an Oracle data source and custom queries as a data source? I could define the relations in Spotfire but queries allow much greater flexibility.