STATIC
Description
The MDX function evaluate its inner entity once and reuse this already executed entity across other members.
Syntax
STATIC(SET_Expression)
Return Type
SET_EXPRESSION
Parameters
Set_Expression
It is a valid MDX expression that returns a set.
Example
WITH MEMBER [Measures].[Result] AS Aggregate (Static (Filter (([Procedure Info].[Revenue Code UB].Children), ([Procedure Info].[Revenue Code UB].CurrentMember.MemberValue >= '0290' AND [Procedure Info].[Revenue Code UB].CurrentMember.MemberValue <= '0293')))) SELECT [Measures].[Result] ON 0 FROM [AdventureWorksMF]