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

From CoPlanner 10
Jump to navigationJump to search
No edit summary
No edit summary
 
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]]"

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: