instantOLAP Online documentation 2.2.7 - SQL-Where

SQL-Where

Type

SQL Expression

Since

2.2.6

Description

This property defines an SQL where expression, which will be appended if (and only if) the fact is queried from the SQL cube.

Examples

SQL-Where = "SALES.TYPE = 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
SQL-Attribute
CSV-Keyloader
CSV-Attribute
Time-Keyloader
Time-Attribute
XMLA-Keyloader
XMLA-Attribute
Number-Keyloader
SQL-Cube
SQL-Fact
Fact
Level
Match
SQL-Expression
SQL-Where
SQL-Dimension
CSV-Cube
CSV-Fact
CSV-Dimension
XMLA-Cube
XMLA-Fact
XMLA-Dimension
Formula
File-Cache
File-Store
Include
Expressions
Formats
SQL-Expressions