Sometimes you have to deal with denormalized database.
And specially when links to another table are stored in one
of the fields as comma delimited list of IDs.
This script shows how to make a single SELECT statement to fetch linked records
In this lesson, we will introduce a function that provides us the ability to derive a set by systematically applying a set expression to each of the members of a set we define. GENERATE() is a potent function in our MDX toolset, in that it enables us to select precisely only certain members of a dimension level. It effectively operates upon two sets to create a new set, based upon the members of a second set that are also in a primary set.