Microstrategy provides us a good utility which we usually not use, insert a custom report DataMart as another table in our model. This is very simple, we need to go the the next menu:
Here we can choose the result of our report as a new table (include name) or as a new insert into an existing table.
Also, we can go to the “Advanced” section:
Here we can choose the result of our report as a new table (include name) or as a new insert into an existing table. Also, we can go to the “Advanced” section Here we have different textbox to include custom SQL to execute before or after the creation of the table. It´s an interesting section for Oracle maintenance operations like “Shrink”, “index” or partitions, however the possibilities are infinite. At this point, whenever we execute our report, a new table is created in our model (eliminating the above, if previously exists), or data are added to an existing table.
You have more information about this functionality in the next url: