KB19487: “ORA-01031: insufficient privileges” error is thrown when trying to create an attribute qualification filter or answering an attribute element list prompt but not when running reports through MicroStrategy Developer 9.x

ORA-01031: insufficient privileges

 
However, when running a report with the same attribute used on the filter/prompt, the report returns results correctly.
CAUSE
The ORA-01031 error means that the user receiving this error lacks a privilege to create an object, usually a table or view.
When browsing the attribute elements to create the attribute qualification filter or to answer the prompt, the SQL Generation Engine needs to store the results in a temporary table. On the other hand, when running the report with just that attribute, no temporary table is created, therefore the error is not thrown.
This can be confirmed by enabling SQL Trace logging when browsing the attribute element list:

ORA-01031: insufficient privileges
Connection String: XXX;. SQL Statement: create table ZZTIQ00LUVZOT000 nologging as
select XXX

 
ACTION
 
Grant CREATE privileges on the warehouse database to the database user that is used to run the reports.
KB7549 - What permissions are needed for the metadata and warehouse to use Strategy products