Left Joining Tables in Cube

Comments

2 comments

  • Avatar
    Tal Admon

    Every relationship in the model is a join - to have a left join you need to have a custom query, unfortunately.

    @sisense - any plans to allow left join from the elasticube manager?

  • Avatar
    Adi Hecht

    I am also (left) joining in on this request.

    This is really necessary especially when you have dimension tables with missing dimensions, for example if you have a fact table with all the orders and a dimension table with customer details, but some customer IDs in the orders table do not have a match in the customers table. With a very large fact orders table but rather small customers table.

     

Please sign in to leave a comment.