SapHanaRangeOperator.GreaterThan

Updated on

SapHanaRangeOperator.GreaterThan (0) is an enumeration that specifies a range operator for SAP HANA range input parameters. It is a member of the SapHanaRangeOperator.Type and specifies the ‘Greater than’ range operator for SAP HANA input parameters.

Examples

Here’s an example on how you can use SapHanaRangeOperator.GreaterThan:

let
  Source         = SapHana.Database ( "server:30015", [ Implementation = "2.0" ] ), 
  Contents       = Source{ [Name = "Contents" ]}[Data], 
  ADVENTUREWORKS = Contents { [Name = "ADVENTUREWORKS" ] }[Data], 
  AN_SALES2      = ADVENTUREWORKS{ [ Name = "AN_SALES1" ] }[Data], 
  AddedItems = 
    Cube.Transform (
      AN_SALES2, 
      {
        { Cube.ApplyParameter, "Var3", { SapHanaRangeOperator.GreaterThan, 1, null } }, 
        { Cube.AddMeasureColumn, "Average Sale Per Order", "[Measures].[AverageSalePerOrder]" }
      }
    )
in
  AddedItems

Other related enumerations are:

Applies to

Here’s a list of functions that work with SapHanaRangeOperator.Type:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot