Can you have a Table Join where the table name set with parameter
We have a situation where a long list of IDs are composed outside of Yellowfin, then need to be provided to Yellowfin for a report that will JOIN on this list and produce its results. To date we have a design where we maintain a table called a transaction table, holding a transaction_id as a key and multiple values for that key. Then the Yellowfin view joins on the transaction table, with the transaction_id as a WHERE condition.
Because of concurrency conflicts on that transaction table, we were wondering if we could redesign our approach to use a named temporary table to hold the list of IDs that need to be passed to Yellowfin for the report. It would be a different temporary table (holding different IDs) for each call to the report. Is there a way to provide a Table name as a parameter to a Yellowfin view, that would then JOIN on that table? To my reading I don't think that would be possible, but I'm looking for your feedback on the issue, and any other possible suggestions.