Framework:BI Center:Create Row View - Revision history

Admin at 14:36, 24 November 2010

2010-11-24T14:36:03Z

← Older revision		Revision as of 15:36, 24 November 2010
Line 1:		Line 1:
	Row views are masks that display table entries in line form. The row view offers the possibility to group data according to one or more dimensions unlike the [[Enterprise Edition:Input mask\|input mask]] and [[Enterprise Edition:~~Analyse~~ View\|~~analyse~~ view]].		Row views are masks that display table entries in line form. The row view offers the possibility to group data according to one or more dimensions unlike the [[Enterprise Edition:Input mask\|input mask]] and [[Enterprise Edition:Analysis View\|analysis view]].

	To create a new row view open the [[Framework:BI_Center\|BI Center]]. The basis of every row view is the data object "[[Framework:BI_Center:CoPlanner_Table\|CoPlanner table]]"		To create a new row view open the [[Framework:BI_Center\|BI Center]]. The basis of every row view is the data object "[[Framework:BI_Center:CoPlanner_Table\|CoPlanner table]]"

Admin at 09:21, 23 November 2010

2010-11-23T09:21:49Z

← Older revision		Revision as of 10:21, 23 November 2010
Line 50:		Line 50:
	:*[[Framework:BI Center:Row View - General properties\|General properties of a row view]]		:*[[Framework:BI Center:Row View - General properties\|General properties of a row view]]
	:*[[Framework:BI Center:Row View - Measure properties\|Measure properties]]		:*[[Framework:BI Center:Row View - Measure properties\|Measure properties]]


	~~====Properties of the row view====~~

	~~In the right part of the designer, the properties of the row view are shown.~~

	~~'''AggregateDimension'''~~

	Dimension, according to which grouping is performed. For instance if time is selected, all datasets whose other characteristics – i.e. except for the time – are identical, will be consolidated. The annual total is shown, where required the individual datasets can be opened up.

	~~[[image:Fw_BI_Center Row view AggregateDimension.jpg\|thumb\|center\|Framework, BI Center, Row view – AggregateDimension]]~~

	~~'''AutomaticSearchAfterFirstTimeOpen'''~~

	~~Defines if the data are loaded from the server immediately when the view is opened. If this option has not been set, you must click on the “Update” button after opening the view.~~

	~~'''AutomaticSearchAfterSave'''~~

	~~Defines if the data are loaded from the server immediately after saving the view. If this option has not been set, you must click on the “Update” button after saving the view.~~

	~~'''FiltermeasureSettings'''~~

	~~Shows all columns and their settings if used as filter or measure.~~

	~~'''MakroDescriptorSettings'''~~

	~~Here, macros can be added to the view. They are provided for the user in the ribbons.~~

	~~'''AllowSaveNewDelete'''~~

	~~Defines which of the buttons “Save”, “New” and “Delete” is available.~~

	~~'''ShowLookUpMode'''~~

	~~If system columns are active, it is possible to define here if the internal keys are shown or whether they are transformed into readable values.~~

	~~'''ShowSystemsColumns'''~~

	~~Defines whether the system columns are available.~~

	~~'''RefreshResultAfterFilterChange'''~~

	~~Defines if the server loads the data after a filter change or if it is necessary to press “Update” first.~~

	~~====Properties of the filters or measures====~~

	~~'''FilterCaption'''~~
	~~Defines the name of the filter such as it is shown in the user interface.~~

	~~'''FilterName'''~~

	~~Shows the system name of the filter~~

	~~'''FilterReadOnly'''~~

	~~Defines whether the user can change the filter setting.~~

	~~'''FilterSessionKey'''~~

	~~Defines the default value of the filters when the view is opened. All CoPlanner environment variables including application properties are available for selection.~~

	~~'''FilterVisibilityCanBeChanged'''~~

	~~Defines if the filter can be hidden. Even if the filter is hidden, it nevertheless affects the result of the query.~~

	~~'''FilterVisible'''~~

	~~Defines whether the filter is visible or not.~~

	~~==Eigenschaften==~~

	~~Die Eigenschaften in einer Zeilensicht betreffen folgende Bereiche:~~

	~~:*[[Framework:BI_Center:Zeilensicht - Eigenschaften allgemein\|Allgemeine Eigenschaften der Zeilensicht]]~~
	~~:*[[Framework:BI_Center:Zeilensicht - Eigenschaften Measure\|Eigenschaften der Measure]]~~

