Data Marting

No PostgreSQL specific customizations were made for this feature.

MicroStrategy supports creating permanent tables in the warehouse through a datamart report. These tables can be further used by other reports for analysis.

For example, this is a sample statement of a report to create permanent tables in the warehouse:

select a11.PS_SUPPKEY  S_SUPPKEY,
(sum(a11.PS_AVAILQTY) + sum(a11.PS_SUPPLYCOST))  WJXBFS1
into DataMartTest
from PARTSUPP a11
where a11.PS_SUPPKEY = 1
group by a11.PS_SUPPKEY

Freeform SQL is used to create reports using the datamart created by the previous report as shown below:

See KB5395: How to Create and Use Datamarts in MicroStrategy for more information.