Framework:BI-Center:Conditional Formatting: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
In this example you define a conditional formatting for the measure "in percent". Numbers between +5% and -5% have a white background color. A variance less than -5% will be red, a variance greater than 5% will be green. | In this example you define a conditional formatting for the measure "in percent". Numbers between +5% and -5% have a white background color. A variance less than -5% will be red, a variance greater than 5% will be green. | ||
=== | ===Step 1: Define your formats=== | ||
You create the styles. | |||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Input'''</span> Open the assistant and create three styles and give the names "Variance positive", "Variance negative" and "Normal". | ||
|} | |} | ||
[[image:Fw_BI_Center Matrix Sicht Designer05.jpg|thumb|center|Framework, | [[image:Fw_BI_Center Matrix Sicht Designer05.jpg|thumb|center|Framework, Create styles]] | ||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Input'''</span> Choose the right ccolor therefor. | ||
Choose "Next" and create three conditions and name them like the styles. | |||
|} | |} | ||
===Step 2: Definieren der Bedingungen=== | |||
== | |||
[[image:Fw_BI_Center Matrix Sicht Designer07.jpg|thumb|center|Framework, Bedingungen definieren]] | [[image:Fw_BI_Center Matrix Sicht Designer07.jpg|thumb|center|Framework, Bedingungen definieren]] | ||
Revision as of 14:17, 23 November 2010
With the support of the "Conditional Formatting Assistant" you can define different styles for each measure. You open this assistent in an analyse view or an input mask from the property "StyleDefinitionObject".
The assistant contains two steps. In the first step you define the styles, in the second step you define the conditions.
In this example you define a conditional formatting for the measure "in percent". Numbers between +5% and -5% have a white background color. A variance less than -5% will be red, a variance greater than 5% will be green.
Step 1: Define your formats
You create the styles.
| Input Open the assistant and create three styles and give the names "Variance positive", "Variance negative" and "Normal". |
| Input Choose the right ccolor therefor.
Choose "Next" and create three conditions and name them like the styles. |
Step 2: Definieren der Bedingungen
| Eingabe Für die „Abweichung positiv“ wählen Sie bitte das gleichnamige Format und das (Spalte-)Measure „in Prozent“. Als Bedingung doppelklicken Sie auf das Measure [in Prozent] in der Liste Measure und schreiben danach > 5.
Wiederholen Sie den Vorgang für die Bedingungen „Abweichung negativ“ und „Normal“. |
Die Bedingungen in der Übersicht:
| Name | Style | Measure | Bedingung |
| Abweichung positiv | Abweichung positiv | in Prozent | [in Prozent]>5 |
| Abweichung negativ | Abweichung negativ | in Prozent | [in Prozent]<5 |
| Normal | Normal | in Prozent | [in Prozent]>=-5 AND [in Prozent]<=5 |
| Eingabe Bestätigen Sie den Assistenten mit „Fertigstellen“. |