Admin at 08:38, 23 November 2010

2010-11-23T08:38:37Z

← Older revision		Revision as of 09:38, 23 November 2010
Line 43:		Line 43:

	[[image:Fw_BI_Center Row view grouped according to time.jpg\|thumb\|center\|Framework, BI Center, Row view – grouped according to time]]		[[image:Fw_BI_Center Row view grouped according to time.jpg\|thumb\|center\|Framework, BI Center, Row view – grouped according to time]]

			==Properties==

			The properties of a row view are as follows:

			:*[[Framework:BI Center:Row View - General properties\|General properties of a row view]]
			:*[[Framework:BI Center:Row View - Measure properties\|Measure properties]]


	====Properties of the row view====		====Properties of the row view====

Admin at 08:34, 23 November 2010

2010-11-23T08:34:26Z

← Older revision		Revision as of 09:34, 23 November 2010
Line 13:		Line 13:

	In this example the data source [[Framework:BI_Center:CoPlanner_Table\|CoPlanner table]] „Umsatzerloese_Plan“ is used to create the row view and it will be grouped by the period.		In this example the data source [[Framework:BI_Center:CoPlanner_Table\|CoPlanner table]] „Umsatzerloese_Plan“ is used to create the row view and it will be grouped by the period.


	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''~~Eingabe~~'''</span>  ~~Klicken Sie mit der rechten Maustaste auf das Verzeichnis „Meine Objekte“ und wählen Sie aus dem Kontextmenü „Neu“ den Befehl „Zeilensicht“~~.		\|<span style="color: darkblue">'''Entry'''</span>  Click with the right mouse button on the “My objects” directory and choose the “Line view” command from the “New” context menu.
	~~Vergeben Sie im Dialog „Zeilensicht“ die Bezeichnung „Meine Zeilensicht“ und bestätigen Sie mit~~ OK.		Give the dialog “Line view” the name “My line view” and confirm with OK.
	\|}		\|}


	[[image:Fw_BI_Center ~~Anlegen einer Zeilen Sicht~~.jpg\|thumb\|center\|Framework, BI Center, ~~Anlegen einer Zeilensicht~~]]		[[image:Fw_BI_Center creating a row view.jpg\|thumb\|center\|Framework, BI Center, creating a row view]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''~~Eingabe~~'''</span>  ~~Wählen Sie aus dem Baum „Datenobjekte“ die~~ CoPlanner ~~Tabelle „Umsatzerloese_Plan“~~.		\|<span style="color: darkblue">'''Entry'''</span>  From the “Data objects” tree, select the CoPlanner table “Sales proceeds_Plan“.
	\|}		\|}

	~~Sie erhalten folgende Ansicht~~:		The following screen is presented:

	[[image:Fw_BI_Center ~~Initiale Ansicht der Zeilen Sicht~~.jpg\|thumb\|center\|Framework, BI Center, ~~Initiale Ansicht der Zeilensicht~~]]		[[image:Fw_BI_Center Initial view of the row view.jpg\|thumb\|center\|Framework, BI Center, Initial view of the row view]]


	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''~~Eingabe~~'''</span>  ~~Klicken Sie im Baum „Datenobjekte“ auf das Filtersymbol~~ [[Image:Icon_Filtersymbol.jpg]] ~~zum Ausblenden der jeweiligen Elemente, „Zahlungsschlüssel“ und Umsatzsteuersätze“ aus der Filterleiste~~.		\|<span style="color: darkblue">'''Entry'''</span>  In the “Data objects” tree, click the filter icon [[Image:Icon_Filtersymbol.jpg]] to hide the elements “payment key” and “VAT rates” from the filter bar.
	~~Wenn Sie im Baum „Datenobjekte“~~ in ~~den freien Bereich unterhalb der Measure klicken~~, ~~bekommen Sie die allgemeinen Eigenschaften zu dieser Zeilensicht~~.		If you click into the free area underneath the measure in the “Data objects” tree, you obtain the general properties for this line view.
	~~Wählen Sie bei der Eigenschaft „AggregateDimension“ aus der Liste den Eintrag „Zeit“~~. ~~Klicken Sie auf die Schaltfläche „Speichern“ “ und schalten Sie in die Normalansicht~~.		Under the property “AggregateDimension”, select “Time” from the list. Click the “Save” button and “Update”.
	\|}		\|}

	~~Sie erhalten folgende Ansicht~~:		The following screen is shown:

			[[image:Fw_BI_Center Row view grouped according to time.jpg\|thumb\|center\|Framework, BI Center, Row view – grouped according to time]]

			====Properties of the row view====

			In the right part of the designer, the properties of the row view are shown.

			'''AggregateDimension'''

			Dimension, according to which grouping is performed. For instance if time is selected, all datasets whose other characteristics – i.e. except for the time – are identical, will be consolidated. The annual total is shown, where required the individual datasets can be opened up.

			[[image:Fw_BI_Center Row view AggregateDimension.jpg\|thumb\|center\|Framework, BI Center, Row view – AggregateDimension]]

			'''AutomaticSearchAfterFirstTimeOpen'''

			Defines if the data are loaded from the server immediately when the view is opened. If this option has not been set, you must click on the “Update” button after opening the view.

			'''AutomaticSearchAfterSave'''

			Defines if the data are loaded from the server immediately after saving the view. If this option has not been set, you must click on the “Update” button after saving the view.

			'''FiltermeasureSettings'''

			Shows all columns and their settings if used as filter or measure.

			'''MakroDescriptorSettings'''

			Here, macros can be added to the view. They are provided for the user in the ribbons.

			'''AllowSaveNewDelete'''

			Defines which of the buttons “Save”, “New” and “Delete” is available.

			'''ShowLookUpMode'''

			If system columns are active, it is possible to define here if the internal keys are shown or whether they are transformed into readable values.

			'''ShowSystemsColumns'''

			Defines whether the system columns are available.

			'''RefreshResultAfterFilterChange'''

			Defines if the server loads the data after a filter change or if it is necessary to press “Update” first.

			====Properties of the filters or measures====

			'''FilterCaption'''
			Defines the name of the filter such as it is shown in the user interface.

			'''FilterName'''

			Shows the system name of the filter

			'''FilterReadOnly'''

			Defines whether the user can change the filter setting.

			'''FilterSessionKey'''

			Defines the default value of the filters when the view is opened. All CoPlanner environment variables including application properties are available for selection.

			'''FilterVisibilityCanBeChanged'''

			Defines if the filter can be hidden. Even if the filter is hidden, it nevertheless affects the result of the query.

			'''FilterVisible'''

	~~[[image:Fw_BI_Center Zeilen Sicht gruppiert nach der Zeit~~.~~jpg\|thumb\|center\|Framework, BI Center, Zeilensicht – gruppiert nach der Zeit]]~~		Defines whether the filter is visible or not.

	==Eigenschaften==		==Eigenschaften==

Admin at 08:33, 23 November 2010

2010-11-23T08:33:19Z

← Older revision		Revision as of 09:33, 23 November 2010
Line 12:		Line 12:
	==Design==		==Design==

	In this example the ~~design of the row view~~		In this example the data source [[Framework:BI_Center:CoPlanner_Table\|CoPlanner table]] „Umsatzerloese_Plan“ is used to create the row view and it will be grouped by the period.
	~~In diesem Beispiel wird der Aufbau einer Zeilensicht auf Basis des Datenobjektes~~ [[Framework:BI_Center:~~CoPlanner_Tabelle~~\|CoPlanner ~~Tabelle~~]] „Umsatzerloese_Plan“. ~~Gruppiert wird diese Zeilensicht nach der Zeit.~~

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}

Admin at 08:28, 23 November 2010

2010-11-23T08:28:51Z

← Older revision		Revision as of 09:28, 23 November 2010
Line 10:		Line 10:


			==Design==

			In this example the design of the row view
	~~==Aufbau==~~

	In diesem Beispiel wird der Aufbau einer Zeilensicht auf Basis des Datenobjektes [[Framework:BI_Center:CoPlanner_Tabelle\|CoPlanner Tabelle]] „Umsatzerloese_Plan“. Gruppiert wird diese Zeilensicht nach der Zeit.		In diesem Beispiel wird der Aufbau einer Zeilensicht auf Basis des Datenobjektes [[Framework:BI_Center:CoPlanner_Tabelle\|CoPlanner Tabelle]] „Umsatzerloese_Plan“. Gruppiert wird diese Zeilensicht nach der Zeit.

Admin at 08:21, 23 November 2010

2010-11-23T08:21:13Z

← Older revision		Revision as of 09:21, 23 November 2010
Line 5:		Line 5:

	==Elements and Functions==		==Elements and Functions==

	~~:*[[Framework:Ribbon_Row_View\|Ribbon]]~~
	~~:*[[Framework:Centext_Menu_Row_View\|Centext Menu]]~~

	:*[[Framework:Ribbon_Row_View\|Ribbon]]		:*[[Framework:Ribbon_Row_View\|Ribbon]]

Admin at 08:20, 23 November 2010

2010-11-23T08:20:58Z

← Older revision		Revision as of 09:20, 23 November 2010
Line 8:		Line 8:
	:*[[Framework:Ribbon_Row_View\|Ribbon]]		:*[[Framework:Ribbon_Row_View\|Ribbon]]
	:*[[Framework:Centext_Menu_Row_View\|Centext Menu]]		:*[[Framework:Centext_Menu_Row_View\|Centext Menu]]

			:*[[Framework:Ribbon_Row_View\|Ribbon]]
			:*[[Framework:Context_Menu_Row_View\|Context Menu]]

Admin at 08:20, 23 November 2010

2010-11-23T08:20:13Z

← Older revision		Revision as of 09:20, 23 November 2010
Line 1:		Line 1:
	Row views are masks that display table entries in line form. The row view offers the possibility to group data according to one or more dimensions unlike the [[Enterprise Edition:Input mask\|input mask]] and [[Enterprise Edition:Analyse View\|analyse view]].		Row views are masks that display table entries in line form. The row view offers the possibility to group data according to one or more dimensions unlike the [[Enterprise Edition:Input mask\|input mask]] and [[Enterprise Edition:Analyse View\|analyse view]].

	~~In einer Zeilensicht werden die Einträge einer Tabelle in Zeilenform dargestellt. Sie bietet im Gegensatz zur~~ [[Framework:BI_Center~~:Eingabemaske_erstellen~~\|~~Eingabemaske~~]] ~~oder~~ [[Framework:BI_Center:~~Analysesicht_erstellen~~\|~~Analysesicht~~]]~~, die Möglichkeit zur Gruppierung nach einer oder mehreren Dimensionen.~~		To create a new row view open the [[Framework:BI_Center\|BI Center]]. The basis of every row view is the data object "[[Framework:BI_Center:CoPlanner_Table\|CoPlanner table]]"

	~~Zum Erstellen einer Zeilensicht öffnen Sie das [[Framework:BI_Center\|BI-Center]]. Grundlage jeder Zeilensicht ist das Datenobjekt [[Framework:BI_Center:CoPlanner_Tabelle\|CoPlanner Tabellen]].~~

	==~~Elemente und Funktionen~~==		==Elements and Functions==
	:*[[Framework:~~Ribbon_Zeilensicht~~\|Ribbon]]
	:*[[Framework:~~Kontextmenü_Zeilensicht~~\|~~Kontextmenü~~]]		:*[[Framework:Ribbon_Row_View\|Ribbon]]
			:*[[Framework:Centext_Menu_Row_View\|Centext Menu]]

Admin at 08:17, 23 November 2010

2010-11-23T08:17:18Z

← Older revision		Revision as of 09:17, 23 November 2010
Line 1:		Line 1:
			Row views are masks that display table entries in line form. The row view offers the possibility to group data according to one or more dimensions unlike the [[Enterprise Edition:Input mask\|input mask]] and [[Enterprise Edition:Analyse View\|analyse view]].

	In einer Zeilensicht werden die Einträge einer Tabelle in Zeilenform dargestellt. Sie bietet im Gegensatz zur [[Framework:BI_Center:Eingabemaske_erstellen\|Eingabemaske]] oder [[Framework:BI_Center:Analysesicht_erstellen\|Analysesicht]], die Möglichkeit zur Gruppierung nach einer oder mehreren Dimensionen.		In einer Zeilensicht werden die Einträge einer Tabelle in Zeilenform dargestellt. Sie bietet im Gegensatz zur [[Framework:BI_Center:Eingabemaske_erstellen\|Eingabemaske]] oder [[Framework:BI_Center:Analysesicht_erstellen\|Analysesicht]], die Möglichkeit zur Gruppierung nach einer oder mehreren Dimensionen.

← Older revision		Revision as of 09:20, 23 November 2010
Line 8:		Line 8:
	:*[[Framework:Ribbon_Row_View\|Ribbon]]		:*[[Framework:Ribbon_Row_View\|Ribbon]]
	:*[[Framework:Centext_Menu_Row_View\|Centext Menu]]		:*[[Framework:Centext_Menu_Row_View\|Centext Menu]]

			:*[[Framework:Ribbon_Row_View\|Ribbon]]
			:*[[Framework:Context_Menu_Row_View\|Context Menu]]

← Older revision		Revision as of 09:20, 23 November 2010
Line 1:		Line 1:
	Row views are masks that display table entries in line form. The row view offers the possibility to group data according to one or more dimensions unlike the [[Enterprise Edition:Input mask\|input mask]] and [[Enterprise Edition:Analyse View\|analyse view]].		Row views are masks that display table entries in line form. The row view offers the possibility to group data according to one or more dimensions unlike the [[Enterprise Edition:Input mask\|input mask]] and [[Enterprise Edition:Analyse View\|analyse view]].

	~~In einer Zeilensicht werden die Einträge einer Tabelle in Zeilenform dargestellt. Sie bietet im Gegensatz zur~~ [[Framework:BI_Center~~:Eingabemaske_erstellen~~\|~~Eingabemaske~~]] ~~oder~~ [[Framework:BI_Center:~~Analysesicht_erstellen~~\|~~Analysesicht~~]]~~, die Möglichkeit zur Gruppierung nach einer oder mehreren Dimensionen.~~		To create a new row view open the [[Framework:BI_Center\|BI Center]]. The basis of every row view is the data object "[[Framework:BI_Center:CoPlanner_Table\|CoPlanner table]]"

	~~Zum Erstellen einer Zeilensicht öffnen Sie das [[Framework:BI_Center\|BI-Center]]. Grundlage jeder Zeilensicht ist das Datenobjekt [[Framework:BI_Center:CoPlanner_Tabelle\|CoPlanner Tabellen]].~~

	==~~Elemente und Funktionen~~==		==Elements and Functions==
	:*[[Framework:~~Ribbon_Zeilensicht~~\|Ribbon]]
	:*[[Framework:~~Kontextmenü_Zeilensicht~~\|~~Kontextmenü~~]]		:*[[Framework:Ribbon_Row_View\|Ribbon]]
			:*[[Framework:Centext_Menu_Row_View\|Centext Menu]]