Framework:BI Center:Plausibility Check
With the support of the plausibility check you can define, which kind of data are allowed. For example you can allow data entry in measure "Quantity" if a "Price" exists. The plausibility check is available for input mask and analysis view. The following example shows how to define a plausibility check in an input mask. It should be only allowed to enter a quantity, if a price exists and it is a leaf element. Furthermore only positive quantities are allowed.
Open the designer with a click in the property "Plausibility".
The dialogue has following tabs:
Tab „Settings“
In this register you define the condition for the plausibility check. The price may not be zero, the input value has to be greater zero and it has to be a leaf element.
| Input [Price] <> 0 and <value> > 0 and <Products.ChildCount> = 0 |
Check the option "Evaluation active" to activate the plausibility check. With a click on the button "Evaluate" you can check your settings. Following variables are allowed:
| Variable | Description |
| [....] | Reference to each column |
| Dimension.ID | COPSYSID of elements |
| Dimension.Level | Level-number, starting will zero. |
| Dimension.ChildCount | Number of child elements, zero if it is a leaf element |
| Dimension.BaseElementID | Name of the attribute (returns COPSYSID if it is a dimension, returns BASISELEMENTID if it is a subset) |
Tab „Input message“
In this tab you can edit a input message. If this option is activated, the message will be display in the footer of the mask. The message appears if the column is selected.
Enter following message in the textbox:
| Input „You have to enter a price first.“ |
Display in the mask:
Tab „Error message“
In this tab you define the message, if the user enters invalid data. Beside the title and the message you can define the type. The type of the message dialogue has different effects on data entry.
- Information: a information message is shown, data entry will be accept.
- Warning: a warning message is shown, data entry will be accept.
- Stop: Invalid data will not be accepted.
| Input Choose type stop and enter title and message. |
