instantOLAP Online documentation 2.2.7 - Stopshift

Stopshift

Type

Constant Integer (Number of seconds)

Since

1.2

Description

The "Stop" property only allows to set the stop-time to a constant year, month or day or to the current year, month or day. It is not possible to create a Time-Keyloader which e.g. stop tomorrow, because this is a relative setting. This property allows to shift the stop-time forward or backwards by setting the number of seconds (positive or negative) to shift.

Examples

Stop = "dd.MM.yyyy"

Endshift = "86400"

This setting lets the loader stop tomorrow, because the original end (today) defined by the "Stop" property is shifted forward by 24 * 60 * 60 (= 86400) seconds.

See also

Start, Stop

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
Exclude Pattern
Exclude Values
Language
Level Name
Locale Format
Mode
Parent
Pattern
Start
Startshift
Stop
Stopshift
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