Data Mart Report in MicroStrategy

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:

DataMart_Report

DAtamart_report2

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:

DAtamart_report3

 

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:
http://bipostit.com/en/2015/06/22/data-mart-report-in-microstrategy-ii/

Leave a Reply

Your email address will not be published. Required fields are marked *