instantOLAP Online documentation 2.6.1 - Type

Type

Type

Constant String ('string','integer','double' or 'date')

Since

1.0

Description

For self-defined tables you must also define all of its column and their type. This property defines the type of column and must have one of the values 'string', 'integer', 'double' or 'date'. In instantOLAP there are only a few number of types for columns, less than the most databases have. All columns are converted (if possible) from the database-type to the instantOLAP type when reading the result from the query.

Examples

Type = "integer"

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
Name
Type
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