Logical Operators extend a normal mapping rule with VB.Net scripting functionality. To use logical operators, complete the following steps:
-
Navigate to Application > Data Collection>Transformation Rules.
-
Under Rule Groups, expand Derivative, then select a derivative rule group.
-
Select a value from the Type drop-down menu.
-
Click Insert Row.
-
Type a name into the Rule Name field.
-
Type a description into the Description field.
-
Type an expression into the Rule Expression field. For example, A#[TicketCost]=Math_Power2:A1#[]=None:A2#[]=None:xBDT#[2022-01-01 00;00;00~2022-12-31 23;59;59]!Y.
-
Double-click the new row in the Logical Operator column.
-
In the Derivative Expression Editor dialog box, from the Expression Type drop-down menu, select the logical operator you want to use.
-
Type an appropriate value into the Math Value field and click the OK button.
-
In the Derivative Type column, set the value to Final (Exclude Calc).
-
In the Order column, type a value that is greater than the current highest order value in the list.
-
Click the Save button.
-
Navigate to the OnePlace tab and set a BI Blend Workflow POV.
-
Click Load and Transform.
-
Select a file and click Open.
-
Click the OK button.
-
Log in to the database server for the environment and execute a query on the BI Blend database where the data was loaded to. You will see records returned.
-
Verify that the values in the applicable amount column are equal to the expected results.
