instantOLAP Online documentation 2.2.7 - Type

Type

Type

Constant String

Since

2.2

Description

Attributes can either have a basic type (string, integer, double, boolean, date) or point to a key from another dimension (then called a "link"). You can define the type of an attribute with this, it will automatically converted when loading the attribute. By default, the type of an attribute is "string".

If you want the attribute to point to another dimension, you must specify the target-dimension with this property by using the target dimension-name as type-name. The loader will then search for a key in the target-dimension with the ID generated with the property SQL-Expression and generate a link to this key.

If no key with the ID was found, the system will raise an error and stop loading the model. This behaviour can be changed with the property Ignore Missing Targets.

Examples

Type = "String"

Type = "Integer"

Type = "Customer"

This attribute will become a link to the dimension "Customer"

See also

Ignore Missing Targets, Relink-Attribute

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
Alias
Link
Link-Expression
Table-Expression
CSV-Source
CSV-Column
XMLA-Source
Dimension
Grant
Key
Key-Attribute
SQL-Keyloader
SQL-Attribute
Format
Ignore Missing Targets
Name
Null-Value
Relink-Attribute
SQL-Expression
Target Attribute
Trim
Type
Unique
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