Link between 2 dataets with outerjoin in MicroStrategy Dossiers

Question

Now I'm developing the dossiers report in MicroStrategy. But I'm encountering the technical difficulty about Join behavior.

I have 2 tables like below.

Product List Table

Product Status Master Table

I set up the attribute link with "Name" in Product Status Master Table and "Current Phase" in Product List Table. Then, I created the table chart like below. Actual Result of Join

I only would like to show Product List Table left out join with Product Status Master Table. but "0" lines are dispalyed without my intention.

I tried to select InnerJoin and OuterJoin configuration again and again but not meet my expectation.

Could you please give me some advices?

Expected Result

Answer 1

I found the reason by myself. I needed to add at least one metaric dataset in the chart. after adding one metric dataset, the result is what I expected.

here is the reference of this solution. KB441281 - Microstrategy