Badges
Latest Posts
-
Re: Is it possible to create a combined list by selecting members from two different tables and columns?
@Vijayan Krishnan The key trick lies in the left joins - a central concept resolved in SQL itself. Custom Columns don't have to be in the model. You can add the columns into the model itself as a… -
Re: Is it possible to create a combined list by selecting members from two different tables and columns?
@Vijayan Krishnan If you need the details resolved at the grain (which is sounds like), you need to use custom columns. Otherwise, you can build a semantic "list" and filter it using the nonempty…