What is the difference between Submit to Table and Submit to Named Table?
Answer – With just the Submit to Table permission enabled, the temporary table is assigned a default name by BI/Query. Something like this: _BIQ_T30833′. Whatever table name the user types in the prompt, is just displayed within the data model only, as the object name. This method does not drop any tables on the database. When the Submit to Named Table permission is enabled, the table name the user enters is the table name that will be created on the database. If the user chooses to re-use a table name, the table is dropped and re-created on the database.
