WebApps:Input Mask: Implemented functions: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
← Older edit
VisualWikitext
No edit summary
No edit summary
 
(8 intermediate revisions by the same user not shown)
Line 9: Line 9:
| Caption
| Caption
| Property
| Property
|- {{Tabellentitel}}
| Available
| Chart area
|
|-
| '''DiagramAvailable'''
| Defines whether the [[Framework:BI_Center:Show_chart|chart]] is available.
|-
| '''DiagramSplitterPosition'''
| Defines the position of the splitter between the [[Framework:BI_Center:Show_chart|chart]] and the grid.
|-
| '''DiagramVisible'''
| Defines whether the [[Framework:BI_Center:Show_chart|chart]] is shown initial.
|- {{Tabellentitel}}
|- {{Tabellentitel}}
| Format
| Format
|  
|  
|
|-
|-
| '''ConditionalStyles'''
| '''ConditionalStyles'''
| Opens the dialogue to define [[Framework:BI-Center:Conditional Formatting|conditional formatting]].
| Opens the dialogue to define [[Framework:BI-Center:Conditional Formatting|conditional formatting]].
| Yes
|-
|-
| '''StyleSheet'''
| '''StyleSheet'''
| Name of the style sheet.
| Name of the style sheet.
| Yes
|- {{Tabellentitel}}
|- {{Tabellentitel}}
| General
| General
|  
|  
|
|-
|-
| '''AutoSave'''
| '''AutoSave'''
| Defines whether the data are saved automatically after data entry.
| Defines whether the data are saved automatically after data entry.
| Yes
|-
|-
| '''BeforeOpen'''
| '''BeforeOpen'''
| Executes an import or a macro before the mask opens.
| Executes an import or a macro before the mask opens.
| Yes
|-
|-
| '''DataObjectName'''
| '''DataObjectName'''
| Name of the data object.
| Name of the data object.
|
|-
|-
| '''GridReadOnly'''
| '''GridReadOnly'''
| Defines if the user is allowed to change the data in the mask.
| Defines if the user is allowed to change the data in the mask.
| Yes
|-
|-
| '''InitialAutoSize'''
| '''InitialAutoSize'''
| Automatically resize of columns.
| Automatically resize of columns.
| No
|-
|-
| '''MacroOnSave'''
| '''MacroOnSave'''
| Defines whether a macro will be executed on save.
| Defines whether a macro will be executed on save.
| Yes
|-
|-
| '''MacroOnSaveContext'''
| '''MacroOnSaveContext'''
| The confiugred context here will be given to the macro defined at MacroOnSave.  
| The confiugred context here will be given to the macro defined at MacroOnSave.  
| Yes
|-
|-
| '''MacroOnSaveRefreshAfterwards'''
| '''MacroOnSaveRefreshAfterwards'''
| Defines whether an automatically refresh is done after the execution of the macro defined at 'MacroOnSave' or not. (New in 9.4.3 HF 1.3)
| Defines whether an automatically refresh is done after the execution of the macro defined at 'MacroOnSave' or not.
| Yes
|-
|-
| '''MaxDimensionsOnAxis'''
| '''MaxDimensionsOnAxis'''
| Restricts the maximum number of dimensions per axis in this object.
| Restricts the maximum number of dimensions per axis in this object.
| Yes
|-
|-
| '''NullSuppress'''
| '''NullSuppress'''
Line 66: Line 68:
:*Null – Suppress just "Null"
:*Null – Suppress just "Null"
:*Number – Suppress Null and "0"
:*Number – Suppress Null and "0"
| Yes
|-
|-
| '''RefreshManually'''
| '''RefreshManually'''
| Defines wheter the mask will be refreshed automatically or manually.  
| Defines wheter the mask will be refreshed automatically or manually.  
| No
|-
|-
| '''SaveButtonVisible'''
| '''SaveButtonVisible'''
| Defines wheter the Save-Button is visible or not.
| Defines wheter the Save-Button is visible or not.
| Yes
|-
|-
| '''WaitForCalc'''
| '''WaitForCalc'''
| Refresh takes place after calculation of the first level.
| Refresh takes place after calculation of the first level.
| No
|- {{Tabellentitel}}
|- {{Tabellentitel}}
| Information area
| Information area
|
|
|
|-
|-
Line 85: Line 92:


