KB47221: The ‘Show Sample Data’ option returns data for table structure different with the one saved in Warehouse Catalog in MicroStrategy Developer 9.x

SYMPTOM:
 
The ‘Show Sample Data’ option returns data for table structure different from the one saved in Warehouse Catalog in Strategy Developer 9.x
 
The following steps demonstrate how to reproduce this issue in Strategy Tutorial project:
 

1. Create one table with only one column in warehouse. Import it to the project.
2. Change the table structure and add one more column in warehouse as shown below:

• In Warehouse Catalog, the table structure is as shown below:

• Show sample data of this table. Data for both two columns will display in the list as shown below:

 
 
CAUSE:
 
This is working as designed. When users click "Show sample data" for one table in Warehouse Catalog, Strategy will retrieve data for all columns by executing script below against warehouse:
 
Select * from TableA;
 
So, all the columns will display in the view.
 
ACTION:
 
Update table structure to get the latest structure in warehouse.