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:
Parameter | Description |
|---|---|
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]