instantOLAP Online documentation 2.6.1 - Target Attribute

Target Attribute

Type

Constant String

Since

2.0

Description

This property allows the more advanced linking between keys of two different dimensions.

The "Type" property of an Attribute-Loader allows the simple linking between two keys by searching the target-key with its id. But sometimes the source-Keyloader can't link to the target-keys with the id, because it is not possibility to load the target-id from its database or tables (or it might be too time-consuming because a couple of database-join would become necessary then).

In this case you might try to connect two keys by searching the target-key with one of its attributes which is known by the source-key. E.g. if the table you load the source-keys "Product" from has a column "MANUFACTURER_ID", you can link the products to their manufacturers by searching them with their ManufacturerID. Of course, the manufacturers must have a so called attribute, otherwise the system would raise an error.

Examples

Target-Attribute = "CustomerID"

Search the target-keys by its Customer-ID

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
Alias
Link
Link-Expression
Table-Expression
Dimension
Grant
Key
Key-Attribute
SQL-Keyloader
SQL-Attribute
Description
Format
Ignore Missing Targets
Load Distinct
Name
Null-Value
Relink-Attribute
SQL-Expression
Target Attribute
Trim
Type
Unique
Unit
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