instantOLAP Online documentation 2.2.7 - Match

Match

Type

Boolean

Since

1.2

Description

For each mapping of a fact you can add an optional match-expression. The fact will only be bound to the column defined in the Column property if the boolean-expression stored in this property (which can depend on any dimension) returns "true".

With the match-expression it is possible to match multiple columns to the same fact, each for a different part of the cube (e.g. you can map on column for each month).

Examples

Match = "HASKEYS( Time:'2004' )"

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
CSV-Attribute
Time-Keyloader
Time-Attribute
XMLA-Keyloader
XMLA-Attribute
Number-Keyloader
SQL-Cube
SQL-Fact
SQL-Dimension
CSV-Cube
CSV-Fact
Column
Fact
Match
CSV-Dimension
XMLA-Cube
XMLA-Fact
XMLA-Dimension
Formula
File-Cache
File-Store
Include
Expressions
Formats
SQL-Expressions