Report Portal

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.

Read more...

Tags: mdx, set

 

2007-2015 VidasSoft Systems Inc.