instantOLAP Online documentation 2.2.7 - Parent Column

Parent Column

Type

Constant String (Name of the column)

Since

1.2

Description

The optional property "Parent-Column" sets the column of the CSV-source which contains the IDs of the parent keys. Setting the Parent-Column will not create the parent keys - it only defines the IDs of the keys under which the loaded keys will be sorted. If no parent key with this ID exists, a key will not be loaded anyway.

If no Parent-Column was defined, the Keyloader will use the ID-Column of the surrounding CSV-Loader as it's Parent-Column (for example when you dragged a Keyloader onto another one). Embedded Keyloaders are the common case and defining your own Parent-Expression with this property is quite advanced.

Examples

Parent Column = "4"

Parent Column = "Category"

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
CSV-Keyloader
Column
CSV-Source
Format
Level Name
Mode
Null-Value
Parent Format
Parent Column
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