Version 2021
Outer Join
No PostgreSQL specific customizations were made for this feature.
The following sample query demonstrates how MicroStrategy supports outer join against PostgreSQL.
Copy
CREATE UNLOGGED TABLE TRZW9NHICSP000(
"C_CUSTKEY" INTEGER,
"WJXBFS1" DOUBLE PRECISION)
insert into TRZW9NHICSP000
select "a11"."O_CUSTKEY" AS "C_CUSTKEY",
sum("a11"."O_TOTALPRICE") AS "WJXBFS1"
from "ORDERS" "a11"
where "a11"."O_CUSTKEY" <= 2
group by "a11"."O_CUSTKEY"
CREATE UNLOGGED TABLE TVEDQNM38SP001(
"C_CUSTKEY" INTEGER,
"WJXBFS1" DOUBLE PRECISION)
insert into TVEDQNM38SP001
select "a11"."C_CUSTKEY" AS "C_CUSTKEY",
"a11"."C_ACCTBAL" AS "WJXBFS1"
from "CUSTOMER" "a11"
where "a11"."C_CUSTKEY" <= 2
select coalesce("pa11"."C_CUSTKEY", "pa12"."C_CUSTKEY") AS "C_CUSTKEY",
"pa11"."WJXBFS1" AS "WJXBFS1",
"pa12"."WJXBFS1" AS "WJXBFS2"
from TRZW9NHICSP000 "pa11"
full outer join TVEDQNM38SP001 "pa12"
on ("pa11"."C_CUSTKEY" = "pa12"."C_CUSTKEY")
drop table TRZW9NHICSP000
drop table TVEDQNM38SP001 Define Join Behavior
You can define join behavior through the Report Data option in each individual report in design view.
The default join type for attributes is outer join.
The default join type for metrics is inner join.
