Framework:BI Center:Create Row View: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
← Older edit
VisualWikitext
No edit summary
No edit summary
 
(7 intermediate revisions by the same user not shown)
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]]"
Line 7: Line 7:


:*[[Framework:Ribbon_Row_View|Ribbon]]
:*[[Framework:Ribbon_Row_View|Ribbon]]
:*[[Framework:Centext_Menu_Row_View|Centext Menu]]
:*[[Framework:Context_Menu_Row_View|Context Menu]]




==Aufbau==
==Design==


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 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> &nbsp;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> &nbsp;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> &nbsp;Wählen Sie aus dem Baum „Datenobjekte“ die CoPlanner Tabelle „Umsatzerloese_Plan“.
|<span style="color: darkblue">'''Entry'''</span> &nbsp;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> &nbsp;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> &nbsp;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 Zeilen Sicht gruppiert nach der Zeit.jpg|thumb|center|Framework, BI Center, Zeilensicht – gruppiert nach der Zeit]]
[[image:Fw_BI_Center Row view grouped according to time.jpg|thumb|center|Framework, BI Center, Row view – grouped according to time]]


==Eigenschaften==
==Properties==
 
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]]


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]]




Latest revision as of 15:36, 24 November 2010

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 input mask and analysis view.

To create a new row view open the BI Center. The basis of every row view is the data object "CoPlanner table"


Elements and Functions


Design

In this example the data source CoPlanner table „Umsatzerloese_Plan“ is used to create the row view and it will be grouped by the period.

Entry  Click with the right mouse button on the “My objects” directory and choose the “Line view” command from the “New” context menu.

Give the dialog “Line view” the name “My line view” and confirm with OK.


Error creating thumbnail: File missing
Framework, BI Center, creating a row view
Entry  From the “Data objects” tree, select the CoPlanner table “Sales proceeds_Plan“.

The following screen is presented:

Error creating thumbnail: File missing
Framework, BI Center, Initial view of the row view


Entry  In the “Data objects” tree, click the filter icon to hide the elements “payment key” and “VAT rates” from the filter bar.

If you click into the free area underneath the measure in the “Data objects” tree, you obtain the general properties for this line view. Under the property “AggregateDimension”, select “Time” from the list. Click the “Save” button and “Update”.

The following screen is shown:

Error creating thumbnail: File missing
Framework, BI Center, Row view – grouped according to time

Properties

The properties of a row view are as follows:

Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Framework:BI_Center:Create_Row_View&oldid=11737"