>= (大于或等于) (MDX) >= (Greater Than or Equal To) (MDX)

执行比较运算,以确定一个多维表达式 (MDX) 的值是否大于等于另一个 MDX 表达式的值。Performs a comparison operation that determines whether the value of one Multidimensional Expressions (MDX) expression is greater than or equal to the value of another MDX expression.

语法Syntax

  
MDX_Expression >= MDX_Expression  

参数Parameters

MDX_ExpressionMDX_Expression
有效的 MDX 表达式。A valid MDX expression.

返回值Return Value

布尔值,具体情形如下:A Boolean value based on the following conditions:

  • 如果第一个参数的值大于或等于第二个参数的值,则为 truetrue if the first parameter has a value that is either greater than or equal to the value of the second parameter.

  • 如果第一个参数的值小于第二个参数的值,则为 falsefalse if the first parameter has a value that is lower than the value of the second parameter.

  • 如果两个参数均为 null 或者一个参数为 null,另一个参数为0,则为 truetrue if both parameters are null or if one parameter is null and the other parameter is 0.

示例Examples

下面的示例演示了此运算符的用法。The following example demonstrates the use of this operator.

-- This query returns the gross profit margin (GPM)  
-- for Australia where the GPM is greater than or equal to 50%.  
With Member [Measures].[HighGPM] as  
  IIF(  
      [Measures].[Gross Profit Margin] >= .5,  
      [Measures].[Gross Profit Margin],  
      null)  
SELECT   
    NON EMPTY [Sales Territory].[Sales Territory Country].[Australia] ON 0,  
    NON EMPTY [Product].[Category].Members ON 1  
FROM  
    [Adventure Works]  
WHERE  
    ([Measures].[HighGPM])  

另请参阅See Also

Mdx 运算符引用 (MDX)MDX Operator Reference (MDX)