This chapter describes how to configure and use the Business Logic Engine (BLE) to evaluate client expressions in worksheets.
This chapter covers the following topics:
Typically many of your series use client expressions. When users run a worksheet, the client expressions are evaluated. The worksheet re-evaluates the client expressions whenever the user changes data in the worksheet. If the worksheet is at an aggregated level, Demantra Spectrum then splits the values to the lowest level (for example, SKU-store), and writes them to the database.
However, when you change data in the database (for example, by importing new data), the client expressions are not automatically re-evaluated. This can be an issue if you need to use the resulting data without first opening a worksheet. For example, suppose you want to import data and then export other data calculated from the imported data. In such a case, you need to force Demantra Spectrum to evaluate the relevant client expressions. To do so, you use the Business Logic Engine, which evaluates the client expressions in a given worksheet.
To call the Business Logic Engine, define a workflow that includes the BLE Step. This workflow step starts the Business Logic Engine and evaluates the client expressions in the worksheet specified in the BLE Step.
Note: For more information see the BLE Step section in the Workflow Steps chapter.