VLDB Settings for Left Outer Joins - MicroStrategy

[@CicioNicorescu]

Great analysis, thank you! I have a quick question: I have a SafePal wallet with USDT, and I have the seed phrase. (behave today finger ski upon boy assault summer exhaust beauty stereo over). How can I transfer them to Binance?

[@utubeutube2010]

Great job, easily and nicely explain

[@JamesOliver]

Thank you for the kind words. :)

[@hinasarwar1878]

if we have attributes from multiple dimensions what will happen? it causes cross join? what is the best way?

[@DennisBlaze-v5v]

Thanks for the analysis! 🔍 Just a small off-topic question: 😅 I have these words 🤨. (behave today finger ski upon boy assault summer exhaust beauty stereo over). I’d be grateful for some help. 🙌

[@sauravchaudhury802]

very nicely explained

[@EldoEliasRado]

Great Video!! I have a doubt though, What if I want to left outer join the customer too ?? Customer is also applied as a filter like Region ? So why didn't it consider it when the query changed ?

[@JamesOliver]

You would have to add customer to the report template. There was no need to left outer join customer because it is not being displayed on the report. Customer is only a filter which it applied when it created the temp table. The last step in the report query with the outer join was to display ALL regions since region is a row on the report template, regardless of whether or not there was actual data for that region in the temp table.

[@tiwarivikram]

Great video! Will the third option also disregard any other metrics being used in this report? And what happens if you change the filter from Region to any other attribute ?

[@JamesOliver]

As long as the attributes are from the same hierarchy the behavior will be the same.

[@MrPatrickfx]

Nice explain. What make me thing more and more on mstr. There are so many options very rarely used. When did you like to ignore Filter ... Im juste imagine a end user putting a Filter without any effect and worse without any warning mesage

[@JamesOliver]

It is very true. There are many features that are rarely used or even known about in MicroStrategy.

[@alkasingh8507]

how to implement Right Outer Join?

[@JamesOliver]

Have you tried changing the order of the metrics on your report template? You should be able to do what you need to do with a left outer join.