On the left side you allocate and delete masks or reports, which will be shown in the info area. On the right side you choose between mask or report, the mask or report to be shown, the kind of access and the synchronization.
On the left side you allocate and delete masks or reports, which will be shown in the info area. On the right side you choose between mask or report, the mask or report to be shown, the kind of access and the synchronization.
| No
|-
|-
| '''InheritStyle'''
| '''InheritStyle'''
| Defines whether the style sheet of the base mask should be taken.
| Defines whether the style sheet of the base mask should be taken.
| No
|-
|-
| '''InitialOpen'''
| '''InitialOpen'''
| Indicates whether the information area is visible initially.
| Indicates whether the information area is visible initially.
| No
|-
|-
| '''Position'''
| '''Position'''
Line 98: Line 108:
:*Bottom
:*Bottom
:*Left
:*Left
| No
|-
|-
| '''SplitterDistance'''
| '''SplitterDistance'''
| Height of the info area in pixel.
| Height of the info area in pixel.
| No
|-{{Tabellentitel}}
|-{{Tabellentitel}}
|Legend
|Legend
|
|
|
|-
|-
| '''LegendVisible'''
| '''LegendVisible'''
| Defines wheter the [[Enterprise_Edition:Legend_Conditional_Formatting|legend for the conditional formatting]] is shown beneath the data area.
| Defines wheter the [[Enterprise_Edition:Legend_Conditional_Formatting|legend for the conditional formatting]] is shown beneath the data area.
| No
|-
|-
| '''ShowLegendRibbon'''
| '''ShowLegendRibbon'''
| Defines wheter the button for handling the visablity of the [[Enterprise_Edition:Legend_Conditional_Formatting|legend]] will be shown in the ribbon or not.
| Defines wheter the button for handling the visablity of the [[Enterprise_Edition:Legend_Conditional_Formatting|legend]] will be shown in the ribbon or not.
| No
|- {{Tabellentitel}}
|- {{Tabellentitel}}
| Mask
| Mask
|
|
|
|-
|-
Line 119: Line 135:
:*unhidable  
:*unhidable  
:*hidable
:*hidable
| Yes
|-
|-
| '''AllowDrillThroughWithoutData'''
| '''AllowDrillThroughWithoutData'''
| Defines whether the single row triangle is shown or not in case of empty data records.
| Defines whether the single row triangle is shown or not in case of empty data records.
| Yes
|-
|-
| '''AllowSelectMeasures'''
| '''AllowSelectMeasures'''
| Defines whether the user is allowed to select the measures.
| Defines whether the user is allowed to select the measures.
| Yes
|-
|-
| '''AllowSwitchAxis'''
| '''AllowSwitchAxis'''
| Defines whether the user is allowed to switch the axes.
| Defines whether the user is allowed to switch the axes.
| Yes
|-
|-
| '''AllowToggleMeasure'''
| '''AllowToggleMeasure'''
| Indicates whether a measure can be hidden by a right mouse click.
| Indicates whether a measure can be hidden by a right mouse click.
| No
|-
|-
| '''DrillThroughOnlyWhenDefined'''
| '''DrillThroughOnlyWhenDefined'''
| Defines, whether the single row triangle is shown only if a detail mask is defined.
| Defines, whether the single row triangle is shown only if a detail mask is defined.
| Yes
|- {{Tabellentitel}}
|- {{Tabellentitel}}
| Navigation
| Navigation
|
|
|
|-
|-
| '''DataAssistantDesigner'''
| '''DataAssistantDesigner'''
| Opens the dialogue „[[Framework:BI_Center:Data Assistant Designer|Data Assistant Designer]]“ to configure the „[[Data_Transfer_Assistant|Data Transfer Assistant]]“ .
| Opens the dialogue „[[Framework:BI_Center:Data Assistant Designer|Data Assistant Designer]]“ to configure the „[[Data_Transfer_Assistant|Data Transfer Assistant]]“ .
| No
|-
|-
|'''ExcelExportAvailable'''
|'''ExcelExportAvailable'''
|Defines whether the [[Enterprise_Edition:Excel_Export|Excel export]] is available.
|Defines whether the [[Enterprise_Edition:Excel_Export|Excel export]] is available.
| Yes
|-
|-
| '''Macros'''
| '''Macros'''
| Here, [[Framework:BI_Center:Makrodescriptor-Editor|macros]] can be added to the view. They are provided for the user in the ribbons..
| Here, [[Framework:BI_Center:Makrodescriptor-Editor|macros]] can be added to the view. They are provided for the user in the ribbons..
| Yes
|-
|-
| '''NullSuppressSelectable'''
| '''NullSuppressSelectable'''
| Defines whether null suppress is available.
| Defines whether null suppress is available.
| Yes
|-
|-
|'''PrintAvailable'''
|'''PrintAvailable'''
|Defines whether [[Enterprise_Edition:Printing|"Print"]] is available.
|Defines whether [[Enterprise_Edition:Printing|"Print"]] is available.
| No
|-
|-
|'''ReportWizardAvailable'''
|'''ReportWizardAvailable'''
|Defines whether the report wizard is available.
|Defines whether the report wizard is available.
| No
|-
|-
|'''UserViewCanBeSaved'''
|'''UserViewCanBeSaved'''
|User can save views.
|User can save views.
| No
|-
|-
|'''UserViewSaveAutomatically'''
|'''UserViewSaveAutomatically'''
|User view is saved automatically.
|User view is saved automatically.
| No
|- {{Tabellentitel}}
|- {{Tabellentitel}}
| Other
| Other
|
|
|
|-
|-
| '''SpecialDefinition'''
| '''SpecialDefinition'''
|Definition of extended functionalities with [[:Category:Functions_-_client-side|client-side]] or [[:Category:Functions_-_server-side|server-side]] functions.
|Definition of extended functionalities with [[:Category:Functions_-_client-side|client-side]] or [[:Category:Functions_-_server-side|server-side]] functions.
| Some special definition as Rulefilters.
|-{{Tabellentitel}}
|-{{Tabellentitel}}
|Webclient
|
|-
| '''AutomatedLoginAfterExcelExportAvailable'''
|Defines whether the button for the excel export with automated login is available or not in web.
|}




