Framework:BI Center:Create Single Row Mask: Difference between revisions
No edit summary |
No edit summary |
||
| (19 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
In the single row mask , the entries in a table are shown in single rows. The single row mask offers the possibility to group fields and navigate with arrows unlike the [[Enterprise Edition:Input mask|input mask]] and [[Enterprise Edition:Analysis View|analysis view]]. | |||
[[image:Fw_BI_Center Gruppieren Einzelsatzmaske02.jpg|thumb|center|Framework, BI Center, Single Row Mask]] | |||
To create a new single row mask open the [[Framework:BI_Center|BI Center]]. The basis of every row view is the data object "[[Framework:BI_Center:CoPlanner_Table|CoPlanner table]]". If you save the single row mask into the folder "Input Masks", you can choose the mask in the [[Framework:Navigation_Designer|Navigation Designer]] and open the mask via the ribbon. | |||
[[ | |||
==Elements and Functions== | |||
:*[[Framework:Ribbon_single_row_mask|Ribbon]] | |||
:*[[Framework::Context_Menu_single_row_mask|Context Menu]] | |||
:*[[Framework:Navigation_single_row_maske|Navigation]] | |||
== | ==Design== | ||
In this example the data source [[Framework:BI_Center:CoPlanner_Table|CoPlanner table]] „Darlehen_Stammdaten_PLAN“ is used to create the single row mask. The base of a single row mask is a row view and changing a property turns the row view in a single row mask. The single row mask in this example offers a loan planning with grouped measures. | |||
In | |||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Entry'''</span> Click with the right mouse button on the “Input masks” directory and choose the “Line view” command from the “New” context menu. | ||
Give the dialog “Line view” the name “My single row mask” and confirm with OK. | |||
|} | |} | ||
[[image:Fw_BI_Center Create Single row mask.jpg|thumb|center|Framework, BI Center, Create a single row mask]] | |||
[[image:Fw_BI_Center | |||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Entry'''</span> Check out the mask and from the “Data objects” tree, select the CoPlanner table “Darlehen_Stammdaten_PLAN“, change the | ||
property "DetailAreaVisible" to Yes. | |||
|} | |} | ||
The following screen is presented: | |||
[[image:Fw_BI_Center Initial view of a single row mask.jpg|thumb|center|Framework, BI Center, Initial view of a single row mask]] | |||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Entry'''</span> In the “Data objects” tree, click the filter icon [[Image:Icon_Filtersymbol.jpg]] to hide elements except "Plan", "Companies" and "Profit Center/Cost Center" from the filter bar. | ||
|} | |} | ||
Open the [[Framework:BI_Center:Single_Row_Mask_Editor|Single Row Mask Editor]] to remove and group measures. | |||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Entry'''</span> To open the [[Framework:BI_Center:Single_Row_Mask_Editor|Single Row Mask Editor]] select "Configure mask layout" from the context menu of a field caption or empty space and move the editor to the left side. Activate the second tab "Layout Tree View". | ||
|} | |} | ||
The following screen is presented: | |||
[[image:Fw_BI_Center | [[image:Fw_BI_Center Single Row Mask Editor .jpg|thumb|center|Framework, BI Center, Single Row Mask Editor ]] | ||
In | In the steps that follow, sort and group then measures as listed below:<br> | ||
''' | '''Loan planning''' | ||
:* | :*Kind of loan | ||
:* | :*Type of loan | ||
:* | :*Loan height | ||
''' | '''Maturity''' | ||
:* | :*Admission | ||
:* | :*Date duration end | ||
''' | '''Repayment''' | ||
:* | :*Beginning | ||
:* | :*Periodicity | ||
:* | :*Repayment | ||
''' | '''Interest''' | ||
:* | :*Interest rate | ||
:* | :*Interest charges | ||
:* | :*Periodicity | ||
:* | :*Interest days | ||
''' | '''Other''' | ||
:* | :*Comment | ||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Entry'''</span> Change the order of measures by selecting them and move to the specified position. Select the measures "Kind of loan", "Type of loan", "Loan height" and choose "Group" from the context menu. Insert "Loan planning" in the property "CustomizationFormText" and "Text". | ||
|} | |} | ||
The following screen is presented: | |||
[[image:Fw_BI_Center | [[image:Fw_BI_Center Measure group.jpg|thumb|center|Framework, BI Center, Measure group]] | ||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Entry'''</span> Create the remaining groups in the same way. To resize the field "Comment" change the property to "TextMultiLine" from the context menu. | ||
|} | |} | ||
The following screen is presented: | |||
[[image:Fw_BI_Center Gruppieren Einzelsatzmaske01.jpg|thumb|center|Framework, BI Center, | [[image:Fw_BI_Center Gruppieren Einzelsatzmaske01.jpg|thumb|center|Framework, BI Center, All measures grouped]] | ||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Entry'''</span> You can create a column view by move the mesaure to the specified position, shown by the mouse cursor. Afterwards move "Empty Space Items" between the groups. | ||
|} | |} | ||
The following screen is presented: | |||
[[image:Fw_BI_Center Single row mask with empty space items.jpg|thumb|center|Framework, BI Center, Single row mask with empty space items]] | |||
{| {{Bausteindesign2}} | {| {{Bausteindesign2}} | ||
|- | |- | ||
|<span style="color: darkblue">''' | |<span style="color: darkblue">'''Entry'''</span> To change the background color of the field captions choose "Color" from the context menu. To adjust the measure caption use the properties "CustomizationFormText" and "Text". | ||
|} | |} | ||
= | {| {{Bausteindesign1}} | ||
|- | |||
| <span style="color: darkblue;">'''Hint'''</span> For text fields you can use ''Ctrl+A'' for marking the row and ''Del'' for deleting since CoPlanner Enterprise version 9.4. | |||
|} | |||
==Properties== | |||
: | The properties of a single row mask are as follows: | ||
- | :*[[Framework:SingleRowMask General properties|General properties]] | ||
:*[[Framework:BI Center:SingleRowMask-Measure properties|Measure properties ]] | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
Latest revision as of 16:33, 17 March 2015
In the single row mask , the entries in a table are shown in single rows. The single row mask offers the possibility to group fields and navigate with arrows unlike the input mask and analysis view.
To create a new single row mask open the BI Center. The basis of every row view is the data object "CoPlanner table". If you save the single row mask into the folder "Input Masks", you can choose the mask in the Navigation Designer and open the mask via the ribbon.
Elements and Functions
Design
In this example the data source CoPlanner table „Darlehen_Stammdaten_PLAN“ is used to create the single row mask. The base of a single row mask is a row view and changing a property turns the row view in a single row mask. The single row mask in this example offers a loan planning with grouped measures.
| Entry Click with the right mouse button on the “Input masks” directory and choose the “Line view” command from the “New” context menu.
Give the dialog “Line view” the name “My single row mask” and confirm with OK. |
| Entry Check out the mask and from the “Data objects” tree, select the CoPlanner table “Darlehen_Stammdaten_PLAN“, change the
property "DetailAreaVisible" to Yes. |
The following screen is presented:
| Entry In the “Data objects” tree, click the filter icon |
Open the Single Row Mask Editor to remove and group measures.
| Entry To open the Single Row Mask Editor select "Configure mask layout" from the context menu of a field caption or empty space and move the editor to the left side. Activate the second tab "Layout Tree View". |
The following screen is presented:
In the steps that follow, sort and group then measures as listed below:
Loan planning
- Kind of loan
- Type of loan
- Loan height
Maturity
- Admission
- Date duration end
Repayment
- Beginning
- Periodicity
- Repayment
Interest
- Interest rate
- Interest charges
- Periodicity
- Interest days
Other
- Comment
| Entry Change the order of measures by selecting them and move to the specified position. Select the measures "Kind of loan", "Type of loan", "Loan height" and choose "Group" from the context menu. Insert "Loan planning" in the property "CustomizationFormText" and "Text". |
The following screen is presented:
| Entry Create the remaining groups in the same way. To resize the field "Comment" change the property to "TextMultiLine" from the context menu. |
The following screen is presented:
| Entry You can create a column view by move the mesaure to the specified position, shown by the mouse cursor. Afterwards move "Empty Space Items" between the groups. |
The following screen is presented:
| Entry To change the background color of the field captions choose "Color" from the context menu. To adjust the measure caption use the properties "CustomizationFormText" and "Text". |
| Hint For text fields you can use Ctrl+A for marking the row and Del for deleting since CoPlanner Enterprise version 9.4. |
Properties
The properties of a single row mask are as follows: