instantOLAP Online documentation 2.2.7 - Suppress Rows

Suppress Rows

Type

Boolean

Since

1.1

Description

If the "Suppress Rows" expression returns true, all empty rows will be deleted from the query-result and only rows containing at least one value will be visible. The suppress-feature only pays attentions to the table-cells, not to the headers (which still may contain text when the column is deleted).

Note that event with "Suppress Rows" enabled, the whole query will be executed and generated in memory before the columns will be deleted. To avoid performance-problems, you shouldn't use the "Suppress-Cols" or "Suppress-Rows" property to reduce sparse filled results. In this case, use the LOOKUP-function for better performance.

Examples

Suppress-Rows = "true"

See also

Suppress Cols

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
Corner Align
Corner Background
Corner Bottom Color
Corner Font
Corner Font Size
Corner Font Weight
Corner Foreground
Corner Left Color
Corner Right Color
Corner Text
Corner Top Color
Corner VAlign
Filter
Highlight Color
Span Headers
Subcube
Suppress Cols
Suppress Rows
Header
Comment
Chart properties
Configuration properties
Expressions
Formats
SQL-Expressions