Line 179: Line 206:
In design view of an [[Framework:BI_Center:Create_Input_Mask|input mask]] or an [[Framework:BI_Center:Create_Analysis_View|analysis view]] the right side of the designer shows the properties of an [[Framework:BI_Center:Create_Input_Mask|input mask]] or an [[Framework:BI_Center:Create_Analysis_View|analysis view]]. Select a dimension to edit the properties.
In design view of an [[Framework:BI_Center:Create_Input_Mask|input mask]] or an [[Framework:BI_Center:Create_Analysis_View|analysis view]] the right side of the designer shows the properties of an [[Framework:BI_Center:Create_Input_Mask|input mask]] or an [[Framework:BI_Center:Create_Analysis_View|analysis view]]. Select a dimension to edit the properties.


{| class="wikitable" width="857px"
{| class="wikitable" width="80%"
|- {{Tabellentitel}}  
|- {{Tabellentitel}}  
| Caption  
| Caption  
| Property
| Property
|Available
|- {{Tabellentitel}}  
|- {{Tabellentitel}}  
| Filter settings
| Filter settings
|  
|  
|
|-
|-
| '''AllowDragDrop'''
| '''AllowDragDrop'''
| Defines whether a dimension can be moved by drag & drop.
| Defines whether a dimension can be moved by drag & drop.
| No
|-
|-
|'''DisplayOptionFilter'''
|'''DisplayOptionFilter'''
|Offers the possibility to place an attribute of the dimension in the filter instead of the dimension member.
|Offers the possibility to place an attribute of the dimension in the filter instead of the dimension member. You can find more information [[Masks:Alternative_dimension_element_names|here]].
| Yes
|-
|-
| '''FilterReadOnly'''
| '''FilterReadOnly'''
| Defines whether the user can change the filter setting.
| Defines whether the user can change the filter setting.
| Yes
|-
|-
| '''FilterRemoveable'''
| '''FilterRemoveable'''
| Defines this filter not removable.
| Defines this filter not removable.
| Yes
|-
|-
| '''FilterSessionKey'''
| '''FilterSessionKey'''
| Defines the default value of the filter when the view is opened. All CoPlanner [[Framework:Session_variables|environment variables]] including [[Framework:Application_Properties|application properties]] are available for selection.
| Defines the default value of the filter when the view is opened. All CoPlanner [[Framework:Session_variables|environment variables]] including [[Framework:Application_Properties|application properties]] are available for selection.
| Yes
|-
|-
| '''FilterVisibilityChangeable'''
| '''FilterVisibilityChangeable'''
| Defines whether the visibility of the filter is changeable.
| Defines whether the visibility of the filter is changeable.
| Yes
|-
|-
| '''FilterVisible'''
| '''FilterVisible'''
| Defines whether or not the filter is visible as a default. Even if the filter is hidden, it does nevertheless affect the result of the query. In design mode all not visible filters will be shown gray.
| Defines whether or not the filter is visible as a default. Even if the filter is hidden, it does nevertheless affect the result of the query. In design mode all not visible filters will be shown gray.
| Yes
|-
|-
|'''KeepFilter'''
|'''KeepFilter'''
|Defines whether or not the filter is shown in case of the mask is used as detail mask.
|Defines whether or not the filter is shown in case of the mask is used as detail mask.
| No
|-
|-
| '''MarkNonLeavesReadOnly'''
| '''MarkNonLeavesReadOnly'''
| All parent elements are read only. The decision if a parent element is a parent element is made on the result in the mask and not on the whole dimension.
| All parent elements are read only. The decision if a parent element is a parent element is made on the result in the mask and not on the whole dimension.
| Yes
|-
|-
| '''NonLeafReadOnlyIfEmpty'''
| '''NonLeafReadOnlyIfEmpty'''
| Only parent elements will be displayed readonly if their children have no data.  
| Only parent elements will be displayed readonly if their children have no data.  
| No
|-
|-
| '''OnlyPlanTime'''
| '''OnlyPlanTime'''
| Only plan period will be displayed.
| Only plan period will be displayed.
| Yes
|-
|-
| '''OpenElementTyp'''
| '''OpenElementTyp'''
| Shows the dimension with this start element.
| Shows the dimension with this start element.


{| class="wikitable" width="857px"
{| class="wikitable" width="857px"
Line 258: Line 299:
| Just the root element is shown.
| Just the root element is shown.
|}
|}
 
| Yes
|-
|-
| '''SuppressedElements'''
| '''SuppressedElements'''
| Defines which elements are hidden.
| Defines which elements are hidden.
| Yes
|- {{Tabellentitel}}  
|- {{Tabellentitel}}  
| Format
| Format
|  
|  
|
|-
|-
| '''UseDimensionLayout'''
| '''UseDimensionLayout'''
| The style of the dimension administration is used.
| The style of the dimension administration is used.
| No
|- {{Tabellentitel}}  
|- {{Tabellentitel}}  
| General
| General
|  
|  
|
|-
|-
| '''FilterCaption'''
| '''FilterCaption'''
| Defines the caption of a filter.
| Defines the caption of a filter.
| Yes
|-
|-
| '''FilterName'''
| '''FilterName'''
| Shows the system name of the filter.
| Shows the system name of the filter.
|
|- {{Tabellentitel}}  
|- {{Tabellentitel}}  
| Other
| Other
|  
|  
|
|-
|-
| '''SpecialDefinition'''
| '''SpecialDefinition'''
| Definition of extended functionalities with [[:Category:Functions_-_client-side|client-side]] or [[:Category:Functions_-_server-side|server-side]] functions.
| Definition of extended functionalities with [[:Category:Functions_-_client-side|client-side]] or [[:Category:Functions_-_server-side|server-side]] functions.
| Yes
|}
|}


