Framework:BI-Center:Conditional Formatting: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
With the support of the "Conditional Formatting Assistant" you can define different styles for each measure. You open this | With the support of the "Conditional Formatting Assistant" you can define different styles for each measure. You open this assistant in an [[Framework:BI_Center:Create_Analysis_View|analysis view]] or an [[Framework:BI_Center:Create_Input_Mask|input mask]] from the property "[[Framework:BI_Center:Input_Mask_-_General_properties|StyleDefinitionObject]]". | ||
The assistant contains two steps. In the first step you define the styles, in the second step you define the conditions. | The assistant contains two steps. In the first step you define the styles, in the second step you define the conditions. | ||
| Line 20: | Line 18: | ||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">'''Input'''</span> Choose the | |<span style="color: darkblue">'''Input'''</span> Choose the color therefor. | ||
Choose "Next" and create three conditions and name them like the styles. | Choose "Next" and create three conditions and name them like the styles. | ||
|} | |} | ||
===Step 2: | ===Step 2: Define your conditions=== | ||
[[image:Fw_BI_Center Matrix Sicht Designer07.jpg|thumb|center|Framework, | [[image:Fw_BI_Center Matrix Sicht Designer07.jpg|thumb|center|Framework, Define conditions]] | ||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Input'''</span> Choose the style and as measure "in percent". Double click in the measure [in percent] in the short list und write > 5. | ||
Repeat this step for the condition "Variance negative" and "Normal". | |||
|} | |} | ||
Overview of the conditions: | |||
{| | {| class="wikitable" width="80%" | ||
|- | |- {{Tabellentitel}} | ||
| | | Name | ||
| | | Style | ||
| | | Measure | ||
| | | Condition | ||
|- | |- | ||
| | |Variance positive | ||
| | |Variance positive | ||
|in | |in percent | ||
|[in | |[in percent]>5 | ||
|- | |- | ||
| | |Variance negative | ||
| | |Variance negative | ||
|in | |in percent | ||
|[in | |[in percent]<5 | ||
|- | |- | ||
|Normal | |Normal | ||
|Normal | |Normal | ||
|in | |in percent | ||
|[in | |[in percent]>=-5 AND [in percent]<=5 | ||
|} | |} | ||
| Line 62: | Line 60: | ||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Input'''</span> Close the assistant with "Finish". | ||
|} | |} | ||
[[image:Fw_BI_Center Matrix Sicht Designer08.jpg|thumb|center|Framework, | [[image:Fw_BI_Center Matrix Sicht Designer08.jpg|thumb|center|Framework, Conditional Formatting]] | ||
Latest revision as of 11:35, 6 March 2012
With the support of the "Conditional Formatting Assistant" you can define different styles for each measure. You open this assistant in an analysis 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 color therefor.
Choose "Next" and create three conditions and name them like the styles. |
Step 2: Define your conditions
| Input Choose the style and as measure "in percent". Double click in the measure [in percent] in the short list und write > 5.
Repeat this step for the condition "Variance negative" and "Normal". |
Overview of the conditions:
| Name | Style | Measure | Condition |
| Variance positive | Variance positive | in percent | [in percent]>5 |
| Variance negative | Variance negative | in percent | [in percent]<5 |
| Normal | Normal | in percent | [in percent]>=-5 AND [in percent]<=5 |
| Input Close the assistant with "Finish". |
