KB41809: How to get the schema name of an Oracle warehouse table to show up as a table prefix in report SQL in MicroStrategy

 
Suppose an Oracle data warehouse is being used with Strategy. After running a report the user switches to SQL view and notices that the schema name does not show up as the table prefix in the report SQL:
 

 
The following procedure describes how to get the schema name of a warehouse table to show up as a table prefix in the report SQL in Strategy.
 
1.) When importing new tables from the data warehouse into the project:

• Open Warehouse Catalog and go to Options -> View -> Table Prefixes. Make sure that both "Display table prefixes in the main dialog" and "Automatically define prefixes for all the tables that are added to the project" checkboxes are checked. For the second option, make sure to select the first radio button "Set a prefix based on the warehouse table name space or owner (import Prefix)". Hit OK.
   
  
• On the left hand side of the Warehouse Catalog the schema name should now appear in the "Name Space" column. When a table is selected and moved to the right hand side, i.e. the project tables, the prefix comes along and shows up in the "Prefix" column.
   
  

 
2.) For tables already in the project:

• Right-click on the table name and select "Table Prefix..."
   
  

• If the schema name has already been added as an available prefix, select it from the list and click OK. Choose OK when asked "Are you sure that you want to set <<my_schema_name.>> as a prefix?"
   
  

• If it is not already in the list of available prefixes, click on the "Add" button. Type in the schema name followed by a dot, e.g. "my_schema_name." Click OK. Select it from the list of available prefixes and click OK. Choose OK when "Are you sure that you want to set <<my_schema_name.>> as a prefix?" is prompted 
   
  

3.) Save and close the Warehouse Catalog.
 
4.) Save and update schema.
 

 
5.) Purge the report cache.
 

 
 
6.) Run the report and switch to SQL view.