instantOLAP Online documentation 2.6.1 - Target Expression

Target Expression

Type

SQL Expression

Since

2.0.1

Description

With this property you can define the target-expression of the link used by the SQL-generator. The target-expression can be a simple table/column expression or a more complex expression, e.g. a function call in SQL.

Note: If you define more than one Link-Expression for one Link, all target-expression must use the same table as base. Otherwise an error will be raised by the system.

Examples

Target Expression = "sales.productID"

Target Expression = "@SUBSTR( sales.date, 1, 4 )"

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
Operator
Source Expression
Target Expression
Table-Expression
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