Line 292: Line 341:
| Caption  
| Caption  
| Property
| Property
|Available
|- {{Tabellentitel}}
|- {{Tabellentitel}}
| Format
| Format
|  
|  
|
|-
|-
| '''BgColor'''
| '''BgColor'''
| Defines the measure background color in the view.
| Defines the measure background color in the view.
| Yes
|-
|-
| '''BgColorIntensity'''
| '''BgColorIntensity'''
| Intensity of the background color. 0 is completely transparent.
| Intensity of the background color. 0 is completely transparent.
| Yes
|-
|-
| '''ColumnFormat'''
| '''ColumnFormat'''
| Overrides the [[Framework:Formatstrings|number format]] of the measure.
| Overrides the [[Framework:Formatstrings|number format]] of the measure.
| Yes
|-
|-
| '''ColumnWidth'''
| '''ColumnWidth'''
| Defines the column width of the measure.
| Defines the column width of the measure.
| Yes
|-
|-
|'''ConditionalStyles'''
|'''ConditionalStyles'''
|Opens the dialogue to define [[Framework:BI-Center:Conditional Formatting|conditional formatting]].
|Opens the dialogue to define [[Framework:BI-Center:Conditional Formatting|conditional formatting]].
| Yes
|-
|-
|'''HeaderBgColor'''
|'''HeaderBgColor'''
|[[Framework:Color_Picker|Background color]] of the measure headline.
|[[Framework:Color_Picker|Background color]] of the measure headline.
| Yes
|-
|-
|'''HeaderFontColor'''
|'''HeaderFontColor'''
|[[Framework:Color_Picker|Font color]] of the measure headline.
|[[Framework:Color_Picker|Font color]] of the measure headline.
| Yes
|- {{Tabellentitel}}
|- {{Tabellentitel}}
| General
| General
|  
|  
|
|-
|-
|'''Caption'''
|'''Caption'''
|Defines the name of the measure in the [[Framework:BI_Center:Formula_Editor|formula editor]] as it is shown in the user interface. This could be a simple string or consist of [[Tutorial:Dynamic_Measure_Captions|dynamic measure captions]]. '''Multiline captions''' for measure names can be created by inserting a line break (SHIFT+ENTER).  
|Defines the name of the measure in the [[Framework:BI_Center:Formula_Editor|formula editor]] as it is shown in the user interface. This could be a simple string or consist of [[Tutorial:Dynamic_Measure_Captions|dynamic measure captions]]. '''Multiline captions''' for measure names can be created by inserting a line break (SHIFT+ENTER).  
[[image:EE en multilinecaption.png|thumb|center|Enterprise Edition, Input Mask, Mulitline Captions]]
[[image:EE en multilinecaption.png|thumb|center|Enterprise Edition, Input Mask, Mulitline Captions]]
| Yes
|-
|-
|'''DiffValueText'''
|'''DiffValueText'''
|Text which will be shown if the elements are not unique.
|Text which will be shown if the elements are not unique.
| No
|-
|-
|'''Name'''
|'''Name'''
|Shows the system name of the filter.
|Shows the system name of the filter.
|
|-
|-
|'''ToolTip'''
|'''ToolTip'''
|Defines the tooltip. Tutorial: [[Tutorial:Dynamic_Measure_Captions|Dynamic Measure Captions]]
|Defines the tooltip. Tutorial: [[Tutorial:Dynamic_Measure_Captions|Dynamic Measure Captions]]
| Yes
|- {{Tabellentitel}}
|- {{Tabellentitel}}
|Measure settings
|Measure settings
|  
|  
|
|-
|-
|'''DataValidation'''
|'''DataValidation'''
|Definition of [[Framework:BI Center:Plausibility Check|plausibility check]]
|Definition of [[Framework:BI Center:Plausibility Check|plausibility check]]
| No
|-
|-
| '''DetailContext'''
| '''DetailContext'''
| Definition of [[Enterprise Edition:Context|Context]]  (=current filter settings in masks) other actions.  
| Definition of [[Enterprise Edition:Context|Context]]  (=current filter settings in masks) other actions.  
|
|-
|-
|'''DetailMask'''
|'''DetailMask'''
|Shows all masks, stored in the folder "Input Masks". If no detailed mask is selected, the table will be opened. Filter will be synchronized by the filter caption.
|Shows all masks, stored in the folder "Input Masks". If no detailed mask is selected, the table will be opened. Filter will be synchronized by the filter caption.
| Yes
|-
|-
| '''DisplayOn'''
| '''DisplayOn'''
Line 352: Line 419:
:* NonLeavesOnly: The measure will be shown only on parent elements.
:* NonLeavesOnly: The measure will be shown only on parent elements.
:* LeavesOnly: The measure will be shown only on leaves elements.
:* LeavesOnly: The measure will be shown only on leaves elements.
| No
|-
|-
|'''DisplayOptions'''
|'''DisplayOptions'''
|Offers the possibility to place an attribute of the dimension in the filter instead of the dimension member.
|Offers the possibility to place an attribute of the dimension in the filter instead of the dimension member.
| No
|-
|-
| '''LockCondition'''
| '''LockCondition'''
| Possibility to lock measure.
| Possibility to lock measure.
| Yes
|-
|-
| '''ReadOnly'''
| '''ReadOnly'''
| Defines whether the measure is read only or not.
| Defines whether the measure is read only or not.
| Yes
|-
|-
|'''Selectable'''
|'''Selectable'''
|Defines whether the measure is available.
|Defines whether the measure is available.
| Yes
|- {{Tabellentitel}}
|- {{Tabellentitel}}
|Other
|Other
|  
|  
|
|-
|-
| '''SpecialDefinition'''
| '''SpecialDefinition'''
| Definition of extended functionalities with [[:Category:Functions_-_client-side|client-side]] or [[:Category:Functions_-_server-side|server-side]] functions.
| Definition of extended functionalities with [[:Category:Functions_-_client-side|client-side]] or [[:Category:Functions_-_server-side|server-side]] functions.
| No
|}
|}


