instantOLAP Online documentation 2.2.7 - SQL-Where

SQL-Where

Type

SQL Expression

Since

1.1

Description

Use this property to filter the result-set of the SQL-query performed by this SQL-Keyloader. The WHERE-condition defined by this optional property will be appended to the generated SQL-statement every time the loader is executed. The property expects a SQL-expression with a boolean result-type (means only use true, false or comparators in the WHERE-property).

Examples

SQL-Where = "Products.State = '1'"

Only load products with state "1"

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Query properties
Chart properties
Configuration properties
Configuration
Database
Table
Column
Alias
Link
Link-Expression
Table-Expression
CSV-Source
CSV-Column
XMLA-Source
Dimension
Grant
Key
Key-Attribute
SQL-Keyloader
Database
Distinct
Format
Ignore Hierarchy Violation
Level Name
Mode
Null-Value
Order-By-ID
Parent Attribute
Parent Format
Parent Null-Value
Parent SQL-Expression
Parent Trim
Recursive
SQL-Check
SQL-Expression
SQL-Order
SQL-Order Descending
SQL-Where
Trim
SQL-Attribute
CSV-Keyloader
CSV-Attribute
Time-Keyloader
Time-Attribute
XMLA-Keyloader
XMLA-Attribute
Number-Keyloader
SQL-Cube
SQL-Fact
SQL-Dimension
CSV-Cube
CSV-Fact
CSV-Dimension
XMLA-Cube
XMLA-Fact
XMLA-Dimension
Formula
File-Cache
File-Store
Include
Expressions
Formats
SQL-Expressions