=========
QUESTION
———
How do I make a MicroStrategy report populate a database table, rather than outputting to a static report?

 

=========
ANSWER
———
This feature is calledĀ a DataMart.
Edit the report in MSTR Desktop
Select Configure DataMart… from the Data menuĀ 
Enter a new table name* in the Table Name field
*Note: the table name should not contain any dashes (-). This will cause an error when the DataMart is executed.


Also note, the report cannot contain any Derived Metrics. If you require Derived Metrics, you will need to do that math on the data in a query after it has been exported to the database table.

RDWPRD10.RDWSys10<yourTableName>

 

=========
EXAMPLES
———
see ANSWER

 

=========
APPLIES TO / KEY WORDS
———
MicroStrategy
MSTR

 

=========
REF
———

 


http://www.anysitesupport.com/write-a-microstrategy-report-to-a-database-table/
http://anySiteHosting.com