Line 375: Line 449:


[[Category:WebApps|Input_Mask]]
[[Category:WebApps|Input_Mask]]
[[de:WebApps:Eingabemaske:_Umgesetzte_Funktionen]]

Latest revision as of 11:19, 21 July 2020

Mask properties

In design view of an input mask or an analysis view you see on the right side of the designer the properties of an input mask or analysis view.


Dimension properties

In design view of an input mask or an analysis view the right side of the designer shows the properties of an input mask or an analysis view. Select a dimension to edit the properties.

Caption Property Available
Format
ConditionalStyles Opens the dialogue to define conditional formatting. Yes
StyleSheet Name of the style sheet. Yes
General
AutoSave Defines whether the data are saved automatically after data entry. Yes
BeforeOpen Executes an import or a macro before the mask opens. Yes
DataObjectName Name of the data object.
GridReadOnly Defines if the user is allowed to change the data in the mask. Yes
InitialAutoSize Automatically resize of columns. No
MacroOnSave Defines whether a macro will be executed on save. Yes
MacroOnSaveContext The confiugred context here will be given to the macro defined at MacroOnSave. Yes
MacroOnSaveRefreshAfterwards Defines whether an automatically refresh is done after the execution of the macro defined at 'MacroOnSave' or not. Yes
MaxDimensionsOnAxis Restricts the maximum number of dimensions per axis in this object. Yes
NullSuppress Defines the null suppress state.
  • None – non null suppress
  • Null – Suppress just "Null"
  • Number – Suppress Null and "0"
 Yes
