Framework:BI Center:Plausibility Check: Difference between revisions

From CoPlanner 11
Jump to navigationJump to search
No edit summary
No edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
__TOC__
__TOC__
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.
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 [[Framework:BI_Center:Create_Input_Mask|input mask]] and [[Framework:BI_Center:Create_Analyse_View|analyse view]].
The plausibility check is available for [[Framework:BI_Center:Create_Input_Mask|input mask]] and [[Framework:BI_Center:Create_Analysis_View|analysis view]].
The following example shows how to define a plausibility check in an [[Framework:BI_Center:Create_Input_Mask|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.
The following example shows how to define a plausibility check in an [[Framework:BI_Center:Create_Input_Mask|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 "[[Framework:BI_Center:Input_Mask_-_Measure_properties|Plausibitity]]".
Open the designer with a click in the property "[[Framework:BI_Center:Input_Mask_-_Measure_properties|Plausibility]]".


The dialogue has following tabs:
The dialogue has following tabs:
:*Settings
:*[[Framework:BI_Center:Plausibility_Check#Tab „Settings“|Settings]]
:*Input message
:*[[Framework:BI_Center:Plausibility_Check#Tab „Input message“|Input message]]
:*Error message
:*[[Framework:BI_Center:Plausibility_Check#Tab „Error message“|Error message]]




[[image:Eingabepruefung02.jpg|thumb|center|Dialogue „Plausibility Check“, tab „Settings“]]
[[image:Eingabepruefung02.jpg|thumb|center|Dialogue „Plausibility Check“, tab „Settings“]]


====Tab „Settings“====
==Tab „Settings“==
 


In this register you define the condition for the plausibility check.
In this register you define the condition for the plausibility check.
Line 29: Line 28:
   
   


{| cellspacing="1" cellpadding="3" width={{{breite|60%}}} border="1"
{| class="wikitable" width={{{breite|60%}}}
|-{{Tabellentitel}}
| Variable
| Description
|-
|-
|[....]
|[....]
Line 41: Line 43:
|-
|-
|Dimension.ChildCount
|Dimension.ChildCount
|Number of Child-Elemente, zero if it is a leaf element
|Number of child elements, zero if it is a leaf element
|-
|-
|Dimension.BaseElementID
|Dimension.BaseElementID
|Name of the attribute (returns COPSYSID if it is a dimension, returns BASISELEMENTID if is is a subset)
|Name of the attribute (returns COPSYSID if it is a dimension, returns BASISELEMENTID if it is a subset)
|}
|}


====Tab „Input message“====
==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.
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.
In diesem Register können Sie eine Eingabemeldung erfassen. Ist die Option aktiviert, wird der Fußzeile der Maske die Eingabemeldung angezeigt.
The message appears if the column is selected.
The message appears if the column is selected.


 
[[image:Eingabepruefung03.jpg|thumb|center|Dialogue „Plausibility Check“, tab „Input message“]]
[[image:Eingabepruefung03.jpg|thumb|center|Dialogue „Plausibility Check“, tab „Input message““]]


Enter following message in the textbox:
Enter following message in the textbox:
Line 60: Line 60:
{| {{Bausteindesign2}}
{| {{Bausteindesign2}}
|-
|-
|<span style="color: darkblue">'''Input'''</span> &nbsp;„You have to insert a price first.“
|<span style="color: darkblue">'''Input'''</span> &nbsp;„You have to enter a price first.“
|}
|}


In der Maske erfolgt die Darstellung:
Display in the mask:


[[image:EingabepruefungAggmaske.jpg|thumb|center|Dialog „Eingabeprüfung“, Darstellung der „Eingabemeldung“ in der Maske]]
[[image:EingabepruefungAggmaske.jpg|thumb|center|Dialogue „Plausibility Check“, Display of the input message]]


====Register „Fehlermeldung“====
==Tab „Error message“==
   
   
In diesem Register definieren Sie Meldung die ausgegeben wird, wenn der Anwender ungültige Daten erfassen will.
In this tab you define the message, if the user enters invalid data.
Neben dem Titel und dem Text der Fehlermeldung können Sie auch den Typ bestimmen. Die Typen haben unterschiedliche Auswirkungen auf die Eingabe.
Beside the title and the message you can define the type. The type of the message dialogue has different effects on data entry.  
:*Information: Eine Informationsmeldung wird angezeigt, die Daten werden akzeptiert
:*Information: a information message is shown, data entry will be accept.
:*Warnung: Eine Warnungsmeldung wird angezeigt, die Daten werden akzeptiert
:*Warning: a warning message is shown, data entry will be accept.
:*Stopp: Ungültige Daten werden nicht akzeptiert
:*Stop: Invalid data will not be accepted.
 


[[image:Eingabepruefung04.jpg|thumb|center|Dialog „Eingabeprüfung“, Register „Fehlermeldung“]]
[[image:Eingabepruefung04.jpg|thumb|center|Dialogue „Plausibility Check“, tab „Error message“]]


{| {{Bausteindesign2}}
{| {{Bausteindesign2}}
|-
|-
|<span style="color: darkblue">'''Eingabe'''</span> &nbsp;Wählen Sie als Typ „Stopp“ und erfassen Sie den Titel und die Fehlermeldung.
|<span style="color: darkblue">'''Input'''</span> &nbsp;Choose type stop and enter title and message.
|}
|}



Latest revision as of 10:37, 29 May 2012

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:


Dialogue „Plausibility Check“, tab „Settings“

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.

Dialogue „Plausibility Check“, tab „Input message“

Enter following message in the textbox:

Input  „You have to enter a price first.“

Display in the mask:

Dialogue „Plausibility Check“, Display of the input message

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.


Dialogue „Plausibility Check“, tab „Error message“
Input  Choose type stop and enter title and message.