instantOLAP Online documentation 2.2.7 - Input

Input

Type

Boolean

Since

1.2

Description

Use this property to enable table-cells for input. It expects a Boolean-Expression which will be executed for each generated cell of this header. Each cell the expression returns "true" for (and the user has sufficient rights to edit the facts) will become edit able.

When using cell to input data, you should not use formulas for that cells, only iterations. Whenever you use a formula, the system wouldn't be able to backtrace the input-value to a single fact (which is possible if the fact was defined by one of the cell-headers iterations).

Note that only making table-cells edit able doesn't guarantee the values will be stored in any database. You also must enable to corresponding cube to store values back to their datasource. See the "Enable Store" property of SQL-cubes for more information.

Examples

Edit = "true"

Makes the whole row/column editable

Edit = "X() = 5"

Only makes column 5 editable

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Query properties
Multiple Query
Selector
Selector Group
Outer block
Inner block
Query
Header
Align
Assertion
Background
Bottom Color
Bottom Padding
Cell Align
Cell Background
Cell Bottom Color
Cell Bottom Padding
Cell Color
Cell Font
Cell Font Size
Cell Font Weight
Cell Left Color
Cell Left Padding
Cell Link
Cell Link Icon
Cell Link Keys
Cell Link Name
Cell Link Target
Cell Right Color
Cell Right Padding
Cell Top Color
Cell Top Padding
Cell Vertical Align
Drilldown
Drilldown Encapsulate
Drilldown Iteration
Drilldown Prefetch
Filter
Font
Font Size
Font Weight
Foreground
Format
Formula
Group By
Height
Input
Iteration
Left Color
Left Padding
Link
Link Icon
Link Keys
Link Name
Link Target
Right Color
Right Padding
Rotate
Sort
Sort Descending
Text
Title
Top Color
Top Padding
Vertical Align
Visible
Width
Z-Order
Comment
Chart properties
Configuration properties
Expressions
Formats
SQL-Expressions