RefreshManually Defines wheter the mask will be refreshed automatically or manually. No
SaveButtonVisible Defines wheter the Save-Button is visible or not. Yes
WaitForCalc Refresh takes place after calculation of the first level. No
Information area
InfoAreaMasks Choose masks or CoPlanner reports to be shown in the info area.
Error creating thumbnail: File missing
Framework, BI Center, Editor

On the left side you allocate and delete masks or reports, which will be shown in the info area. On the right side you choose between mask or report, the mask or report to be shown, the kind of access and the synchronization.

No
InheritStyle Defines whether the style sheet of the base mask should be taken. No
InitialOpen Indicates whether the information area is visible initially. No
Position Defines the position of the information area. Following options are available:
  • Top
  • Right
  • Bottom
  • Left
 No
SplitterDistance Height of the info area in pixel. No
Legend
LegendVisible Defines wheter the legend for the conditional formatting is shown beneath the data area. No
ShowLegendRibbon Defines wheter the button for handling the visablity of the legend will be shown in the ribbon or not. No
Mask
AllowDrillThrough Defines whether the user is allowed to open the single set mode. The following options are possible
  • activated
  • unhidable
  • hidable
 Yes
AllowDrillThroughWithoutData Defines whether the single row triangle is shown or not in case of empty data records. Yes
AllowSelectMeasures Defines whether the user is allowed to select the measures. Yes
AllowSwitchAxis Defines whether the user is allowed to switch the axes. Yes
AllowToggleMeasure Indicates whether a measure can be hidden by a right mouse click. No
DrillThroughOnlyWhenDefined Defines, whether the single row triangle is shown only if a detail mask is defined. Yes
Navigation
DataAssistantDesigner Opens the dialogue „Data Assistant Designer“ to configure the „Data Transfer Assistant“ . No
ExcelExportAvailable Defines whether the Excel export is available. Yes
Macros Here, macros can be added to the view. They are provided for the user in the ribbons.. Yes
NullSuppressSelectable Defines whether null suppress is available. Yes
PrintAvailable Defines whether "Print" is available. No
ReportWizardAvailable Defines whether the report wizard is available. No
UserViewCanBeSaved User can save views. No
UserViewSaveAutomatically User view is saved automatically. No
Other
SpecialDefinition Definition of extended functionalities with client-side or server-side functions. Some special definition as Rulefilters.
Caption Property Available
Filter settings
AllowDragDrop Defines whether a dimension can be moved by drag & drop. No
DisplayOptionFilter Offers the possibility to place an attribute of the dimension in the filter instead of the dimension member. You can find more information here. Yes
FilterReadOnly Defines whether the user can change the filter setting. Yes
FilterRemoveable Defines this filter not removable. Yes
FilterSessionKey Defines the default value of the filter when the view is opened. All CoPlanner environment variables including application properties are available for selection. Yes
FilterVisibilityChangeable Defines whether the visibility of the filter is changeable. Yes
FilterVisible Defines whether or not the filter is visible as a default. Even if the filter is hidden, it does nevertheless affect the result of the query. In design mode all not visible filters will be shown gray. Yes
KeepFilter Defines whether or not the filter is shown in case of the mask is used as detail mask. No
MarkNonLeavesReadOnly All parent elements are read only. The decision if a parent element is a parent element is made on the result in the mask and not on the whole dimension. Yes
NonLeafReadOnlyIfEmpty Only parent elements will be displayed readonly if their children have no data. No
OnlyPlanTime Only plan period will be displayed. Yes
OpenElementTyp Shows the dimension with this start element.


