WebApps:Input Mask

Available from 9.5 HF 2.1

System requirements

The requirements can be found here.

Invocation

@Session_WebAppUrl@/pivottable/?pivotform=<mask name>

Example:

https://servername:4444/coplanner/pivottable/?pivotform=EM Bilanz PLAN

Hint  upper and lower case of the mask name has to be correct otherwise the mask will not open.

Extended invocation

• Title: Name which will be displayed instead of the mask name
• Description: Description which will be displayed optionally below the title/mask name
• ShowFields: Defines if the fields area will be displayed while mask opening. Default is false.

From 9.5 HF 2.4:

• hideSessionHeader: Defines if the session header should be visible or not (true fades out the Session-Header). Default while opening is false

Example:

https://servername:4444/coplanner/pivottable/?pivotform=EM Bilanz PLAN&Title=Bilanz PLAN&Description=Plan your balance here&ShowFields=true

From 9.5 HF 2.8.1:

• disableFields: Defines if the fields area can be displayed or not ( true means that the fields area can not be displayed). Default is false.

From 9.5 HF 3.3:

• contextFilters: Defines filter values which are used while opening the mask
• contextDimensions: Defines elements of axes with which the mask will be opened

Example:

Transfer to filter time, filter operator =, element 2 and entity, filteroperator me+under, element 1

&contextFilters=timeeq 2 and entity mu 1

Transfer to axis time with elements 1,2,2010010101 and axis entity with 2

&contextDimensions=time :1,2,2010010101 and entity :2

When using " and " in filter name with transferred value or space this has to be done:

&contextFilters="My text filter" eq "Text with space"

&contextDimensions="My time and test dimension:1,2,2010010101"

Example for use in a calculated measure in a cube. The mask MAX_Rueckstellungen will be opened and filters SonstigeErloesundKostenarten, time and PC/KST transferred. Additionally the title Rückstellungen will be defined and the session transferred.

Link for the windows client:

IIF([ErloesKosten LC]<>0,'cop://name=Rückstellungen & aktion=Matrix Builder Eingabemaske & p1=MAX_Rueckstellungen_PLAN & p2= & p3= & p4=ContextFiltersetting:SonstigeErloesundKostenarten=[Attribut_SonstigeErloesundKostenarten]=2=FilterDim=SonstigeErloesundKostenarten|Zeit=[Attribut_Zeit]=2=FilterDim=Zeit|PC/KST=[Attribut_PCKST]=2=FilterDim=PCKST & frmlocation=Work & name=Rückstellungen',)

correspons to the Webclient:

IIF([ErloesKosten LC]<>0,'@Session_WebAppUrl@/pivottable/?pivotform=MAX_Rueckstellungen_PLAN&contextFilters="SonstigeErloesundKostenarten" mu [Attribut_SonstigeErloesundKostenarten] and "Zeit" mu [Attribut_Zeit] and "PC/KST" mu [Attribut_PCKST]&title=Rückstellungen&SessionID=@Session_ID@',)

Operators:

Filter operator	Invocation in context	Description
	mu	Selected element and all levels below will be displayed.
	mf	Selected element and one level below will be displayed.
	fu	All levels below the selected element will be displayed.
	un	One level below the selected element will be displayed.
=	eq	Only values from this dimension element will be displayed.
<>	ne	All values will be displayed but values from the selected filter element.

In data record masks these operators are available for value fields:

Filter operator	Invocation in context	Description
=	eq	Default "=" will be proposed and all data records will be displayed.
<	lt	Data records less than the entered value will be displayed.
>	gt	Data records bigger than the entered value will be displayed.
<=	le	Data records less or equal than the entered value will be displayed.
>=	ge	Data records bigger or equal than the entered value will be displayed.
<>	ne	Data records which are less or bigger than the entered value will be displayed.
LIKE	lk	Data records which include the entered expression will be displayed.

Menu

	Back to last page.
	Open/Close of display text of menu.
	Update of data in the mask.
	Fade in/Fade out filter area.
	Fade in/Fade out fields area.
	Activate/Deactivate null value suppression.
	Activate/Deactivate DrillThrough.
	Deletion of data.
	Back to superior mask.
	Opens a dialog to export mask in a .xlsx-file.
	Opens a dialog to export mask in a .csv-file.
	Exports mask to excel and proceeds an automatic login of the excel addin. Button is only visible if option AutomatedLoginAfterExcelExportAvailable is activated in the mask. CoPlanner Excel Addin has to be installed on the client side in order that works. Additionally in Excel the option 'Enable Protected View for files originating from the Internet' has to be disabled.
	Transposes the axes. To transfer measures only to the opposite axis, press the Ctrl key also.

Menu with display texts:

Design of the mask

Fields area

Using the fields area measures can be en-/disabled easily, filters can be added and removed, add and remove dimensions on axes, switch axes and assign measures to the X-Axis or Y-Axis. You can do this by using Drag & Drop the elements at the desired position.

The fields area can be en-/disabled with the menu. You can define if this area should be displayed as default via the URL.

Search

Using the search measures and dimension can be filtered by name.

Dimensionen

All available dimensions will be displayed here. By using Drag&Drop these dimensions can be moved to the desired position or to an area in the fields area below.

Measures

Hier werden die zur Verfügung stehenden Measures angezeigt. Über den Schalter vor den Measures können diese ein-/ausgeblendet werden. Mit dem angezeigten Namen "Alle" können Sie alle Measures mit nur einem Klick einblenden. Beim Ausblenden bleibt immer ein Measure aktiv, da die Maske mindestens ein Measure beinhalten muss.

All available measures will be displayed here. Using the button in front of the measure it can be added/removed. With the displayed name "all" all measures can be displayed with one click. When hiding all measures one remains active as a mask has to include at least one measure.

Measures also can moved to the mask by using Drag&Drop in the mask or in the fields area.

Display definition

The display definition shows which dimensions are shown on which axis, which measures are shown and which filters are set.

Select an element an "DEL" a element can be removed. Alternatively these elements can be removed too by moving them to the dimension/measure area above.

Dimensions which are defined on rows/columns can be filter with the filter symbol besides the dimension name.

Axes can be switched by using the symbol between column and rows area.

Measures can be moved to the other axis by clicking on the symbol right beside the measure.

Filter bar

In the filter you can see - as opposed to the windows client - only dimensions which are not defined as axis. Filter settings for dimension which are defined as axis can be done by using the filter symbol in the filter area which is shown besides the dimension or column.

Data area

In the data area measures and axis are displayed which can be changed. In the data area you can see all measures which are defined as measures in the fields area.

Input of greater values with the help of the input of letter

In order to make the input of big values easier, there can be added a letter to an entered number to add aditional zeros automatically.

Input	Result of the input
1m	1.000.000
1t	1.000
1k	1.000

Hint  (available from CoP 10 HF 3.5) The usage of this letters can now also be combined with the cell functions that can be used through entering a "=" at the beginning of your edit in order to perform mathematical operations.

Example: Current cell value: 1.000. Enter the following: =+5k then hit enter. Now it is calculated 1.000 + 5.000 and the result (6.000) is written into the cell. (Hint: This is only possible when the "AllowCellFunctions" flag is set to yes in the input mask settings.)

Implemented functions

A list of all implemented functions in the input mask can be found here.