Framework:BI-Center:Conditional Formatting - Revision history

Admin at 09:35, 6 March 2012

2012-03-06T09:35:23Z

← Older revision		Revision as of 11:35, 6 March 2012
Line 34:		Line 34:
	Overview of the conditions:		Overview of the conditions:

	{\| ~~style~~="~~width: 857px; height: 108px" cellspacing="1" cellpadding="3~~" width="~~857" border="1~~"		{\| class="wikitable" width="80%"
	\|-		\|- {{Tabellentitel}}
	\| ~~style=background-color:#f6f6f6 \|'''~~Name~~'''~~		\| Name
	\| ~~style=background-color:#f6f6f6 \|'''~~Style~~'''~~		\| Style
	\| ~~style=background-color:#f6f6f6 \|'''~~Measure~~'''~~		\| Measure
	\| ~~style=background-color:#f6f6f6 \|'''~~Condition~~'''~~		\| Condition
	\|-		\|-
	\|Variance positive		\|Variance positive

Admin at 09:02, 24 November 2010

2010-11-24T09:02:01Z

← Older revision		Revision as of 11:02, 24 November 2010
Line 1:		Line 1:
	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_Analyse_View~~\|~~analyse~~ view]] or an [[Framework:BI_Center:Create_Input_Mask\|input mask]] from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".		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.

Admin at 12:33, 23 November 2010

2010-11-23T12:33:56Z

← Older revision		Revision as of 14:33, 23 November 2010
Line 1:		Line 1:
	With the support of the "Conditional Formatting Assistant" you can define different styles for each measure. You open this ~~assistent~~ in an [[Framework:BI_Center:Create_Analyse_View\|analyse view]] or an [[Framework:BI_Center:Create_Input_Mask\|input mask]] from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".		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_Analyse_View\|analyse 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 28:		Line 28:
	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''~~Eingabe~~'''</span>  Choose the style and as measure "in percent". Double click in the measure [in percent] in the short list und write > 5.		\|<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 ~~contion~~ "Variance negative" and "Normal".		Repeat this step for the condition "Variance negative" and "Normal".
	\|}		\|}

Admin at 12:32, 23 November 2010

2010-11-23T12:32:25Z

← Older revision		Revision as of 14:32, 23 November 2010
Line 1:		Line 1:
	With the support of the "Conditional Formatting Assistant" you can define different styles for each measure. You open this assistent in an [[Framework:BI_Center:Create_Analyse_View\|analyse view]] or an [[Framework:BI_Center:Create_Input_Mask\|input mask]] from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".		With the support of the "Conditional Formatting Assistant" you can define different styles for each measure. You open this assistent in an [[Framework:BI_Center:Create_Analyse_View\|analyse view]] or an [[Framework:BI_Center:Create_Input_Mask\|input mask]] from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".

	~~[[image:Fw_BI_Center Matrix Sicht Designer04.jpg\|thumb\|center\|Framework, Conditional Formatting Assistent]]~~

	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.

Admin at 12:31, 23 November 2010

2010-11-23T12:31:15Z

← Older revision		Revision as of 14:31, 23 November 2010
Line 20:		Line 20:
	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''Input'''</span>  Choose the ~~right ccolor~~ therefor.		\|<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: ~~Definieren der Bedingungen~~===		===Step 2: Define your conditions===

	[[image:Fw_BI_Center Matrix Sicht Designer07.jpg\|thumb\|center\|Framework, ~~Bedingungen definieren~~]]		[[image:Fw_BI_Center Matrix Sicht Designer07.jpg\|thumb\|center\|Framework, Define conditions]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''Eingabe'''</span>  ~~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.		\|<span style="color: darkblue">'''Eingabe'''</span>  Choose the style and as measure "in percent". Double click in the measure [in percent] in the short list und write > 5.
	~~Wiederholen Sie den Vorgang für die Bedingungen „Abweichung negativ“ und „Normal“~~.		Repeat this step for the contion "Variance negative" and "Normal".
	\|}		\|}

	~~Die Bedingungen in der Übersicht~~:		Overview of the conditions:

	{\| style="width: 857px; height: 108px" cellspacing="1" cellpadding="3" width="857" border="1"		{\| style="width: 857px; height: 108px" cellspacing="1" cellpadding="3" width="857" border="1"
Line 41:		Line 41:
	\| style=background-color:#f6f6f6 \|'''Style'''		\| style=background-color:#f6f6f6 \|'''Style'''
	\| style=background-color:#f6f6f6 \|'''Measure'''		\| style=background-color:#f6f6f6 \|'''Measure'''
	\| style=background-color:#f6f6f6 \|'''~~Bedingung~~'''		\| style=background-color:#f6f6f6 \|'''Condition'''
	\|-		\|-
	\|~~Abweichung positiv~~		\|Variance positive
	\|~~Abweichung positiv~~		\|Variance positive
	\|in ~~Prozent~~		\|in percent
	\|[in ~~Prozent~~]>5		\|[in percent]>5
	\|-		\|-
	\|~~Abweichung negativ~~		\|Variance negative
	\|~~Abweichung negativ~~		\|Variance negative
	\|in ~~Prozent~~		\|in percent
	\|[in ~~Prozent~~]<5		\|[in percent]<5
	\|-		\|-
	\|Normal		\|Normal
	\|Normal		\|Normal
	\|in ~~Prozent~~		\|in percent
	\|[in ~~Prozent~~]>=-5 AND [in ~~Prozent~~]<=5		\|[in percent]>=-5 AND [in percent]<=5
	\|}		\|}

Line 62:		Line 62:
	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''~~Eingabe~~'''</span>  ~~Bestätigen Sie den Assistenten mit „Fertigstellen“~~.		\|<span style="color: darkblue">'''Input'''</span>  Close the assistant with "Finish".
	\|}		\|}

	[[image:Fw_BI_Center Matrix Sicht Designer08.jpg\|thumb\|center\|Framework, ~~Bedingte Formatierung~~]]		[[image:Fw_BI_Center Matrix Sicht Designer08.jpg\|thumb\|center\|Framework, Conditional Formatting]]

Admin at 12:17, 23 November 2010

2010-11-23T12:17:10Z

← Older revision		Revision as of 14:17, 23 November 2010
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.

	===~~Schritt~~ 1: ~~Definieren der Formate~~===		===Step 1: Define your formats===

	~~Es erfolgt die Erstellung der Formate~~.		You create the styles.

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''~~Eingabe~~'''</span>  ~~Öffnen Sie den Assistenten für bedingte Formatierungen über „StyleDefinition“ und legen Sie drei neue Formate an. Vergeben Sie die Bezeichnungen „Abweichung positiv“~~, ~~„Abweichung negativ“ und Normal“~~.		\|<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, ~~Anlegen der Formate~~]]		[[image:Fw_BI_Center Matrix Sicht Designer05.jpg\|thumb\|center\|Framework, Create styles]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''~~Eingabe~~'''</span>  ~~Vergeben Sie mit Hilfe des Farbauswahl-Dialoges die entsprechenden Hintergrundfarben „Grün, Rot und Weiß~~.		\|<span style="color: darkblue">'''Input'''</span>  Choose the right ccolor therefor.
			Choose "Next" and create three conditions and name them like the styles.
	\|}		\|}

	~~[[image:Fw_BI_Center Matrix Sicht Designer06.jpg\|thumb\|center\|Framework, Hintergrundfarbe festlegen]]~~		===Step 2: Definieren der Bedingungen===

	~~{\| {{Bausteindesign2}}~~
	\|-
	~~\|<span style~~=~~"color: darkblue">'''Eingabe'''</span>  Klicken Sie auf die Schaltfläche „Weiter“ und legen Sie drei Bedingungen an. Benennen Sie die Bedingungen wie die Formate.~~
	\|}

	==~~=Schritt~~ 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]]

Admin at 12:10, 23 November 2010

2010-11-23T12:10:17Z

← Older revision		Revision as of 14:10, 23 November 2010
Line 1:		Line 1:
	With the support of the "Conditional Formatting ~~Assistent~~" you can define different styles ~~fpr~~ each measure. You open this assistent in an [[Framework:BI_Center:Create_Analyse_View\|analyse view]] or an [[Framework:BI_Center:Create_Input_Mask\|input mask]] from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".		With the support of the "Conditional Formatting Assistant" you can define different styles for each measure. You open this assistent in an [[Framework:BI_Center:Create_Analyse_View\|analyse view]] or an [[Framework:BI_Center:Create_Input_Mask\|input mask]] from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".

	[[image:Fw_BI_Center Matrix Sicht Designer04.jpg\|thumb\|center\|Framework, Conditional Formatting Assistent]]		[[image:Fw_BI_Center Matrix Sicht Designer04.jpg\|thumb\|center\|Framework, Conditional Formatting Assistent]]

	The assistant contains two steps. In the first step ~~xou~~ define the styles, in the ~~secound~~ 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.

	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.

Admin at 12:09, 23 November 2010

2010-11-23T12:09:34Z

← Older revision		Revision as of 14:09, 23 November 2010
Line 1:		Line 1:
	With the support of the "Conditional Formatting Assistent" you can define different styles fpr each measure. You open this assistent in an [[Framework:BI_Center:Create_Analyse_View\|analyse view]] or an [[Framework:BI_Center:Create_Input_Mask\|input mask]] from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".		With the support of the "Conditional Formatting Assistent" you can define different styles fpr each measure. You open this assistent in an [[Framework:BI_Center:Create_Analyse_View\|analyse view]] or an [[Framework:BI_Center:Create_Input_Mask\|input mask]] from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".

	~~Mit Unterstützung des „Assistenten für bedingte Formatierungen“ können Sie für jedes Measure unterschiedliche Formatierungsrichtlinien erstellen.~~		[[image:Fw_BI_Center Matrix Sicht Designer04.jpg\|thumb\|center\|Framework, Conditional Formatting Assistent]]
	~~Sie rufen diesen Assistenten aus einer~~ [[~~Framework~~:~~BI_Center:Analysesicht_erstellen#Eigenschaften~~\|~~Analysesicht]] oder [[Framework:BI_Center:Eingabemaske_erstellen#Eigenschaften~~\|~~Eingabemaske]] über die allgemeinen Einstellung „[[~~Framework~~:BI_Center:Eingabemaske_-_Eigenschaften_allgemein\|StyleDefinitionObject~~]]~~“ auf.~~

	~~[[image:Fw_BI_Center Matrix Sicht Designer04~~.~~jpg\|thumb\|center\|Framework~~, ~~Assistent für bedingte Formatierungen]]~~		The assistant contains two steps. In the first step xou define the styles, in the secound step you define the conditions.

	~~Dieser Assistent besteht aus zwei Schritten. Im ersten Schritt wird das Layout der Formatierung erstellt, im zweiten Schritt erfolgt die Definition der Bedingung.~~		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 ~~diesem Beispiel wird eine bedingte Formatierung für das Measure „in Prozent“ erstellt~~. ~~Werte zwischen~~ +5% ~~und~~ -5% ~~werden mit einem weißen Hintergrund dargestellt~~. ~~Eine Abweichung kleiner als~~ -5% ~~wird rot ausgewiesen~~, ~~eine Abweichung größer als +~~5% ~~wird grün ausgewiesen~~.

	===Schritt 1: Definieren der Formate===		===Schritt 1: Definieren der Formate===

Admin at 12:05, 23 November 2010

2010-11-23T12:05:39Z

← Older revision		Revision as of 14:05, 23 November 2010
Line 1:		Line 1:
	With the support of the "Conditional Formatting Assistent" you can define different styles fpr each measure. You open this assistent in an [[Framework:~~Analyse view~~\|analyse view]] or an input mask from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".		With the support of the "Conditional Formatting Assistent" you can define different styles fpr each measure. You open this assistent in an [[Framework:BI_Center:Create_Analyse_View\|analyse view]] or an [[Framework:BI_Center:Create_Input_Mask\|input mask]] from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".

	Mit Unterstützung des „Assistenten für bedingte Formatierungen“ können Sie für jedes Measure unterschiedliche Formatierungsrichtlinien erstellen.		Mit Unterstützung des „Assistenten für bedingte Formatierungen“ können Sie für jedes Measure unterschiedliche Formatierungsrichtlinien erstellen.

Admin at 12:04, 23 November 2010

2010-11-23T12:04:25Z

← Older revision		Revision as of 14:04, 23 November 2010
Line 1:		Line 1:
			With the support of the "Conditional Formatting Assistent" you can define different styles fpr each measure. You open this assistent in an [[Framework:Analyse view\|analyse view]] or an input mask from the property "[[Framework:BI_Center:Input_Mask_-_General_properties\|StyleDefinitionObject]]".

	Mit Unterstützung des „Assistenten für bedingte Formatierungen“ können Sie für jedes Measure unterschiedliche Formatierungsrichtlinien erstellen.		Mit Unterstützung des „Assistenten für bedingte Formatierungen“ können Sie für jedes Measure unterschiedliche Formatierungsrichtlinien erstellen.
	Sie rufen diesen Assistenten aus einer [[Framework:BI_Center:Analysesicht_erstellen#Eigenschaften\|Analysesicht]] oder [[Framework:BI_Center:Eingabemaske_erstellen#Eigenschaften\|Eingabemaske]] über die allgemeinen Einstellung „[[Framework:BI_Center:Eingabemaske_-_Eigenschaften_allgemein\|StyleDefinitionObject]]“ auf.		Sie rufen diesen Assistenten aus einer [[Framework:BI_Center:Analysesicht_erstellen#Eigenschaften\|Analysesicht]] oder [[Framework:BI_Center:Eingabemaske_erstellen#Eigenschaften\|Eingabemaske]] über die allgemeinen Einstellung „[[Framework:BI_Center:Eingabemaske_-_Eigenschaften_allgemein\|StyleDefinitionObject]]“ auf.