instantOLAP Online documentation 2.2.7 - Type

Type

Type

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

Since

1.0

Description

For self-defined tables you must define all it's 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
Query properties
Chart properties
Configuration properties
Configuration
Database
Table
Column
Name
Type
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
SQL-Dimension
CSV-Cube
CSV-Fact
CSV-Dimension
XMLA-Cube
XMLA-Fact
XMLA-Dimension
Formula
File-Cache
File-Store
Include
Expressions
Formats
SQL-Expressions