| Create (Set) | (standard MDX) |
Creates a set.
Description
The following statement allows for adding a set to a schema. It is very similar to the WITH SET statement:
CREATE [ DYNAMIC | STATIC ] SET name AS MDX-expression
DYNAMIC SETs are evaluated once per MDX query. The context of evaluation is the cube defined in the query.
Example : CREATE DYNAMIC SET [Top 3 Countries / Amount] as TopCount( [Geography].[Geo].[City].Members, 3, [Measures].[Amount] )")
STATIC SETs, the default modifier, are evaluated only once. The context of evaluation, cube, needs to be defined in the statement. Therefore, STATIC SETs can be used for example to cache costly evaluations.
Example : CREATE STATIC SET [Sales].[Top 3 Countries / Amount] as TopCount( [Geography].[Geo].[City].Members, 3, [Measures].[Amount] )")
See Also
Drop (Set) Create (Function) Create (Member)
Examples
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.