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… -
Re: can I create a hierarchy when I am connecting to a sql server table for my model. If so, how? Do you have a video or tutorial on it?
Model builder: In help, search for "hierarchy" (and filter by "model"), you'll find this page on hierarchies. For non-builders, there is no way to "create" the hierarchy.…