...
Defining the values for which the conditions of the rule are evaluated
In the ‘Verify'Verify' pane dimensions, measures and calculated expressions associated to the view are displayed with their corresponding elements.
In the example of the view presented in the previous picture, there are three dimensions: Date (in columns), Products and Customers (in rows).
Elements in each dimension are presented in the corresponding sections of the pane. The set of elements for which the business rule has to be evaluated have to be indicated in this pane.
More than one element can be selected, by pressing the "control" key while you select them with the left button of the mouse.
No selected elements means the evaluation applies to all elements.
Picture 2: Tab to choose values to check in a rule, showing the sections corresponding to each dimension of the view.
...
The conditions to be evaluated for the elements in the view selected in the Verify' pane seen before are defined in the corresponding pane of the Conditions tab. If these conditions are complied with or not, results in the generation of the corresponding actions associated to the business rules.
Conditions are defined by means of simple or compound logical expressions. Simple expressions let you compose several compound expressions by using the AND and/or OR logical operators.
Besides, different conditions can be defined for the same rule, and different actions can be associated to each of them.
Actions that you wish to be executed for values that do not comply with the defined business rule are also defined in the Conditions Pane. Not associating an action to any given rule results in the elements not complying the set conditions being colored red by default.
Picture 3: Conditions of the Rule definition dialogue box.
The following table describes the elements displayed in the ‘Conditions'Conditions' pane.
Conditions | This list contains the conditions defined in the Rule. It lets you select a previously defined one, to be viewed, modified or deleted. |
New | It lets you add a new condition to the definition of the rule. |
Delete | It deletes a condition from the list. |
Name | It defines the name of the condition |
Description | It associates a description to the condition. |
The condition describes... | It states whether the rule triggers actions for values complying with the condition, or if on the contrary, actions are triggered for values that do not comply with it. |
| It lets you add expressions to the condition. If there is more than one expression associated to the condition, it is necessary to define a logical operator composing those expressions. The picture above shows an example in which the condition consists of two sub-expressions CELL > 600 y CELL < 1000, linked by the logical operator AND (&&). Please note that you may also write expressions between brackets if you choose the columns corresponding to the brackets. |
| Delete the selected expression |
| Open Action: It associates an existing action to the current condition. |
| New Action: It defines a new action and associates it to the current condition. |
Save | It saves the definition of the rule. When the rule is saved in the server it is checked when the cube is built. |
Apply | It applies the changes made in the definition of the condition. Changes are viewed in the current view. This option does not make modifications permanent. |
Cancel | It Cancels rule definition. |
...
- Go to the Conditions Pane.
- Add a new condition, pressing the "New" button, or selecting a condition from the list. In case of defining a new condition, a name must be associated.
- Define the comparison operator for the current condition. The left term of this operator corresponds to the elements selected in the ‘Verify'Verify' tab. The term on the right is an expression whose definition is detailed in the following point. Available comparison operators are: different from, more than, more than or equal to, less than, less than or equal to, between and differs in.
- Define the expression to which you wish to compare the different elements selected in the Control tab. Expressions are defined in a specific language. The expressions editor is displayed when clicking on the right end of the "Expression" field, where the three dots (…...) are shown.
- If you wish to define a compound expression, you must add new expressions for the same condition and define the logical operator that connects them. If you wish to use expressions between brackets, you must tick the corresponding checkbox at the beginning and end of each sub expression.
...
- Edit the file named mail-service.xml that is within Ideasoft O3 installation, in the following folder <O3>\jboss\server\default\deploy\
- Find the section <configuration> and assign the proper values to the following properties.
- mail.pop3.host -> Name or IP of the POP· POP- mail server mail.smtp.host -> Name or IP of the SMTP mail server
- mail.from -> Mail account that will be used to send the e-mail messages.
- If the server requires authentication, the user must also be entered in the following attributes:
...
As mentioned before, a sending of an e-mail message example action is included in the Ideasoft O3 installation CD. Such action is named Mail.action, and can be edited from the File/Edit/Edit Action menu, in the repository of remote files.
The body of the message this action sends when the business rule is evaluated is shown below. Such content is presented in this manual as an example, the user being able to define a different one.
The following pictures show the contents of the received e-mail message:
Picture 3: HTML Contents of the received e-mail message.
Picture 4: Contents of the file attached to the e-mail message received.
When a mail is sent including a spreadsheet, the printout of such an email will not show the background colors by default. Instructions about how to change these settings can be found here.
Contents of the body of the e-mail message
...
| Rule without exceptions, that is, all values in the query comply with the defined rule. |
| Rule with exceptions. It indicates that there are values that do not comply with the defined rule. If you click on the icon, the values that do not comply with the rule will be highlighted according to the associated style determined when defining the rule. Please note that in the picture given as example, the icon changes to indicate we are highlighting those values. Clicking on the icon again the values toggle back to normal. |
...