instantOLAP Online documentation 2.6.1 - Exclude Pattern

Exclude Pattern

Type

Date format

Since

1.2

Description

The Time-Keyloader allows the exclusion of keys when generating them (exclusion means you don't want to generate keys for special dates or days, e.g. weekends). The exclusion needs two different properties: The Exclude-Pattern (this property) and the Exclude Values. This property defines an additional Date format, which will generate a string for each key. If this string is contained in the Exclude-Values, the key won't be added to the dimension. The Exclude-values must contain a comma-separated list of strings.

Examples

Exclude-Pattern = "eee"

Exclude-Values = "Sat,Sun"

This example avoids adding weekend-days to the dimension, because the pattern "eee" (weekday) results to "Sat" or "Sun" for weekend-days, which are included in the Exclude-values.

See also

Exclude Values

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
Time-Keyloader
Exclude Pattern
Exclude Values
Language
Level Name
Locale Format
Mode
Parent
Pattern
Start
Startshift
Stop
Stopshift
Unit
Time-Attribute
Number-Keyloader
SQL-Cube
SQL-Dimension
SQL-Fact
Store
Store Dimension
Store Fact
Formula
File-Cache
Include
Expressions
Formats
SQL-Expressions