WebApps:Row View

Available from 9.5 HF 2.1

System requirements

The requirements can be found here.

Invocation

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

Example:

https://servername:4444/coplanner/pivottable/?tableform=ZS 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/?tableform=ZS Umsatzerloese Plan&Title=Zeilensicht Umsätze PLAN&Description=Detailinformationen zu Ihren Umsätzen&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.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.

IIF([ErloesKosten LC]<>0,'@Session_WebAppUrl@/pivottable/?pivotform=MAX_Rueckstellungen_PLAN&contextFilters="SonstigeErloesundKostenarten" mu [Attribut_SonstigeErloesundKostenarten] and "Zeit" mu [Zeit.ID] and "PC/KST" mu [PC/KST.ID]&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:

Filteroperand	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.
	Create new data records.
	Deletion of data.
	Back to superior mask.

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.

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.

Filter area for columns

Measures/dimension which are defined in the data area can be filtered directly in the area between description of the measures/dimensions and the data.

Entered data for the filtering can be removed with the "x".

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.

Implemented functions

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