instantOLAP Online documentation 2.6.1 - Schema

Schema

Type

Constant String

Since

2.2.2

Description

For manually defined tables you can specify the name of the schema they are located in with this property. When setting this property to another value than empty, the SQL-generator will output this schema-name before the table-name every time the table is used.

Examples

Schema = ""

E.g. generates the SQL-statement "SELECT ... FROM SALES ..."

Schema = "ERP"

E.g. generates the SQL-statement "SELECT ... FROM ERP.SALES ..."

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
Name
Schema
Column
Alias
Link
Link-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