Non-deterministic functions in named sets
Named sets are a great way to encapsulate complex or frequently used set definitions. There are three ways to create a named set:
- The WITH SET clause of an MDX SELECT statement
- The CREATE SESSION SET statement
- The CREATE SET statement within the cube calculations script
Which of these you select depends on your needs and determines how and when the set is resolved. This is critical to understand when using non-deterministic functions as demonstrated in the following exercises.