Framework:BI Center:Create Input Mask

From CoPlanner 11
Jump to navigationJump to search


An input mask differs from analysis view in the place of storage and no possibility to input data. In an input mask it is possible to enter data. All input masks are located in the folder "Input Masks", therefore they are available in the Navigation Designer und can be opened from the ribbon. To Create a new analyze view open the BI Center. The basis of every input mask is a data object. As a data object, the following are available to you: CoPlanner cubes, CoPlanner tables and OLAP cubes. Input maske only can be created by PowerUser, Partner and Manufacturer.

Elements and Functions

Design

As an example, in this section you will create a input view with the CoPlanner cube "My revenues".

Input  Select the menu item "Create Input Mask" from the context menu of the CoPlanner cube "My revenues". Confirm the caption "Mask My revenues" with OK.

The analysis view is created:

BI-Center, Initial view of an input mask

After you have selected a data object, the dimensions that can be used as axis dimensions or filters will be available in the left-hand pane.

Additionally, the measures that can be displayed or hidden will be available.

Elements – dimensions and measures – that do not have an associated icon () will not be available here. Measures without an icon will not be shown, and dimensions without an icon will be ignored. You can rotate the axes by clicking on the icon. To transfer only the measure dimension to the opposite axis, press and hold the Ctrl key. To use a dimension as an axis dimension, drag the dimension to the position of the desired axis and drop it there.

BI-Center, Dimension on axis

To use a dimension as a filter, drag the dimension to the filter area instead of an axis.

BI-Center, Dimension as filter

If you want to display fewer measures, simply click on the measure you wish to hide.

To display the hidden measure again, click on it again.

You can add dimensions as filters without using drag & drop. The procedure is identical to showing or hiding measures, except that, in this case, the dimension must be selected.

If a dimension was added as a filter, the dimension can be removed again by double-clicking on it in the filter area.

BI-Center, Remoce dimension

You can also use filter dimensions as axis dimensions by means of drag & drop. To do so, simply click on the dimension in the filter, hold the left mouse key, and drag the dimension to the desired axis. When the desired position is highlighted, release the left mouse key. The dimension will be inserted and will now serve as a dimension on the axis.

BI-Center, Move dimansion from filter are to axis

To change the order of the measures (fields), click on the measure you want to move and drag it to the desired location. A bold black line will display the current position where the measure will be inserted when you release the left mouse button.

Additionally, you can change the order of the measures in the “Select measures” dialogue. Open the dialogue by clicking on the “Select measure” button. Now change the position of the selected measure using the Up and Down arrow icons.

BI-Center, Reorder measure

Dimensions can be positioned on the axis (to the left or right of a previously inserted dimension), or they can replace other axis dimensions. The border around the dimensions on the axis shows the position to which the dimensions will be moved.

To edit the definition of the axis, right-click on an axis dimension to display a context menu.

Input  Drag the dimension Products on vertical axis and period on horizontal axis. Choose following dimensions as filter: Scenario, Companies, Customers/Countries, Kind of revenues, Scenario to compare and the period.

If there is shown the group Restore in an input mask or analysis view, there are measures or filters without a valid data object.

Group Restore

You can delete this definition or apply a new data abject. According to the type the dialogue offers the available data objects.

If there are formulas not able to be executed, an error provider will be shown on the right corner after the first click in the mask. The error provider shows the hint.


Properties

The properties of an input mask are as follows: