KB15259: Tablespace parameter missing from the SQL generated by a data mart report using a tablespace name in MicroStrategy Developer against an Oracle Data warehouse

SYMPTOM:
When executing a data mart report in Strategy Developer against Oracle, users receive an error notifying them that a tablespace name is missing.
 
STEPS TO REPRODUCE:
Follow the steps below to reproduce this issue:

1. Create a data mart report for an Oracle data warehouse.
2. In the Data mart report, go to Data > Configure Data Mart.
3. Under the Advanced tab of the Report Data Mart Setup dialog box, for the Table Space field, enter a 'TABLESPACENAME' such as 'USER_DATA'.
4. Go to the SQL view and the result would be similar to the following:
   create table TablespaceTest (
   CUSTOMER_ID NUMBER(5),
   CUST_LAST_NAME VARCHAR2(100),
   CUST_FIRST_NAME VARCHAR2(100),
   ZIPCODE VARCHAR2(100),
   WJXBFS1 NUMBER,
   WJXBFS2 NUMBER,
   WJXBFS3 NUMBER)
   USER_DATA
    
   
5. Note: USER_DATA is not preceded with `tablespace` in the SQL statement.
    
   
6. Go back to the Configure Data Mart option and under the Advanced tab of the Report Data Mart Setup dialog box. For the Table Space field, enter 'tablespace TABLESPACENAME' such as 'tablespace USER_DATA.'
7. Go to the SQL view of the data mart report and the result would be similar to the following:
   create table TablespaceTest (
   CUSTOMER_ID NUMBER(5),
   CUST_LAST_NAME VARCHAR2(100),
   CUST_FIRST_NAME VARCHAR2(100),
   ZIPCODE VARCHAR2(100),
   WJXBFS1 NUMBER,
   WJXBFS2 NUMBER,
   WJXBFS3 NUMBER)
   tablespace USER_DATA
    
   
8. Note: USER_DATA is now preceded with 'tablespace' in the SQL statement.
    
   

CAUSE:
This is working as designed. The tablespace parameter is just a placeholder where users can input the required value. It is not designed to automatically generate the keyword 'tablespace'.
 
ACTION:
Users should enter the table space including the keyword as described below.

1. In the data mart report, go to Data > Configure Data Mart.
2. For the Table Space field under the Advanced tab of the Report Data Mart Setup dialog box, enter 'tablespace TABLESPACENAME' such as 'tablespace USER_DATA'.