Element Aktion
ALL All elements are shown.
ROOT Just root elements are shown.
ROOT1 Root elements and the first level are shown.
ROOT2 Root elements and the first two levels are shown.
ROOT3 Root elements and the first three levels are shown.
CHILDELEMENT Root elements and child elements are shown.
LIST All elements are shown.
LEAF All leaf elements are shown in a list.
PARENTELEMENT Just parent elements are shown.
ROOTELEMENT Just the root element is shown.
Yes
SuppressedElements Defines which elements are hidden. Yes
Format
UseDimensionLayout The style of the dimension administration is used. No
General
FilterCaption Defines the caption of a filter. Yes
FilterName Shows the system name of the filter.
Other
SpecialDefinition Definition of extended functionalities with client-side or server-side functions. Yes

Measure properties

In design view of an input mask or an analysis view the right side of the designer shows the properties of an input mask or an analysis view. Select a measure to edit the properties.

Caption Property Available
Format
BgColor Defines the measure background color in the view. Yes
BgColorIntensity Intensity of the background color. 0 is completely transparent. Yes
ColumnFormat Overrides the number format of the measure. Yes
ColumnWidth Defines the column width of the measure. Yes
ConditionalStyles Opens the dialogue to define conditional formatting. Yes
HeaderBgColor Background color of the measure headline. Yes
HeaderFontColor Font color of the measure headline. Yes
General
Caption Defines the name of the measure in the formula editor as it is shown in the user interface. This could be a simple string or consist of dynamic measure captions. Multiline captions for measure names can be created by inserting a line break (SHIFT+ENTER).
Error creating thumbnail: File missing
Enterprise Edition, Input Mask, Mulitline Captions
 Yes
DiffValueText Text which will be shown if the elements are not unique. No
Name Shows the system name of the filter.
ToolTip Defines the tooltip. Tutorial: Dynamic Measure Captions Yes
Measure settings
DataValidation Definition of plausibility check No
DetailContext Definition of Context (=current filter settings in masks) other actions.
DetailMask Shows all masks, stored in the folder "Input Masks". If no detailed mask is selected, the table will be opened. Filter will be synchronized by the filter caption. Yes
DisplayOn Defines whether the measure is visible or not in combination with the time dimension.
  • All: The measure is always visible.
  • MonthOnly: The measure will be shown only on months.
  • YearOnly: The measure will be shown only on years.
  • NonLeavesOnly: The measure will be shown only on parent elements.
  • LeavesOnly: The measure will be shown only on leaves elements.
 No
DisplayOptions Offers the possibility to place an attribute of the dimension in the filter instead of the dimension member. No
LockCondition Possibility to lock measure. Yes
ReadOnly Defines whether the measure is read only or not. Yes
Selectable Defines whether the measure is available. Yes
Other
SpecialDefinition Definition of extended functionalities with client-side or server-side functions. No
Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=WebApps:Input_Mask:_Implemented_functions&oldid=16133"