instantOLAP Online documentation 2.6.1 - Type

Type

Type

Constant String (comma separated table names)

Since

2.6.0

Description

If the expression defined for this table expression is escaped (means, it uses the phrase @"..." to escape its content), the SQL generator can no longer decide which tables are used by this expression and cannot add them to the FROM clause of the generated statement whenever this table expression is used.

This may cause a runtime error whenever this expression is used. To avoid this you can give a hint to the SQL generator by listing all used tables, separated by commas, in this property.

Examples

Used Tables = "PRODUCTS,CATEGORIES"

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Concepts
Query properties
Chart properties
Configuration properties
Configuration
Database
Table
Column
Alias
Link
Link-Expression
Table-Expression
Name
SQL-Expression
Table
Type
Type
Dimension
Grant
Key
Key-Attribute
SQL-Keyloader
SQL-Attribute
Time-Keyloader
Time-Attribute
Number-Keyloader
SQL-Cube
SQL-Dimension
SQL-Fact
Store
Store Dimension
Store Fact
Formula
File-Cache
Include
Expressions
Formats
SQL-Expressions