Does the data cube use always inner join?

Hey zoolee 

Indeed relationships within the Elasticube are always INNER JOINs, so the above result set is expected. Meaning, the rows which have those date values(5/19 and 5/20) which existing in both sides of the join will appear.

In order to achieve other join types to more complex SQL queries in general, one can create a custom SQL expression and using standard SQL, create any query you like.

For more on creating custom SQL expressions see this link 

or this article on how to create custom SQL tables for live models

If you need any help with setting up these custom tables, or if you have other more complex requirements, please let me know,

We're always here to help 

Ido from QBeeQ

QBeeQ - Gold Sisense Partner

[email protected]

Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news!